Skip to Content.
Sympa Menu

freetds - Re: [freetds] connection problems - unixODBC, perl

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Matthew Fansher" <mfansher AT paloma.com>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] connection problems - unixODBC, perl
  • Date: Tue, 19 May 2009 12:44:53 -0400

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 1.5.1.1 src/bos/usr/ccs/lib/libpthreads/init.c, libpth, bos53L,
l2007_26B0 6/22/07 08:35:47
@(#)61
1.15 src/bos/usr/ccs/lib/libc/__threads_init.c, libcthrd, bos53H,
h2006_10B1 3/5/06 16:44:58
_GLOBAL__FI_isql
_GLOBAL__FD_isql





-----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:



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.

_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds




Archive powered by MHonArc 2.6.24.

Top of Page