FreeTDS Development Group

[Steven Orton <sorton9999 AT usa.net>]

  i just had this problem:)  basically, the driver is trying to use a default
setup because it can't resolve certain information from your ODBC files.  JKL
pointed me to the odbc-only portion of the UG.  this is off the top of my
head, but it makes mention of using Server=<DB server name> and Port=<default
1433 or specific #> along with Database, Version, Driver, etc.  i made the
changes and voila...dataflow.

  give it a try...steve---


"Daughterson, Adam [EPM/BOU/MMI]" <Adam.Daughterson1 AT EmersonProcess.com>
wrote:

> How embarrassing!  
> 
> I posted that I had been able to connect to the MSSQL7 server, but not the
> MSSQL2K server, which was true, but now that I have TDSDUMP being populated
> when I try to connect to the SQL2000 server, this is the error:
> 
> root@USBOU1-DHDLINUX:/usr/local/etc# isql esp_ms_sql user passwd
> Starting log file for FreeTDS 0.62.dev.20031224
>         on 2004-01-05 17:40:24 with debug level 99.
> names for ISO-8859-1: ISO-8859-1
> names for UTF-8: UTF-8
> names for UCS-2LE: UCS-2LE
> names for UCS-2BE: UCS-2BE
> iconv to convert client-side data to the "ISO-8859-1" character set
> 17:40:24.654251 tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
> 17:40:24.654360 IP address pointer is NULL
> 17:40:24.654401 Server SYBASE not found!
> [ISQL]ERROR: Could not SQLConnect
> root@USBOU1-DHDLINUX:/usr/local/etc#
> 
> For all I know, this has been the error all along, I was just using
> TDSDUMPCONFIG=somefile to try and capture the error.
> 
> So Sybase...
> I can't find in any of the config files where Sybase is even mentioned,
> could this be related to connecting a SQL2000 Database on a Win2003 server?
> 
> 
> Apologies for the clutter!
> AD
> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
> 



-------------------------------
Steven Orton
sorton9999 AT usa.net
--
"Put your hand on a hot stove for a minute,
 and it seems like an hour.
 Sit with a pretty girl for an hour, and it
 seems like a minute. THAT'S relativity."
        -- Albert Einstein
-------------------------------