The libmyodbc package is installed.

 

But I see I have a lot of version of libmyodbc:

libmyodbc3.so

libmyodbc3_r.so

libmyodbc3_r-3.51.14.so

libmyodbc3-3.51.14.so

 

I changed odbcinst.ini:

 

[MySQL]

Description = ODBC for MySQL

Driver = /usr/lib/libmyodbc3.so

Setup = /usr/lib/libodbcmyS.so

 

I run isgl –vvv and I get this:

 

[08S01] [unixODBC] [MySQL] [ODBC 3.51 Driver] Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)

[ISQL] ERROR: Could not SQLConnect

 


Von: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] Im Auftrag von Raymond Chandler
Gesendet: Dienstag, 6. Januar 2009 16:13
An: freeswitch-users@lists.freeswitch.org
Betreff: Re: [Freeswitch-users] Problems with ODBC

 

fidibus83 wrote:

Hello,

 

I need your help again!

 

I want to use ODBC in javascripts.

 

First I installed unixodbc and I did all the steps what are mentioned in wiki: mod spidermonkey odbc.

 

But when I test my ODBC Setup by running isql I get this error:

[ISQL]ERROR: Could not SQLConnect

This isn't really a general purpose ODBC list, but using the -v option of isql tends to yield more verbose output (imagine that!)

so you get:
isql -vvv freeswitch freeswitch freeswitch
[IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified
[ISQL]ERROR: Could not SQLConnect


as opposed to:
isql freeswitch freeswitch freeswitch
[ISQL]ERROR: Could not SQLConnect

-Ray