RE: - isql is failing whereas tsql can connect to the server.

Thanks Peter,
   odbcinst returned the followings, which are correct.
mxs1@hydra:258 % odbcinst -j
unixODBC 2.2.5
DRIVERS............: /usr/local1/unixodbc/etc/odbcinst.ini
SYSTEM DATA SOURCES: /usr/local1/unixodbc/etc/odbc.ini
USER DATA SOURCES..: /home/mxs1/.odbc.ini
mxs1@hydra:259 % 

Got some additional info from -v option

mxs1@hydra:260 % isql -v MSSQLDEV mxs1_test
[unixODBC][Driver Manager]Can't initiate unicode conversion
[unixODBC]Client unable to establish connection
[ISQL]ERROR: Could not SQLConnect

Manoranjan

-----Original Message-----
From: Peter Harvey [mailto:pharvey@xxxxxxxxxxxxxxxx]
Sent: Saturday, April 05, 2003 9:32 PM
To: unixodbc-dev@xxxxxxxxxxxx
Subject: Re: [unixODBC-DEV] - isql is failing whereas tsql can connect
to the server.


Try using "odbcinst -j" and other query options to ensure that the 
odbcinst is picking up the correct files. Then try "isql -v" and see 
what additional information you may get from your failed connect.

Peter


manoranjan_sahu@xxxxxxxxxxx wrote:
> OK, One issue was it was trying to find odbcinst.ini files in /usr/local/etc. 
> So I set the environment variable ODBCSYSINI to /usr/local1/unixodbc/etc, But 
> isql fails with the same error
> 
> "[ISQL]ERROR: Could not SQLConnect"
> 
> But I see the freetds trace file.
> 
> hydra# cat /tmp/freetds.log
> Starting log file with debug level 99.
> 2003-04-05 20:26:20.955023 iconv will convert client-side data to the "" 
> character set
> 2003-04-05 20:26:20.975731 iconv_open: cannot convert to ""
> 2003-04-05 20:26:20.977242 IP address pointer is NULL
> 2003-04-05 20:26:20.978399 Server SYBASE not found!
> hydra# 
> 
> Please help.
> 
> Manoranjan
> 
> 
> -----Original Message-----
> From: manoranjan_sahu@xxxxxxxxxxx [mailto:manoranjan_sahu@xxxxxxxxxxx]
> Sent: Saturday, April 05, 2003 7:51 PM
> To: unixodbc-dev@xxxxxxxxxxxx
> Subject: [unixODBC-DEV] - isql is failing whereas tsql can connect to
> the server.
> 
> 
> 
> Hello, 
>    I am trying to build freetds with unixodbc. I built freetds with unixodbc 
> option. Build and install ran clean. After that I was able to connect to the 
> SQL server with the following driver in the configuration file using tsql. 
> tsql -S MSSQL -U mxs1_test
> 
> /usr/local1/freetds/etc/freetds.conf
> -------------------------------------------------
> # A typical Microsoft SQL Server 7.0 configuration
> [MSSQL]
>         host = saxp.osi.com
>         port = 1433
>         tds version = 7.0
> 
> 
> However, isql fails with following error.
> 
> mxs1@hydra:201 % isql MSSQLDEV mxs1_test
> [ISQL]ERROR: Could not SQLConnect
> mxs1@hydra:202 % 
> 
> My odbcinst.ini and odbc.ini files are as follows. And the interesting thing 
> is I have got trace on for freetds, So tsql writes the
> trace to the log file whereas isql does not write anything there. Here is my 
> isql command.
> isql MSSQL_DSN mxs1_test
> 
> Did I miss something ? Any help will be appreciated.
> 
> Thanks,
> Manoranjan
> 
> /usr/local1/unixodbc/etc/odbcinst.ini
> -----------------------------------------------------
> [MSSQL]
> Description             = MSSQL driver for Solaris
> Driver          = /usr/local1/freetds/lib/libtdsodbc.so
> FileUsage               = 1
> 
> ~/.odbc.ini
> ------------------
> [MSSQLDEV]
> Driver      = MSSQL
> Description     = sample database
> Trace       = Yes
> Servername      = saxp.osi.com
> Database        = tempdb
> UID     = mxs1_test
>