Skip to Content.
Sympa Menu

freetds - RE: Re[2]: [freetds] freetds & MSSQL 2000

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Thompson, Bill D (London)" <ThompBil AT exchange.uk.ml.com>
  • To: "'FreeTDS Development Group'" <freetds AT lists.ibiblio.org>
  • Subject: RE: Re[2]: [freetds] freetds & MSSQL 2000
  • Date: Wed, 6 Aug 2003 13:46:46 +0100

OK , from UNIX set environment variable TDSDUMPCONFIG to a filename,
e.g.

if csh

setenv TDSDUMPCONFIG <filename>

or if ksh

export TDSDUMPCONFIG=<filename>

then post us the contents of the file after you try the connect.

Bill
> -----Original Message-----
> From: Andrew Khlebutin [SMTP:andrey AT hm.perm.ru]
> Sent: Wednesday, August 06, 2003 1:44 PM
> To: Thompson, Bill D (London)
> Subject: Re[2]: [freetds] freetds & MSSQL 2000
>
> Hi,
>
> Thompson, Bill D wrote:
>
> TBDL> a very quick idea...
>
> TBDL> change
>
> TBDL> $dbh_mssql =
> DBI->>connect("dbi:Sybase:server=10.0.0.103:database=$dbname",$msuser,$msp
> asswd);
>
> TBDL> to
>
> TBDL> $dbh_mssql =
> DBI->>connect("dbi:Sybase:server=MSSQL2000:database=$dbname",$msuser,$mspa
> sswd);
>
> I've tried it, but it isn't working.
> $dbh_mssql =
> DBI->connect("dbi:Sybase:server=MSSQL2000:database=$dbname",$msuser,$mspas
> swd);
>
> =============================my freetds.conf=========================
> [global]
> tds version = 7.0
> try server login = no
> try domain login = no
> dump file = /tmp/freetds.log
> debug level = 10
> [MSSQL2000]
> host = 10.0.0.103
> port = 1433
> tds version = 7.0
> =============================my freetds.conf=========================
>
> /usr/local/etc/freetds/interfaces is empty.
>
> Error: MSSQL2000 server is not found.
>
> ============================/tmp/freetds.log=========================
> Starting log file with debug level 99.
> 2003-08-06 18:34:10.355095 iconv will convert client-side data to the ""
> character set
> 2003-08-06 18:34:10.355259 iconv_open: cannot convert to ""
> 2003-08-06 18:34:10.355286 IP address pointer is NULL
> 2003-08-06 18:34:10.355306 Server MSSQL2000 not found!
> 2003-08-06 18:34:10.380066 leaving ct_connect() returning 0
> 2003-08-06 18:34:10.380107 inside ct_con_drop()
> ============================/tmp/freetds.log=========================
>
> --
> Andrew Khlebutin
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds





Archive powered by MHonArc 2.6.24.

Top of Page