[freetds] Driver's SQLAllocEnv() failed - libtdsodbc.so
Chris McDaniel
Chris.McDaniel at telus.com
Wed Dec 18 07:07:47 EST 2002
No, I'm not connecting - I still get
iODBC Demonstration program
This program shows an interactive SQL processor
[iODBC][Driver Manager]Driver's SQLAllocEnv() failed, SQLSTATE=IM004
No packets leave the network interface when I run odbctest.
As for logging, nothing actually gets written to the log.
Thanks for the info on stored procs - and thanks for correcting my typo - I
was pretty tired...
-----Original Message-----
From: James K. Lowden [mailto:jklowden at schemamania.org]
Sent: December 18, 2002 8:59 AM
To: freetds at lists.ibiblio.org
Subject: Re: [freetds] Driver's SQLAllocEnv() failed - libtdsodbc.so
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
> ------------------------------------------------------
_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
More information about the FreeTDS
mailing list