Pls send let me see the codes on how to connect a My SQL database to vB6.. ^_^ i am new to My SQL! tnhx much!
Thaddeus_03
0
Newbie Poster
Recommended Answers
Jump to PostYou will need to know ADO. Do you know ADO? If not, use your friends (yahoo, google, ask, answers, bing) and search for vb6 ado tutorial. Once you have digested that, see http://www.connectionstrings.com for the ADO DNS Less connection string you will …
All 2 Replies
vb5prgrmr
143
Posting Virtuoso
You will need to know ADO. Do you know ADO? If not, use your friends (yahoo, google, ask, answers, bing) and search for vb6 ado tutorial. Once you have digested that, see http://www.connectionstrings.com for the ADO DNS Less connection string you will need to connect to your version of SQL Server...
Good Luck
jhai_salvador
48
Junior Poster
if you are going to connect it from a remote server.
Here is the connection string..
"Driver={MySQL ODBC 5.1 Driver};Server=servername;Port=3306;Database=database;User=username; Password=password;Option=3;"
you must also have MySQL connector driver.. just google it then download the driver...
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.