First:
Syntax for isql: isql <DSN> <username> <password>

Next:
Make sure your /usr/local/etc/odbcinst.ini matches /root/.odbc.ini

Create a database in the DSN which you can test on

Sample odbc ini:
[ODBC Data Sources]
MySQL              = MySQL Database Driver

[MySQL]
Description             = MySQL Database Driver
Driver          = /usr/local/lib/<name-of-your-lib-odbc.so>
Trace           = Yes
TraceFile               = sql.log
Database                = <database name>
Servername              = <IP of server on which DB is installed>
UserName                = <username>
Password                = <password>
Port            = <port no for mysql>
Protocol                = 6.4
ReadOnly                = No
RowVersioning           = No
ShowSystemTables                = No
ShowOidColumn           = No
FakeOidIndex            = No
ConnSettings            =

[Default]
Driver          = /usr/local/lib/<name-of-your-lib-odbc.so>

[ODBC]
Trace           = 1
TraceFile               = /var/log/odbctrace.out
Driver          = /usr/local/lib/<name-of-your-lib-odbc.so>

Follow steps given on: http://www.unixodbc.org/odbcinst.html --- 
odbcinst -i -d -f template_file
odbcinst -i -s -f template_file
They install the drivers you list in the ini files
I doubt there will be anything left to do after that!
Hope this helps

--
Regards,
Gayatri Kulkarni

On Mon, Oct 20, 2008 at 3:55 PM, Baskar <yudha2008@gmail.com> wrote:
Hi,

Using isql i get these error
[root@hp30094686650 ~]# isql ODBC
[ISQL]ERROR: Could not SQLConnect


when i run odbcinst -j on my system, it shows me also 3 files

[root@hp30094686650 ~]# odbcinst -j
unixODBC 2.2.12
DRIVERS............: /usr/local/etc/odbcinst.ini
SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini
USER DATA SOURCES..: /root/.odbc.ini



 /usr/local/etc/.odbc.ini
[ODBC]
Description = mysql
Trace       = Off
TraceFile   = stderr
Driver      = mysql
SERVER      = 172.20.176.32
USER        = optimus
PASSWORD    = optimus
PORT        = 3306
DATABASE    = freeswitch



 /usr/local/etc/odbcinst.ini

[mysql]
Description = MYSQL driver
Driver      = /usr/local/lib/libmyodbc3.so
Setup       = /usr/local/lib/libodbcmyS.so

CPTimeout   =
CPReuse     =
FileUsage   = 1

I what to connect to mysql please correct me where i am worng
--
Warm Regards,
N.Baskar


_______________________________________________
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