create mysql odbc connection through batch script

Question

Is there anyway to create a System DSN enter for MYSQL database (windows OS), with silent installation of MySQL ODBC Drivers programatically either through batch script or any other language?

If drivers installation is not possible , atleast automatic DSN entery would be helpful.

Thanks,

Rory McCrossan · Accepted Answer · 2012-12-11 08:28:31Z

2

Dim ad
ad = CreateObject("ADODB.Connection")      'create and open ODBC connection 
ad.ConnectionString = ("Driver={MySQL ODBC 5.2w Driver};Server=localhost;Database=db;UID=root;PWD=xxxxxx;option=3")
ad.Open()

edited Dec 11, 2012 at 8:28

Rory McCrossan

338k41 gold badges321 silver badges353 bronze badges

answered Dec 11, 2012 at 8:10

Ohad Ilyas

213 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Raj More · Accepted Answer · 2009-11-24 18:47:38Z

1

On the command line, run odbcconf.exe with appropriate parameters. For example

ODBCConf ConfigSysDSN "SQL Server" "DSN=LocalODBCConnection|SERVER=(local)"

for MySQL

ODBCConf ConfigSysDSN "MySQL" "DSN=LocalODBCConnection|SERVER=MySQL_ServerName"

answered Nov 24, 2009 at 18:47

Raj More

48.2k34 gold badges139 silver badges199 bronze badges

2 Comments

JPro Over a year ago

I tried to run ODBCConf with specified parameters, but it says component not found in the registry.

JPro Over a year ago

solved, I had to keep MySQL ODBC 5.1 Driver in place of MySQL

Collectives™ on Stack Overflow

create mysql odbc connection through batch script

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related