[freetds] connection problems - unixODBC, perl

Matthew Fansher mfansher at paloma.com
Tue May 19 12:44:53 EDT 2009

Ugh, I realized right after I posted that this was just an awk looking
for space delimited fields. I've got that sorted, but now I'm getting:

./osql -S CCMS -U my_user -P my_passwd

osql: error: no potential directory strings in "/usr/local/bin/isql"
isql strings are:

and sure enough, no strings in my isql binary:

strings /usr/local/bin/isql
@(#)23  src/bos/usr/ccs/lib/libpthreads/init.c, libpth, bos53L,
l2007_26B0 6/22/07 08:35:47
1.15  src/bos/usr/ccs/lib/libc/__threads_init.c, libcthrd, bos53H,
h2006_10B1 3/5/06 16:44:58

-----Original Message-----
From: freetds-bounces at lists.ibiblio.org
[mailto:freetds-bounces at lists.ibiblio.org] On Behalf Of Matthew Fansher
Sent: Tuesday, May 19, 2009 11:35 AM
To: freetds at lists.ibiblio.org
Subject: [freetds] connection problems - unixODBC, perl

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:



perl 5.8.8

UnixODBC 2.2.15pre




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:



         Description=DEV Test







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.

FreeTDS mailing list
FreeTDS at lists.ibiblio.org

More information about the FreeTDS mailing list