FreeTDS Development Group

[Russell Kroboth <rkroboth AT visitraleigh.com>]

I did make the change in the hosts file, and verified with ping that it
worked. I had the same result with isql.

I also did find the file .odbc.ini (did not realize it was hidden). Here is
what it has in it:

[P450]
Driver          = TDS
Description             = Partners
Trace           = No
Servername              = dataserver
Database                = Partners
Port            = 1433
TDS_Version             = 7.0

Does this look correct to you guys? Thanks!

> -----Original Message-----
> From: Peter Harvey [mailto:pharvey AT codebydesign.com]
> Sent: Tuesday, February 25, 2003 9:18 AM
> To: FreeTDS Development Group
> Subject: Re: [freetds] problems configuring..
> 
> 
> > -bash-2.05b# isql -v P450 cgiscript corv3tt31
> > [unixODBC][Driver Manager]Driver's SQLAllocHandle on 
> SQL_HANDLE_HENV failed
> > [ISQL]ERROR: Could not SQLConnect
> > 
> > What could it be?
> > 
> 
> No obvious reason from what I can see. Here are some more 
> things to try;
> 
> 1 - Use a host name instead of an IP. I simply add a line to 
> /etc/hosts 
> when DSN would fail (such as in your case). Example line for 
> /etc/hosts...
> 
> 192.168.1.54 COSTLYSERVER
> 
> 2 - I use "Servername" not "Server" but this may have changed since I 
> last updated my FreeTDS source. So in my case the line in the 
> ~/.odbc.ini file would look something like this;
> 
> Servername=COSTLYSERVER
> 
> Hope this helps!
> Peter
> 
> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>