Skip to Content.
Sympa Menu

freetds - RE: [freetds] [ISQL]ERROR: Could not SQLConnect

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] [ISQL]ERROR: Could not SQLConnect
  • Date: Wed, 19 May 2004 17:31:46 +0200

>
> 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




Archive powered by MHonArc 2.6.24.

Top of Page