Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Install An ODBC connection from cmd line

Tags:

cmd

odbc

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

like image 537
Ofir Attia Avatar asked Feb 19 '23 11:02

Ofir Attia


1 Answers

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

like image 104
Ofir Attia Avatar answered Mar 15 '23 09:03

Ofir Attia