FreeTDS Development Group

["Thompson, Bill D (London)" <ThompBil AT exchange.uk.ml.com>]

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