FreeTDS Development Group

[ZIGLIO Frediano <Frediano.Ziglio AT vodafoneomnitel.it>]

> 
> Hi,
> 
> i know that this subject has last for along time, but i 
> reinstalled unixodbc
> and freetds.
> i created templates similar to the ones in the CVS and used 
> the commands
> given in the install script.
> but i still get the following as soon as i enter the isql comamnd.:
> 
> [unixODBC]tds_connect failed
> [ISQL]ERROR: Could not SQLConnect
> 
> this error does not say much.
> should i give up odbc?
> regards.
> 

I remember that verbose error was "unable to find DSN", from driver manager.

I know you have problem with odbc.ini location and other, so work on
.odbc.ini (in user directory) and using direct driver specification (not use
odbcinst.ini)

You should have

.odbc.ini:
[TESTC]
Driver  = /usr/location_of_your_driver_file/lib/libtdsodbc.so
Description     = sample db
Trace   = No
Servername      = TESTC
Database        = cinar
UID     = cinar

.freetds.conf (don't use global file):
[TESTC]
   host = 10.50.104.133 # use your real ip here
   port = 1433

freddy77

=================================
"STRICTLY PERSONAL AND CONFIDENTIAL

This message may contain confidential and proprietary material for the sole
use of the intended recipient. Any review or distribution by others is
strictly prohibited. If you are not the intended recipient please contact
the sender and delete all copies.
The contents of this message that do not relate to the official business of
our company shall be understood as neither given nor endorsed by it."

=================================