FreeTDS Development Group

[JKosta AT morrisbart.com]

Thank you James and Brian.

I will try changing the protocol to 5.0.

You are right James, I have at least version .60 of Freetds (I mistakenly 
got that version number 1.5 from the freetds.conf file).
My only concern with trying the 5.0 protocol is that this chart 
http://www.freetds.org/userguide/x545.htm#AEN551
says to use the 5.0 protocol for Sybase System 10 or above and we have 
Sybase Server Anywhere version 7.0.1.918, though maybe those versions are 
not apples to apples comparisons.
Thank you both for your help.
--John




"Lowden, James K" <LowdenJK AT bernstein.com>
Sent by: bounce-freetds-149896 AT franklin.metalab.unc.edu
10/11/2002 12:01 PM
Please respond to "TDS Development Group"

 
        To:     "TDS Development Group" <freetds AT franklin.metalab.unc.edu>
        cc: 
        Subject:        [freetds] RE: Sybase server crash


> From: JKosta AT morrisbart.com [mailto:JKosta AT morrisbart.com]
> Sent: October 11, 2002 1:13 PM
> 
> Hello,

Welcome, John.

> We are attempting to get our Apache/PHP/Linux box to generate 
> dynamic web
> pages from data stored in a Windows 2000/Sybase Adaptive 
> Server Anywhere version 7.0.1.918 database.
> 
> We are using PHP 4.2.3, Apache 1.3.2, and Freetds 1.5.

Um, the latest release of FreeTDS is 0.60.1.  Where did you find 1.5?  ;)

> When I connect via tsql (from the /usr/local/freetds/bin 
> directory) this is what I get:
> 
> Msg 21, Level 10, State 0, Server , Line 0
> TDS: unexpected token 95
> 1>
> 
> So that appears to be working (though I don't know what the 
> "unexpected
> token 95" means--perhaps an indication of problems?).

I suspect you are using the wrong version of the TDS protocol.  You should
be using TDS 5.0, which is the default.  You might want to try falling 
back
to 4.2; you can do that by setting the TDSVER environment variable (e.g.,
"export TDSVER=4.2"). 

Both 4.2 and 5.0 should work with Sybase Adaptive Server Anywhere, AFAIK.
If you have problems with either one (especially of the "unexpected token"
variety), please set TDSDUMP and post the log file.  Beware that it 
contains
your password; you might want to xxx that out. 

--jkl


The information contained in this transmission may contain privileged and
confidential information and is intended only for the use of the person(s)
named above.  If you are not the intended recipient, or an employee or 
agent
responsible for delivering this message to the intended recipient, any
review, dissemination, distribution or duplication of this communication 
is
strictly prohibited. If you are not the intended recipient, please contact
the sender immediately by reply e-mail and destroy all copies of the
original message. Please note that for certain accounts we do not accept
orders and/or instructions by e-mail, and for those accounts we will not 
be
responsible for carrying out such orders and/or instructions. Kindly 
refrain
from sending orders or instructions by e-mail unless you have confirmed 
that
we accept such communications for your account. Please also note that to
satisfy regulatory requirements we review the outgoing and incoming e-mail
correspondence of staff members serving certain functions.



---
You are currently subscribed to freetds as: [jkosta AT morrisbart.com]
To unsubscribe, forward this message to 
$subst('Email.Unsub')