Skip to Content.
Sympa Menu

freetds - RE: [freetds] Driver's SQLAllocEnv() failed - libtdsodbc.so

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Chris McDaniel" <Chris.McDaniel AT telus.com>
  • To: "'freetds AT lists.ibiblio.org'" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Driver's SQLAllocEnv() failed - libtdsodbc.so
  • Date: Wed, 18 Dec 2002 01:50:30 -0700

Thanks very much for the responses!

freddy77 - you mentioned posting log code - I'm vew to freetds, so indulge
my ignorant question - how do I enable/find log code?

Also, you made a comment about ODBC 3 - I am eventually going to be using
Perl (DBI::ODBC) as my application, but right now I'm just using odbctest.
What ODBC version should I compile iODBC to? currently it's compiled as
default, ODBC version 3.

Last question, yet another ignorant one I think -
Can I call shared procedures in the SQL Server using freetds as the driver?

I'm adding my new ini/conf files below, based on your comments and a review
of the docs.
------------------------------
odbc.ini
------------------------------
;
; odbc.ini
;
[ODBC Data Sources]
ODBC = Sybase JDBC Server

[ODBC]
Driver = /usr/local/lib/libtdsodbc.so
Description = ODBC Server
Trace = Yes
Servername = SBS
Database = BSRes2
UID = xxxxxx

[Default]
Driver = /usr/local/lib/libtdsodbc.so

------------------------------
freetds.conf
------------------------------
[global]
tds version = 4.2
initial block size = 512
swap broken dates = no
swap broken money = no
try server login = yes
try domain login = no
dump file = /tmp/freetds.log
debug level = 10

[SBS]
host = 12.176.16.4
port = 1433
tds version = 4.2
------------------------------------------------------

Thanks,

Chris McDaniel


-----Original Message-----
From: ZIGLIO Frediano [mailto:Frediano.Ziglio AT vodafoneomnitel.it]
Sent: December 16, 2002 6:08 AM
To: 'freetds AT lists.ibiblio.org'
Subject: RE: [freetds] Driver's SQLAllocEnv() failed - libtdsodbc.so


>
> Hello,
>
> I have a couple questions -
> I'd like to use the freetds libraries with iODBC to connect
> to a remote SQL
> Server (v6.5)
> Is that possible?
>

Yes

> Assuming it is, I get this message when I try to use iODBCs
> odbctest prog:
> [iODBC][Driver Manager]Driver's SQLAllocEnv() failed, SQLSTATE=IM004
>

Perhaps application require ODBC version 3...
Can you post log code ?

> here is my odbc.ini
> ------------------------------
> [ODBC Data Sources]
> SBS = SQL Server
>
> [ODBC]
> Debugfile=/tmp/odbc.out
>
> [SBS]
> Description = SQL Server
> UID = xxxxxxx
> PWD = xxxxxxxx
> TDSHOST = 12.178.18.4
> TDSPORT = 1433
> TDSVER = 4.2
> Driver = /usr/local/lib/libtdsodbc.so
> Database = BSRes2
> ServerName = SBS
>

TDSHOST, TDSPORT and TDSVER should be environment string... nothing to do
with odbc.ini!
PWD should not go to odbc.ini...
SBS should be in freetds.conf

> Is my compile of the lib broken or did I do something wrong?
>
> I'm using Solaris 8, gcc 2.95.3, iODBC 3.0.6 and freetds 0.60
>
> Thanks,
>
> Chris McDaniel
>

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