Install An ODBC connection from cmd line

2020-03-26 04:04发布

Install An ODBC connection from cmd line

Hi, i want to install an odbc connection threw the cmd line, in this cmd below i can open
only a name and driver of the database i want to use. i need to add also a ip,user,password,description.

enter image description here

odbcconf configsysdsn "MySQL ODBC 5.2w Driver" "DSN=test1|SERVER=(local)"

标签: odbc cmd
2条回答
地球回转人心会变
2楼-- · 2020-03-26 04:32

ok, figured out!
odbcconf configsysdsn "MySQL ODBC 5.2w Driver" "DSN=test;SERVER=127.0.0.1;PORT=3306;DATABASE=mdb;UID=root "

查看更多
别忘想泡老子
3楼-- · 2020-03-26 04:52

According to this article on Microsoft.com:

ODBCCONF.exe will be removed in a future version of Windows Data Access Components. Avoid using this feature, and plan to modify applications that currently use this feature. You can use PowerShell commands to manage drivers and data sources. For more information about these PowerShell commands, see Windows Data Access Components cmdlets.

The Power Shell equivalent to your command would be:

Add-OdbcDsn -Name "test" -DriverName "MySQL ODBC 5.2w Driver" -Platform "32-bit" -DsnType "System" -SetPropertyValue @("SERVER=127.0.0.1", "PORT=3306", "DATABASE=mdb")
查看更多
登录 后发表回答