FreeTDS Development Group

[Michael Peppler <mpeppler AT peppler.org>]

On Mon, 2004-11-01 at 18:48, Rick D. Conner wrote:
> Ok, I'm kind of at the end of my patience here... Is there anyone out there
> that would set this up for either free or for a fee?

Have you used telnet from the client side to connect to the ip
address/port that you specified in the freetds.conf file?

The error message that you get indicates that there is no Sybase/MS-SQL
server listening at the address/port that you've configured.

Or maybe there's a firewall in the way?

Michael

> 
> Rick D. Conner
> Rick AT WeDoSites.com
> http://www.wedosites.com
>  
> 
> -----Original Message-----
> From: Frediano Ziglio [mailto:freddyz77 AT tin.it] 
> Sent: Monday, November 01, 2004 11:35 AM
> To: FreeTDS Development Group
> Subject: RE: [freetds] Re: connecting to remote MS Sql 2k server from linux
> PHP
> 
> Il lun, 2004-11-01 alle 16:50, Rick D. Conner ha scritto:
> > Ok, I did add an entry to the .freetds.conf file named [SYBASE] and set it
> > up and it now finds it and finds the right ip etc... But it still doesn't
> > connect. I get the following in tds.log.txt:
> > 
> > Starting log file for FreeTDS 0.62.3
> >     on 2004-11-01 10:45:02 with debug level 99.
> > iconv to convert client-side data to the "ISO-8859-1" character set
> > 10:45:02.516082 tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
> > 10:45:02.516113 Connecting to 66.208.184.170 port 1433, TDS 4.2.
> > 10:45:07.511429 tds_client_msg: #20009: "Server is unavailable or does not
> > exist.".  Connection state is now 0.  
> > 
> > So I guess what I need to know now, is what are the "network" items that
> > need checked and any settings to ensure is setup at both ends. I've got
> the
> > port opened on the router, and the webhost said they did the same. The
> > documentation doesn't include much about this at all, and I don't have
> > command line access...
> > 
> 
> FreeTDS do not hidden any wire data from log for protocol 4.2. Searching
> for your message say that FreeTDS can't just connect(2) to server. Have
> you tried with a "telnet 66.208.184.170 1433" ??
> Do not use protocol 4.2 for production, it has very limited features.
> 
> freddy77
> 
> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
> 
> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
-- 
Michael Peppler                              Data Migrations, Inc.
mpeppler AT peppler.org                       http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or 
long term contract positions - http://www.peppler.org/resume.html