Simple remote MySQL database in VB App | Free source code, tutorials and articles

Search

Simple remote MySQL database in VB App

Submitted by emond on Fri, 05/29/2009 - 20:18

Level: Intermediate
Language: Visual Basic

6142 reads

a simple database app that can be used to manipulate your website's MYSQL database, applicable in administrating your web databse from your Windows based PC .Connection is via MySQL ODBC 3.51 Driver. CAn perform CRUD and it shows how to connect and query records in a remote server (for this sample i used www.freesql.org) using ADOdb control and datagrid to show data from remote server..

I'll Post my VB to IBM AS400 Server connectivity projects soon...please watch out

Hope you like it..

TODO:

download the MySql odbc driver 3.51 driver in mysql websites..

questions and design projects?

http://emondsoft.qapacity.com/

Pm or email me

dark_raditz@0825yahoo.com

09212279363

Average:

Your rating: None

Download Code

vbmysql.txt

Your Vote!

Average:

Your rating: None

Note

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note:All files are scanned once-a-day by SourceCodester.com for viruses,but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

6142 reads

Remote MySQL Access

Submitted by Anonymous on Wed, 02/03/2010 - 02:00.

Great code to access MySQL remotly with ADO

Confused though

I can access every single table from the MySQL database except "Products" table.

Can not find any solution and wondering if you can through some light/help that could resolve the issue

Thanks

Rana

Need Help

Submitted by Anonymous on Tue, 01/12/2010 - 03:51.

I am trying to generate reports in vb6 on an MySQL 5.0 database but am lock up!

my problems is how to create a data link and a data environment.

will be greatfull to anyone who help me out!

incompatibility with VB 2008

Submitted by ashwa on Sat, 11/07/2009 - 21:00.

Whenever I try to open and run the project,VB 2008 is tryiing to upgrade it.
And while upgrading, the upgrade wizard shows following errors:
"upgrade failed : exception occured couldn't load referenced components: msbind.dll,sapi.dll,MSRDC20.OCX,...etc..
It is recommended that u install VB 6.0 with all referenced components & ensure app compiles & runs before upgrading"

what does this mean? I have installed VB express edition 2008, what else shpould I install?

I want to make an application in VB which accesses mysql and uses data reports to generate reports.
plz help!

ashwa

Reading SMS from Globe Broadband

Submitted by Anonymous on Tue, 09/08/2009 - 12:18.

Hello... Anybody can help me create a VB6 programs that will read messages from my Globe Broadband... I have already tried to send message from it and it works..

But i dont know how to read messages using VB..

Thank you and i hope you can help me...

IRWIN CANSEJO

Hi

Submitted by Anonymous on Thu, 10/15/2009 - 14:12.

Can anyone help me how to send an SMS via VB6..

thanks a lot..

re: Reading SMS from Globe Broadband

Submitted by admin on Thu, 09/10/2009 - 12:41.

I think emond can help you on this matter.

VB2008

Submitted by Anonymous on Tue, 07/28/2009 - 12:12.

Can anyone recreate this in VB 2008? Thanks

re: VB2008

Submitted by admin on Wed, 07/29/2009 - 17:18.

Wait for my code in the next coming day.

Thanks

Submitted by Anonymous on Mon, 07/27/2009 - 08:18.

Hello.
This is exactly what im looking for since i program alot php it would be superb if i could make a application wich could control the databases as well.
Im not a very experienced vb user, but i get a error when i try and run the program, saying .connectionstring method or data member not found :S

any solutions? i got the mysql odbc driver installed.

//Neess

steffenrneess@hotmail.com

bind a picture in vb6

Submitted by Anonymous on Mon, 07/20/2009 - 12:35.

hi sir,

i am a bigginner in myysql, and i have some trouble on binding pictures in vb6 from mysql database. can you help me, my email add is savagedragon_24@yahoo.com.ph

thanks in advance

Nice code

Submitted by Anonymous on Thu, 07/16/2009 - 18:09.

Think about the refresh the table after the search.
Regards.

it just a sample for

Submitted by emond on Thu, 07/16/2009 - 22:07.

it's just a sample for database connection, not for searching data purpose..

emond
programmer/analyst-consultant

How can i send SMS using VB

Submitted by Anonymous on Sat, 07/11/2009 - 16:02.

Hello sir,
I want sample code of sending the sms from vb project to mobile and mobile to vb project. from where I shall I got that.

i posted a sample using At

Submitted by emond on Thu, 07/16/2009 - 22:04.

