[PHP-DEV] PHP 4.0 Bug #7370: sybase and php connection From: tomcwh <email protected>
Date: 10/20/00

From: tomcwh <email protected>
Operating system: WINNT, WIN98
PHP version: 4.0.3pl1
PHP Bug Type: Sybase-ct (ctlib) related
Bug description: sybase and php connection

see below

Tom,
Since you are using the "sa" user to connect to Sybase, Sybase is
automatically moving you to the Master DB. This is because the "sa"
user is
used almost exclusively for administrative tasks covering all of the
databases. But then PHP trys to connect in the database you specified.
And
Sybase is confused because you are not in that database.
I think if you create another user (beside sa), under the database you
are
trying to connect to you should not have any more problems.

Hope this helps,
Terry

> -----Original Message-----
> From: Tom [mailto:tomcwh <email protected>]
> Sent: Monday, October 16, 2000 1:37 AM
> To: php-db <email protected>
> Subject: [PHP-DB] sybase and php
>
>
> I have a problem when using php to connect ASE via
> OpenClient.
> But I dont know where would be appropriate for me to
> post this
> message. Anyway, I did, sorry for any inconvenience
> caused.
>
> I configured a machine with php, pws and open client.
> Then the php
> scripting engine seems working fine. And then I
> created a file named
> "sybase.php" to test the connection between the php,
> open client and
> ASE.
> However, the return shows that there is something
> wrong with the ASE.
> Afterward, I searched the manuals.sybase.com almost
> entirely for an
> answer about the error message. But I got nothing,
> would someone can
> help to me to solve it. Thanks.
>
> The following shows that content of the sybase.php
>
> <?php
> $connect=sybase_connect("TEST","sa", "") or
> die ("Could not connect to the sybase server!");
> $selectdb=sybase_select_db("mydb",$connect) or die
> ("could not select db");
> $clssybase=sybase_close($connect) or die
> ("Cound not close sysbase database server");
> ?>
>
> The following shows the content of the error message.
>
> Warning: Sybase: Server message: Changed database
> context to 'master'.
> (severity 10, procedure N/A) in
> D:\Inetpub\wwwroot\cgi-bin\sybase.php on
> line 4
> PHP has encountered an Access Violation at 01FA03B3
>
> Thomas
>
> =====
> Tom
> mailto:tomcwh <email protected>
>
>

On Mon, 16 Oct 2000 09:42:06 +0800, Thomas <tomcwh <email protected>> wrote:

Guessing but I suspect you have the wrong calling convention for the
Sybase error message handler and the stack becomes corrupted in the call
to the message handler.

The calling convention for openclient called functions is __stdcall.
So the error message handlers are defined like this:

CS_RETCODE CS_PUBLIC client_handlers(... etc ...)
on the NT platfrom CS_PUBLIC is defined : #define CS_PUBLIC __stdcall

This allows you to use whatever calling convention you want in your
program but assures that the error handler will be calling properly. Use
this calling convention for both the client and the server message
callback() functions.

Jay

>I have a problem when using php to connect ASE via OpenClient.
>But I dont which newsgroup that would be appropriate for me to post
this
>message. Anyway, I did, sorry for any inconvenience caused.
>
>I configured a machine with php, pws and open client. Then the php
>scripting engine seems working fine. And then I created a file named
>"sybase.php" to test the connection between the php, open client and
>ASE.
>However, the return shows that there is something wrong with the ASE.
>Afterward, I searched the manuals.sybase.com almost entirely for an
>answer about the error message. But I got nothing, would someone can
>help to me to solve it. Thanks.
>
>The following shows that content of the sybase.php
>
><?php
>$connect=sybase_connect("TEST","sa", "") or
>die ("Could not connect to the sybase server!");
>$selectdb=sybase_select_db("mydb",$connect) or die
>("could not select db");
>$clssybase=sybase_close($connect) or die
>("Cound not close sysbase database server");
>?>
>
>The following shows the content of the error message.
>
>Warning: Sybase: Server message: Changed database context to 'master'.
>(severity 10, procedure N/A) in D:\Inetpub\wwwroot\cgi-bin\sybase.php
on
>line 4
>PHP has encountered an Access Violation at 01FA03B3
>
>Thomas
>mailto:tomcwh <email protected>
> 

-- 
Edit Bug report at: http://bugs.php.net/?id=7370&edit=1

-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: php-dev-unsubscribe <email protected>
For additional commands, e-mail: php-dev-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>