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)

0
edit delete
are you sure?
asked 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.

0
edit delete
are you sure?
answered Dan Wake

Post an answer but please log in first

Post Answer
  1. Please log in to post answer

Similar Questions

Tagsfor this question

Forumall questions