odbc connection

Question

I would like to install odbc in ubuntu server 10.10 with mysql:

I did

sudo apt-get install libmyodbc

edited odbcinst.ini

[MySQL]
Description = ODBC for MySQL
Driver = /usr/lib/odbc/libmyodbc.so
Setup = /usr/lib/odbc/libodbcmyS.so
FileUsage = 1

And odbc.ini

[asterisk]
Description           = MySQL connection to 'spb' database
Driver                = MySQL
Database              = myDatabase
Server                = localhost
UserName              = myUser
Password              = myPAss
Port                  = 3306
Socket                = /var/lib/mysql/mysql.sock

And try:

ubuntu@ubuntu:/etc$ isql asterisk
[ISQL]ERROR: Could not SQLConnect

Did I miss some step?

add a -v to to the isql command line. Also add the username and password like this "isql -v asterisk myUser myPAss - now what does it say. — bohica, Jan 29 '13 at 13:18
this is just an start, i want to connect to my server. Should I write my public ip in "Server"? — user1256477, Jan 29 '13 at 14:53
bohica, yours is the solution, if you posted it as answer, I will mark it as the solution — user1256477, Jan 29 '13 at 16:09

score 2 · Answer 1 · answered Jan 21 '14 at 08:45

2

I got a same problem. Try:

$ SUDO isql asterisk

answered Jan 21 '14 at 08:45

Adrian Jimenez

21
2

score 1 · Answer 2 · edited May 08 '17 at 11:25

1

change section Server = localhost with Server = 127.0.0.1

edited May 08 '17 at 11:25

piet.t

11,718
21
43
52

answered Jun 02 '13 at 17:29

Bojan Dinev

411
4
6

score 1 · Answer 3 · edited Aug 07 '13 at 07:45

1

Did you check you have the drivers in this directory? ubuntu installed me on other directories:

/usr/lib/i386-linux-gnu/odbc/libmyodbc.so
/usr/lib/i386-linux-gnu/odbc/libodbcmyS.so

Or try a simbolic link

edited Aug 07 '13 at 07:45

kleopatra

51,061
28
99
211

answered Aug 07 '13 at 07:37

Sal00m

2,938
3
22
33

odbc connection

3 Answers3