[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