FreeTDS Development Group

["Lowden, James K" <LowdenJK AT bernstein.com>]

> From: owen gottschalk [mailto:owen AT barkingdogstudios.com]
> Sent: January 16, 2003 10:45 AM
> 
> I am trying to use freetds to connect from a web server 
> running PHP to a
> remote server running ASA V7. So far, scanning the list 
> archive, I have
> seen that ASA version 6 and above should be able accept these
> connections without installing the open server gateway. 

You are correct, if I correctly understand "ASA" to be Sybase SQL Anywhere.


You need TDS version 5.0, port 2638.  You should at least be able to connect
to the port with telnet.  If you haven't already seen it, the nightly
snapshot includes an updated User Guide in which you'll find this
documented.  

> The sysadmin of the remote system claims to have read that 
> freetds does
> not work with ASA, but I have read otherwise numerous times. I suspect
> that because we are able to make the connection above, and communicate
> with the server in some way, that it is a configuration 
> problem with the database server.

As much as anyone, I wrote the UG, and Brian's responsible for any SQL
Anywhere assertions.  I don't remember ever saying "it doesn't work".  What
it says now is what you probably found in the archives:  

"Our best information is that SQL Anywhere first supported TDS in version
5.5.03 using the OpenServer Gateway (OSG), and native TDS 5.0 support
arrived with version 6.0."  

I wonder, what does your documentation say about, "ASA Error -75: Request to
start/stop database denied"?  That doesn't sound like a protocol problem....


If you can telnet to the port but can't connect with tsql, and are sure it's
not a permissions problem, please post a TDSDUMP log of the session (taking
care to erase the passwords).  If the server is responding abnormally, it
should show up there.  

Regards, 

--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 we do not accept account orders and/or
instructions by e-mail, and therefore will not be responsible for carrying
out such orders and/or instructions.