Trying to get sybase db to connect via isql command line.... Gui RazorSQL works

Im using RazorSQL and the settings to connect is

GUI RazorSQL Connections show as

 Driver Class  net.sourcefourge.jtds.jdbc.Driver

 Driver Location  /Java/drivers/jtds/jtds12.jar

 JDBC URL   jdbc:jtds:sybase://IP-address:4100/DATABASE

LINUX connections show

/etc/freetds.conf

[Serverconnection]

    host = 10.10.10.10
    port = 4100
    tds version = 8.0
    dump file = /var/log/freetds.log

/etc/odbc.ini

[Serverconnection]

     Driver          = /usr/local/freetds/lib/libtdsodbc.so
     Description     = Sybase JDBC Server
     Trace           = No
     Server          = 10.10.10.10
     Database        = SYB
     Port            = 4100
     TDS_Version     = 5.0

End goal is to connect to the sybase db Via command line so i can build them in bash scripts but i cant seem to connect to it via ISQL

not sure if theres a driver or jar needed or something really.

Answers


Try changing your odbc.ini file and use Servername=Serverconnection instead of Server=10.10.10.10. This points your odbc.ini file back to your freetds.conf file to get connection info, which is under [Serverconnection]. Whatever is in your freetds.conf need not be repeated in your odbc.ini file.


Need Your Help

charset for different foreign languages

php character-encoding

My website is in portuguese, english and russian. Today I update the php version to 5.4, and all my languages are with strange charaters and the russian is really bad..

What are some ideas for an embedded and/or robotics project?

embedded arduino

I'd like to start messing around programming and building something with an Arduino board, but I can't think of any great ideas on what to build. Do you have any suggestions?