i posted a sample using At commands but since not all phones are supported by AT i have different Commercial systems using SMS Server and GAteways and other are Active X..if you want sample using other technology just PM me

dark_raditz0825

emond
programmer/analyst-consultant

SMS through VB6.0 from access database

Submitted by Anonymous on Fri, 07/17/2009 - 12:15.

Hi Emond,

How are you?

I'm trying to send SMS through vb6.0 from mdb file. Please help in scritping this program.

Thanks a lot.
Sri
+91 9900518451

Hello Do you know how to send

Submitted by Anonymous on Sat, 05/30/2009 - 15:13.

Hello Do you know how to send an MMS data in vb.net? i have this apps that export its data to xls format. my problem is that i would like also to put a functionality that the file exported is also can be send through mms or sms.

if you had a such source code or tutorial please kindly post it here...

Thanks and God Bless

hi sir, i have created some

Submitted by emond on Sat, 06/06/2009 - 16:41.

hi sir,

i have created some SMS projects in the past.. i used GSM Modem/Phones and some SMS Server,SMS ocx and gateways in order to put send/receive SMS/MMS functionality to my projects.. I posted a sample SMS app written in vb6 in this site but it's not well commented coz its just my sample.hope you will able to try that..

PM or email me if u want a ample in .NET , i will be glad to help you..

Goodluck

emond
programmer/analyst-consultant

need sample code for mms gateway

Submitted by Anonymous on Sat, 09/05/2009 - 22:14.

can you help me to send sample code for mms gateway
my email: johns_dui@yahoo.com, thanks

thanks for sharing all of

Submitted by Anonymous on Fri, 10/30/2009 - 21:20.

thanks for sharing all of your program, this site is so important because they help some beginners in programming, I hope that you shared always your program, thanks!

SMS server

Submitted by Anonymous on Wed, 07/29/2009 - 02:27.

hi edmond,

it'll be great if you can send the sample in .net its a great service you'll be doing. thanks Ayush
ayush_agarwal@msn.com

MMS ,SMS

Submitted by emond on Sat, 05/30/2009 - 17:27.

from where country u are?

please PM me for your request

dark_raditz0825@yahoo.com

emond
programmer/analyst-consultant

indonesia

Submitted by Anonymous on Sat, 09/05/2009 - 22:16.

i'm from indonesia

sorry for late reply.. Please

Submitted by emond on Fri, 10/09/2009 - 10:15.

sorry for late reply..

Please email me.. i will create a sample in VB 2008..

tnx for your interest..

dark_raditz0825@yahoo.com
www.emondsoft.qapacity.com

emond
programmer/analyst-consultant

I am looking for this kind of

Submitted by Anonymous on Sat, 05/30/2009 - 14:49.

I am looking for this kind of project. Thank you very much for the code.

ur Welcome

Submitted by emond on Sat, 05/30/2009 - 17:24.

ur welcome..U can freely modify or improved the sample..

for your questions and request tutorials

email me
cheers!

emond
programmer/analyst-consultant

Post new comment

Subject:

Comment: *

Input format

Filtered HTML

Web page addresses and e-mail addresses turn into links automatically.
Lines and paragraphs break automatically.
You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <asp>, <c>, <cpp>, <csharp>, <css>, <java>, <java5>, <javascript>, <mysql>, <php>, <sql>, <vb>, <vbnet>. The supported tag styles are: <foo>, [foo].
You may use [inline:xx] tags to display uploaded files or images inline.
Links to specified hosts will have a rel="nofollow" added to them.
You may insert videos with [video:URL]

Full HTML

Web page addresses and e-mail addresses turn into links automatically.
Lines and paragraphs break automatically.
You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <asp>, <c>, <cpp>, <csharp>, <css>, <java>, <java5>, <javascript>, <mysql>, <php>, <sql>, <vb>, <vbnet>. The supported tag styles are: <foo>, [foo].
You may use [inline:xx] tags to display uploaded files or images inline.
Links to specified hosts will have a rel="nofollow" added to them.
You may insert videos with [video:URL]

More information about formatting options

CAPTCHA

This question is for testing whether you are a human visitor and to prevent automated spam submissions.

What code is in the image?: *

Enter the characters shown in the image.

Primary links

Languages

Share Your Source Code or Article

Navigation

Recent Reviews

Recent Blog

Recent Tutorial

New forum topics

Popular Tags

Search

Download Code

Note

Post new comment

Relevant Content

Feed subscription

Popular

All time:

Recent comments

Poll

Do You Have Question?