Hi all, I write lua program to connect with mysql db through ODBC & play the things. But it is not work due to /usr/local/lib/libmyodbc5.so' : file not found.But it is there. Pls advice to solve this problem. [root@test]# ll /usr/local/lib/libmyodbc5.so -rwxr-xr-x 1 root root 318366 Dec 1 07:06 /usr/local/lib/libmyodbc5.so freeswitch.log => 2011-12-01 07:30:15.386020 [DEBUG] switch_rtp.c:2699 Correct ip/port confirmed. 2011-12-01 07:30:17.206663 [INFO] switch_cpp.cpp:1190 TEST_DB - db_connection2011-12-01 07:30:17.206663 [ERR] switch_odbc.c:365 STATE: 01000 CODE 0 ERROR: [unixODBC][Driver Manager]Can't open lib '/usr/local/lib/libmyodbc5.so' : file not found 2011-12-01 07:30:17.206663 [CRIT] switch_core_sqldb.c:381 Failure! 2011-12-01 07:30:17.206663 [INFO] switch_cpp.cpp:1190 TEST_DB - cannot connect to database /usr/local/etc/odbcinst.ini [MySQL] Description=ODBC for MySQL Driver=/usr/local/lib/libmyodbc5.so UsageCount=2 /usr/local/etc/odbc.ini [freeswitch_odbc] Driver=MySQL SERVER=localhost PORT=3306 DATABASE=vm Socket = /tmp/mysql.sock [root@test]# isql -v freeswitch_odbc root test +---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | quit | | | +---------------------------------------+ SQL> [root@test]# mysql -V mysql Ver 14.14 Distrib 5.5.18, for Linux (i686) using EditLine wrapper Br Sanath