[freetds] connection problems - unixODBC, perl
mfansher at paloma.com
Tue May 19 11:34:34 EDT 2009
I am able to connect to a SQL Server 2005 server from unix via the tsql
utility, but I'm getting errors when trying to connect via perl. I'm
using the following setup:
I've been reading through the freetds docs
(http://www.freetds.org/userguide/odbcdiagnose.htm) and I attempted to
run the osql utility. It returns the following error(s):
./osql -S CCMS -U my_user -P my_passwd
looking for odbc.ini and odbcinst.ini in /tmp/ctisql_XXXXXX
[CCMS] not found in "//.odbc.ini"
[CCMS] found in "/tmp/ctisql_XXXXXX/odbc.ini"
found this section:
looking for driver for DSN [CCMS]
driver line incomplete for [CCMS] in odbc.ini
looking for driver for DSN [default]
driver line incomplete for [default] in odbc.ini
osql: error: no driver found for [CCMS] in odbc.ini
It sounds like something is wrong with my "Driver" line..?
Thanks in advance.
More information about the FreeTDS