Skip to Content.
Sympa Menu

freetds - Re: [freetds] problems configuring..

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddyz77 AT tin.it>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] problems configuring..
  • Date: 24 Feb 2003 22:05:32 +0100

Il lun, 2003-02-24 alle 21:30, Russell Kroboth ha scritto:
> I am having a problem configuring FreeTDS to access my MS SQL database, at
> the point that I test the connection I am getting the following error? Can
> anybody give me an idea as to where my error might be? I have a user on the
> SQL server named "testuser" with the password "password1"
> Thanks...
>
> -bash-2.05b# isql -v P450 testuser password1
> [unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed
> [ISQL]ERROR: Could not SQLConnect
>
> Rusty Kroboth
>

I presume is 0.61rc...
How have you configured dsn?
What driver manager are you using? unixodbc or iodbc?
Send the part of odbc.ini where dsn is configured...

My part (~/.odbc.ini) look like (as developer I point directly to daily
compiled version, this shouldn't your case)

[local]
Driver =
/home/freddy/cpp/freetds/freetds/src/odbc/.libs/libtdsodbc.so
Description = Test Server
Trace = Yes
Database = tempdb
Servername = local

This point to freetds.conf local server, not a real server.
>From my freetds.conf (~/.freetds.conf)

[local]
host = localhost
port = 4100
tds version = 5.0
text size = 102400

Mixed together (using a freetds.conf-less connection) should be (not
tested, your odbc.ini):

[local]
Driver =
/home/freddy/cpp/freetds/freetds/src/odbc/.libs/libtdsodbc.so
Description = Test Server
Trace = Yes
Database = tempdb
Server = localhost
Port = 1433
TDS_Version = 5.0

freddy77





Archive powered by MHonArc 2.6.24.

Top of Page