FreeTDS Development Group

[ZIGLIO Frediano <Frediano.Ziglio AT vodafoneomnitel.it>]

> 
> 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."

=================================