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
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.