CODEWITHSUNDEEP
odbccmd
Ofir Attia
Ofir Attia

Reputation: 1275

Install An ODBC connection from cmd line

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)"

Upvotes: 7

Views: 34940

Answers (2)

JonathanDavidArndt
JonathanDavidArndt

Reputation: 2732

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")

Upvotes: 6

Ofir Attia
Ofir Attia

Reputation: 1275

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

Upvotes: 8

Related Questions