Skip to Content.
Sympa Menu

freetds - Re: [freetds] Re: ASA Error -83 when connecting from PHP

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Daniel L. Eriksson" <daniel AT edeinternet.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Re: ASA Error -83 when connecting from PHP
  • Date: Thu, 08 Apr 2004 17:29:58 -0500

I solved the problem today. I had to change the TDS configuration to:

# My data base server
[Prueba]
host = 192.168.0.101
port = 3030
tds version = 5.0

It also seems that there was a problem on the Sybase server, which was also fixed.

Thank you all for your help!

Daniel



At 11:58 PM 4/7/2004 +0200, Daniel Fazekas wrote:
-----------------------------------------------------------------------


On Apr 7, 2004, at 23:36, Daniel L. Eriksson wrote:

I have installed FreeTDS 0.62, compiled with PHP under Linux Redhat 9.

SyBase server is ASA 8.0.
I send this command:
sybase_connect("192.168.0.101:3030","DBA","SQL");
And get this error:
Sybase message: ASA Error -83: Specified database not found (severity
16)
I tried 'telnet 192.168.0.101 3030', which works fine. I'm also able
to connect through ODBC to the same IP and port w/o problems.
I read on this list that the problem could be not sending the data
base name with the server name. Is that the problem, and if so, how do

I send it?

AFAIK, you can only switch the database after you have successfully
connected.

Your problem could be similar to what we once experienced with MS SQL
Server 2000, which most likely inherited this feature from Sybase. In
MSSQL each SQL user has a specific default database, configurable in
Enterprise Manager. Our user's default database did exist, but we had
no access rights to it. So our connection attempts were refused
outright, even though there were several other databases that our user
had rights to -- just not to this default database. The solution was
simply to change our user's default database in MS SQL Enterprise
Manager.

--
fds

_______________________________________________
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





  • Re: [freetds] Re: ASA Error -83 when connecting from PHP, Daniel L. Eriksson, 04/08/2004

Archive powered by MHonArc 2.6.24.

Top of Page