.bat创建mysql脚本,通过批处理脚本创建mysql odbc连接

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,

解决方案

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"