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.
odbcconf configsysdsn "MySQL ODBC 5.2w Driver" "DSN=test1|SERVER=(local)"
ok, figured out!
odbcconf configsysdsn "MySQL ODBC 5.2w Driver" "DSN=test;SERVER=127.0.0.1;PORT=3306;DATABASE=mdb;UID=root "
According to this article on Microsoft.com:
The Power Shell equivalent to your command would be: