Skip to Content.
Sympa Menu

freetds - [freetds] php/ASA connectivity troubleshooting

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "owen gottschalk" <owen AT barkingdogstudios.com>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: [freetds] php/ASA connectivity troubleshooting
  • Date: Thu, 16 Jan 2003 10:45:00 -0500

Hello All,

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. In the past, I
have used only postgres and mysql, so using Sybase is a little strange
for me.

Myself and another developer have installed tds, and compiled PHP
according to the instructions in the freeTDS documentation. This is on a
debian box. We can't seem to get a valid connection to the remote server
which is on a windows box. Here is the error message that we get when
trying to connect using tsql. The error message that is returned through
php is similar. I used the hostname, port, username and password that I
was given.

godai@baytor:/usr/local/freetds/bin$ ./tsql -H [hostname] -p [port] -U
[username] -P [password]
Msg 6004, Level 14, State 0, Server , Line 0
ASA Error -75: Request to start/stop database denied
Msg 20014, Level 9, State 0, Server OpenClient, Line 0 Login incorrect.
There was a problem connecting to the server

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.

Has anyone ran into anything like this before? Can anyone shed some
light on this problem?

og

Owen Gottschalk <owen AT barkingdogstudios.com>
__________________________________________________
Barking Dog Studios Inc. | New Media Aficionados
phone: 877.766.0215 | fax: 519.766.9305
5 douglas st 2nd fl | guelph on n1h 2s8





Archive powered by MHonArc 2.6.24.

Top of Page