Need a connection string to access mysql database using VBScripting.


I need a connection string to connect MYSQL using VBScript's ADOBM method. Could anyone please help me out on this..

Following MYSQL server & Connectors are installed on my local machine..


Created table and DSN ODBC as:

dsn: dsn_venu
tcpid; local host
port: 3306
user : root
password: venu
database: HB

Tried the connection string:
"Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=HB; User=root;Password=venu;Option=3;"
but was throwing error message.

Venu Gopi..

1 answer

Try to switch from a standard mysql odbc driver to this mysql odbc driver and use this mysql connection string:
Login Prompt=False;User ID=root;Password=root;Data Source=localhost;Database=test

Insert only your parameters, these are test parameters.