Skip to Content.
Sympa Menu

freetds - Re[4]: [freetds] freetds & MSSQL 2000

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Andrew Khlebutin <andrey AT hm.perm.ru>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re[4]: [freetds] freetds & MSSQL 2000
  • Date: Wed, 6 Aug 2003 19:31:48 +0600

Hello,

Thompson, Bill D wrote:

TBDL> OK , from UNIX set environment variable TDSDUMPCONFIG to a filename,
TBDL> e.g.
...
TBDL> then post us the contents of the file after you try the connect.

Yes, big thanks.

$dbh_mssql =
DBI->connect("dbi:Sybase:server=10.0.0.103:database=$dbname",$msuser,$mspasswd);
is not working, but
$dbh_mssql = DBI->connect("dbi:Sybase:server=MSSQL2000",$msuser,$mspasswd);
$dbh_mssql->do("use $dbname");
is working fine.

Starting log file with debug level 99.
2003-08-06 19:21:23.709236 Attempting to read conf files.
2003-08-06 19:21:23.709400 ...$FREETDSCONF not set. Trying $HOME.
2003-08-06 19:21:23.709733 Found conf file '/usr/local/etc/freetds.conf'
(default).
Reading section 'MSSQL2000:database=lan'.
2003-08-06 19:21:23.709766 Looking for section global.
2003-08-06 19:21:23.709820 ... Found section global.
2003-08-06 19:21:23.709844 Got a match.
2003-08-06 19:21:23.709868 option = 'tds version' value = '7.0'.
2003-08-06 19:21:23.709904 option = 'try server login' value = 'no'.
2003-08-06 19:21:23.709930 no is a 'no/off/false'.
2003-08-06 19:21:23.709953 option = 'try domain login' value = 'no'.
2003-08-06 19:21:23.709975 no is a 'no/off/false'.
2003-08-06 19:21:23.709998 option = 'dump file' value = '/tmp/freetds.log'.
2003-08-06 19:21:23.710024 option = 'debug level' value = '10'.
2003-08-06 19:21:23.710060 ... Found section mssql2000.
2003-08-06 19:21:23.710102 Looking for section mssql2000:database=lan.
2003-08-06 19:21:23.710132 ... Found section global.
2003-08-06 19:21:23.710197 ... Found section mssql2000.
2003-08-06 19:21:23.710228 ...'MSSQL2000:database=lan' not found.
2003-08-06 19:21:23.710273 Failed in reading conf file. Trying interface
files.
2003-08-06 19:21:23.710298 Looking for server....
2003-08-06 19:21:23.710388 Looking for server in /root/.interfaces.
2003-08-06 19:21:23.710413 Searching interfaces file //root/.interfaces.
2003-08-06 19:21:23.710448 Couldn't open /root/.interfaces.
2003-08-06 19:21:23.710472 Looking for server in /etc/freetds/interfaces.
2003-08-06 19:21:23.710493 Searching interfaces file /etc/freetds/interfaces.
2003-08-06 19:21:23.710525 Couldn't open /etc/freetds/interfaces.
2003-08-06 19:21:23.710548 Setting 'tmp_port' to 1433 as a guess.
Parsed servername, now MSSQL2000 on 0.

--
Andrew Khlebutin





Archive powered by MHonArc 2.6.24.

Top of Page