Need a connection string to access mysql database using VBScripting.

Hi,

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

mysql-5.5.21-winx64
mysql-connector-odbc-5.1.10-winx64
mysql-workbench-gpl-5.2.38-win32

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.

Thanks,
Venu Gopi..
(HB)

1 answer