Hi, I have been trying to get MSSQL working on mac, but it apears that my iodbc setup is broken: tomasz-baks-imac:~ tb$ iodbctest "dsn=wcompany_odbc;uid=thesystem_test;pwd=thesystem_test" iODBC Demonstration program This program shows an interactive SQL processor Driver Manager: 03.52.0406.1211 1: SQLDriverConnect = [iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded (0) SQLSTATE=IM002 1: ODBC_Connect = [iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded (0) SQLSTATE=IM002 tomasz-baks-imac:~ tb$ cat /opt/local/etc/odbc.ini [wcompany_odbc] Driver = /opt/local/lib/libtdsodbc.so Description = ODBC connection via FreeTDS Trace = yes TraceFile = /tmp/odbc.log Servername = wcompany TDS_version = 8.0 Database = thesystemTest tomasz-baks-imac:~ tb$ cat /opt/local/etc/odbcinst.ini [FreeTDS] Description = TDS Driver Driver = /opt/local/lib/libtdsodbc.so Setup = /opt/local/lib/libtdsS.so CPTimeout CPReuse FileUsage = 1 The configure files are like the ones that work on Ubuntu. It might be me doing something strange with Mac setup. I example when I moved odbc*.ini files to /etc I got different error (I am not sure that that one gets me closer :( tomasz-baks-imac:~ tb$ iodbctest "dsn=wcompany_odbc;uid=thesystem_test;pwd=thesystem_test" iODBC Demonstration program This program shows an interactive SQL processor Driver Manager: 03.52.0406.1211 1: SQLDriverConnect = [FreeTDS][SQL Server]Unable to connect: Adaptive Server is unavailable or does not exist (20009) SQLSTATE=08S01 2: SQLDriverConnect = [FreeTDS][SQL Server]Unable to connect to data source (0) SQLSTATE=08001 1: ODBC_Connect = [FreeTDS][SQL Server]Unable to connect: Adaptive Server is unavailable or does not exist (20009) SQLSTATE=08S01 2: ODBC_Connect = [FreeTDS][SQL Server]Unable to connect to data source (0) SQLSTATE=08001 The file /tmp/odbc.log is not being created. I have no idea what to try next. I have verified that tshl work fine for that database: tomasz-baks-imac:th_b_rails21 tb$ tsql -H 10.10.1.2 -p 1433 -U thesystem_test -P thesystem_test locale is "C/UTF-8/C/C/C/C" locale charset is "" 1> use thesystemTest 2> go 1> select count(*) from NItems 2> go 220 (1 row affected) 1> Cheers, Tomasz -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---