通过批处理脚本创建mysql odbc连接 [英] create mysql odbc connection through batch script

问题描述

是否仍然可以通过批处理脚本或任何其他语言以编程方式静默安装MySQL ODBC驱动程序，从而为MYSQL数据库(Windows OS)创建系统DSN输入?

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?

如果无法安装驱动程序，则自动进行DSN主动输入将很有帮助.

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

谢谢

推荐答案

在命令行上，使用适当的参数运行odbcconf.exe.例如

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

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

对于MySQL

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

这篇关于通过批处理脚本创建mysql odbc连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！