connection problems - unixODBC, perl

"Matthew Fansher" <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]>
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:

 

freetds-0.82

perl 5.8.8

UnixODBC 2.2.15pre

DBI-1.608

DBD-ODBC-1.21

 

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

        reading "//.odbc.ini"

[CCMS] not found in "//.odbc.ini"

        reading "/tmp/ctisql_XXXXXX/odbc.ini"

[CCMS] found in "/tmp/ctisql_XXXXXX/odbc.ini"

found this section:

        [CCMS]

         Driver=/usr/local/lib/libtdsodbc.so

         Description=DEV Test

         Address=172.16.5.43

         Port=1433

         Trace=No

         Database=CCMS

         TDS_Version=8.0

 

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.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.