Skip to Content.
Sympa Menu

freetds - RE: [freetds] problems configuring..

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Russell Kroboth <rkroboth AT visitraleigh.com>
  • To: 'FreeTDS Development Group' <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] problems configuring..
  • Date: Tue, 25 Feb 2003 09:59:48 -0500

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
>




Archive powered by MHonArc 2.6.24.

Top of Page