Forums | Admin

Discussion Forums: open-discussion

Start New Thread Start New Thread

 

By: Douglas House
Using ODBC to connect to SQL Server via Linux [ reply ]  
2006-08-28 15:35
Help,

I've only been using Ruby for a short time (20 yr unix c background) and am attemtping to connect to a windows host running Sql Server 2005 by using ODBC. I have installed the follwing..

ruby-odbc-0.999
libiodbc-3.52.2
freetds-0.64
ruby-dbi (dli and drd_odbc)

I have tested the freetds install via tsql and it seem to work correctly.

I have tried isql and get the following error...

[01000][unixODBC][Driver Manager]Can't open lib '/usr/local/lib/libtdsodbc.so' : libiodbcinst.so.2: cannot open shared object file: No such file or directory
[ISQL]ERROR: Could not SQLConnect

These libs do exist in /usr/local/lib

I'm also pretty sure that my odbc.ini and odbcinst.ini are not set up correctly and would appreciate if I could see an examle of each file. I've attempted to search the web with limited success. Fort the sake of example assume linux host "LINUX" and windows host "WINDOWS". Thanks

Doug