FreeTDS Development Group

[Russell Kroboth <rkroboth AT visitraleigh.com>]

I checked this out; here is what I see:

My /etc/odbcinst.ini contains, in full:

[PostgreSQL]
Description             = ODBC for PostgreSQL
Driver          = /usr/lib/libodbcpsql.so
Setup           = /usr/lib/libodbcpsqlS.so
FileUsage               = 1

[TDS]
Description             = v0.61
Driver          = /usr/local/lib/libtds.so
FileUsage               = 1


And in the directory /usr/local/lib I have the following:

-rw-r--r--    1 root     root      1075500 Feb 24 09:36 libct.a
-rwxr-xr-x    1 root     root          695 Feb 24 09:36 libct.la
lrwxrwxrwx    1 root     root           12 Feb 24 09:36 libct.so ->
libct.so.0.0
lrwxrwxrwx    1 root     root           12 Feb 24 09:36 libct.so.0 ->
libct.so.0.0
-rwxr-xr-x    1 root     root       572950 Feb 24 09:36 libct.so.0.0
-rw-r--r--    1 root     root      1233420 Feb 24 09:36 libsybdb.a
-rwxr-xr-x    1 root     root          716 Feb 24 09:36 libsybdb.la
lrwxrwxrwx    1 root     root           15 Feb 24 09:36 libsybdb.so ->
libsybdb.so.1.0
lrwxrwxrwx    1 root     root           15 Feb 24 09:36 libsybdb.so.1 ->
libsybdb.so.1.0
-rwxr-xr-x    1 root     root       673808 Feb 24 09:36 libsybdb.so.1.0
-rw-r--r--    1 root     root       855988 Feb 24 09:36 libtds.a
-rwxr-xr-x    1 root     root          702 Feb 24 09:36 libtds.la
lrwxrwxrwx    1 root     root           13 Feb 24 09:36 libtds.so ->
libtds.so.0.0
lrwxrwxrwx    1 root     root           13 Feb 24 09:36 libtds.so.0 ->
libtds.so.0.0
-rwxr-xr-x    1 root     root       463222 Feb 24 09:36 libtds.so.0.0


I've triple checked my DB access.. From my Windows machine I can connect
with this perl script:

use DBI;
my $dsn = "driver={SQL
Server};Server=192.168.1.54;database=Partners;uid=testuser;pwd=password1;";
my $dbh  = DBI->connect("dbi:ODBC:$dsn") or die "$DBI::errstr\n";
$sql="SELECT company FROM contact1";
$sth=$dbh->prepare($sql);
$sth->execute();
while ($hashref=$sth->fetchrow_hashref()){
        print $hashref->{'company'}."\n";
}
$sth->finish();




> -----Original Message-----
> From: ZIGLIO Frediano [mailto:Frediano.Ziglio AT vodafoneomnitel.it]
> Sent: Tuesday, February 25, 2003 9:25 AM
> To: 'FreeTDS Development Group'
> Subject: RE: [freetds] problems configuring..
> 
> 
> > 
> > > -bash-2.05b# isql -v P450 cgiscript corv3tt31
> > > [unixODBC][Driver Manager]Driver's SQLAllocHandle on 
> > SQL_HANDLE_HENV failed
> > > [ISQL]ERROR: Could not SQLConnect
> > > 
> > > What could it be?
> > > 
> > 
> > No obvious reason from what I can see. Here are some more 
> > things to try;
> > 
> > 1 - Use a host name instead of an IP. I simply add a line to 
> > /etc/hosts 
> > when DSN would fail (such as in your case). Example line for 
> > /etc/hosts...
> > 
> > 192.168.1.54 COSTLYSERVER
> > 
> > 2 - I use "Servername" not "Server" but this may have 
> changed since I 
> > last updated my FreeTDS source. So in my case the line in the 
> > ~/.odbc.ini file would look something like this;
> > 
> 
> Server is not an error. Is used in freetds.conf'less 
> connection and can be
> an ip (it point to real server while servername point to freetds.conf
> server).
> 
> I don't understand
> [unixODBC][Driver Manager]Driver's SQLAllocHandle on 
> SQL_HANDLE_HENV failed
> It seem that is unable to create handle, or perhaps it do not 
> find driver
> (.so file)...
> 
> My /etc/odbcinst.ini contain
> [FreeTDS]
> Description     = FreeTDS driver
> Driver          =
> /home/freddy/cpp/freetds/freetds/src/odbc/.libs/libtdsodbc.so
> FileUsage       = 1
> 
> /home/freddy/cpp/freetds/freetds/src/odbc/.libs/libtdsodbc.so 
> is my driver..
> are you sure that your exists?
> 
> freddy77
> 
> =================================
> "STRICTLY PERSONAL AND CONFIDENTIAL
> 
> This message may contain confidential and proprietary 
> material for the sole
> use of the intended recipient. Any review or distribution by others is
> strictly prohibited. If you are not the intended recipient 
> please contact
> the sender and delete all copies.
> The contents of this message that do not relate to the 
> official business of
> our company shall be understood as neither given nor endorsed by it."
> 
> =================================
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>