Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Daniel Fazekas <fdsubs AT axelero.hu>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: [freetds] Re: ASA Error -83 when connecting from PHP
  • Date: Wed, 7 Apr 2004 23:58:00 +0200


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





Archive powered by MHonArc 2.6.24.

Top of Page