I am trying to get access to a Microsoft SQL Server 2k installation on
my network. To this point I’m not having any luck.
I’ve followed the instructions at
http://wiki.rubyonrails.com/rails/pages/HowtoConnectToMicrosoftSQLServerFromRailsOnOSX
up to the point where you run the iodbctest where I get an error. The
errors are:
iODBC Demonstration program
This program shows an interactive SQL processor
Driver Manager: 03.52.0001.0928
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
I found that the help, at the link above, specifies to edit two files
(odbc.ini and odbcinst.ini) in the /Library/ODBC folder. This folder
does not exist on my system. I created it manually. Perhaps that is
the problem.
The only program I’ve installed is FreeTDS v.64. Running tsql -C
gives me the following:
Compile-time settings (established with the “configure” script):
Version: freetds v0.64
MS db-lib source compatibility: no
Sybase binary compatibility: unknown
Thread safety: yes
iconv library: yes
TDS version: 8.0
iODBC: yes
unixodbc: no
Interestingly enough, it previusly stated TD version: 5.0. I read the
FreeTDS install help and found you can provide the ./configure script a
set default version to use; I set it to 8.0.
Any ideas?