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

James K. Lowden jklowden at schemamania.org
Wed Dec 18 08:59:23 EST 2002


On Wed, 18 Dec 2002 01:50:30 -0700, "Chris McDaniel"
<Chris.McDaniel at telus.com> wrote:
> 
> freddy77 - you mentioned posting log code - I'm vew to freetds, so
> indulge my ignorant question - how do I enable/find log code?

Frediano refers to setting the TDSDUMP environment variable to a file
name.  Your whole FreeTDS session will be written to the log.  See the
User Guide ("Logging") for details.  

Your freetds.conf, below, indicates a dump (log) file "/tmp/freetds.log". 
That's the same thing.  Mind, you're writing session passwords to a
world-readable directory.  

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

"Stored procedures", I think you mean.  Yes.  What's called "dynamic SQL"
-- using placeholders to pass parameters -- is quite rough right now, but
calling stored procedures the usual way (execute procname
@param1='value1', @param2='value2') works fine.  

> I'm adding my new ini/conf files below, based on your comments and a
> review of the docs.  

Are you connecting, then?  

Regards, 

--jkl


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



More information about the FreeTDS mailing list