FreeTDS Development Group

[Russell Kroboth <rkroboth AT visitraleigh.com>]

>I presume is 0.61rc...

I just updated to the rpm of version 6.1 from the site using rpm -U.  I
still experience the same error. I can use the rc file, but I would need an
instructions page to follow..

>How have you configured dsn?
>Send the part of odbc.ini where dsn is configured...

I found /etc/odbc.ini on the system, but it is an empty document.  I never
edited this document anyway, I used the instructions on
http://www.unixodbc.org/doc/FreeTDS.html to register the driver and create
an ODBC data source. Here are the templates and steps I used while following
the instructions:

[TDS]
Description=v0.60
Driver=/usr/local/lib/libtds.so

Used the command 'odbcinst -i -d -f tds.driver.template'


[P450]
Driver=TDS
Description=Partners
Trace=No
Servername=192.168.1.54
Database=Partners
UID=testuser

Used the command 'odbcinst -i -s -f tds.datasource.template'

Here is the query that i used to verify they were installed:

-bash-2.05b# odbcinst -q -d
[PostgreSQL]
[TDS]
-bash-2.05b# odbcinst -q -s
[P450]

>What driver manager are you using? unixodbc or iodbc?

I installed unixODBC-2.2.2-3.i386.rpm, no apparent problems while installing









> -----Original Message-----
> From: Frediano Ziglio [mailto:freddyz77 AT tin.it]
> Sent: Monday, February 24, 2003 4:06 PM
> To: FreeTDS Development Group
> Subject: Re: [freetds] problems configuring..
> 
> 
> 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
> 
> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>