Thanks for your help. It works.

---

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

is mysql running on the localhost? if so, is that the correct path to the .sock?

you might also try using 127.0.0.1 as the host instead of localhost to force a network connection.

-Ray


fidibus83 wrote:

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

 





 
_______________________________________________
Freeswitch-users mailing list
Freeswitch-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org