[freetds] [ISQL]ERROR: Could not SQLConnect

ZIGLIO, Frediano, VF-IT Frediano.Ziglio at vodafone.com
Wed May 19 11:31:46 EDT 2004


> 
> Hi,
> 
> I were trying to setup unixODBC and freetds in Redhat 
> Advanced Server 2.1 
> to access Sybase and MS SQL Server.
> The freetds version is 0.62.3 and unixODBC's is 2.2.8.
> 
> I used the following to configure freetds:
> ./configure --prefix=/usr/local/freetds --disable-threadsafe 
> --with-tdsver=7.0 --with-unixodbc=/usr/local/unixODBC
> 
> After I configured freetds.conf,  I can use Perl DBI and Perl 
> DBD::Sybase 
> to access a Sybase database and
> MS SQL Server. I can also use tsql (tsql -S views -U <username> -P 
> <password> to access those databases without any issue.
> 
> I configured odbcinst.ini and odbc.ini by using odbcinst. 
> Here are the 
> file odbcinst.ini:
> 
> [DB2]
> Description             = DB2 Driver
> Driver          = /usr/IBMdb2/V7.1/lib/libdb2.so
> FileUsage               = 1
> 
> [TDS]
> Description             = v0.62
> Driver          = /usr/local/freetds/lib/libtdsodbc.so
> FileUsage               = 1
> 
> Here is odbc.ini:
> 
> [inv]
> Description             = Tivoli Production Inventory DB2
> Driver          = DB2
> 
> [views]
> Description             = CSIRT MS SQL Server
> Driver          = TDS
> 
> [peregrine]
> Description             = Peregrine MS SQL Server
> Driver          = TDS
> 
> [visdb]
> Driver          = TDS
> Description             = SAN Point Sybase DB
> Trace           = No
> Servername              = 204.151.176.177

Servername do not point do a real server (DNS or ip) but to freetds.conf
servername. If you use DBD::Sybase I would suggest to specify Servername
with entry in freetds.conf (or you can use Server with ip address).

> Database                = visdb
> Trace           = Yes
> TraceFile       = visdb.log
> UID             = DBA
> 
...


bye
  freddy77



More information about the FreeTDS mailing list