Re: Transactions from ADODB/VB against ASE 15.x vs. 12.x

Michael Peppler wrote:
On Wed, 01 Aug 2007 10:52:02 +0200, Dag Sunde wrote:

Dag Sunde wrote:


Does this shed some light on what might be the problem?

http://dagsunde.com/Pictures/ASE.jpg

Not really. There doesn't seem to be anything obviously wrong with
that snapshot. But then I don't know what process in the server
corresponds with your client app...


Problem solved...

This is a problem I have experienced on more than one occation
in my brief experience with Sybase ASE...

Write a stored procedure, and call it from the client, and it hangs.
Copy the SQL from the sp_xxx and into the client, and execute it
from there, and it works...

This was a case of an sp. that worked on ASE15.x when called from
the client, but calling the same sp on ASE12.x hung.
Copying the SQL to the client, and executing it from there worked
on both ASE 12.x and 15.x

Beats me... ?

--
Dag.


.

Relevant Pages

  • Re: Stored procedure/trigger and scripts
    ... must have been the trigger that locked up the table. ... SQL Server has permissions to execute xp_cmdshell. ... >> client to change their password they have to call the "Client Relations" ...
    (microsoft.public.sqlserver.programming)
  • Re: Stored procedure/trigger and scripts
    ... I just ran some additional tests and it looks like my trigger is fine. ... SQL Server has permissions to execute xp_cmdshell. ... >> client to change their password they have to call the "Client Relations" ...
    (microsoft.public.sqlserver.programming)
  • Re: Stored procedure/trigger and scripts
    ... SQL Server has permissions to execute xp_cmdshell. ... Please read up on xp_cmdshell within Books Online (within the SQL Server program group). ... >> client to change their password they have to call the "Client Relations" ...
    (microsoft.public.sqlserver.programming)
  • Re: About MBR SAO and threads...
    ... So if 2 threads in the client are making 2 different calls to remoted ... i'm exposing a MBR object (let's call it ManagerObject) as ... > instance of a second MBR object (ClientObject, singleton as well). ... > that every method of those 2 objects take several seconds to execute. ...
    (microsoft.public.dotnet.framework.remoting)
  • Re: Stored procedure/trigger and scripts
    ... If the vbs can run totally unattended it should work as long as the [SQL] has the appropriate permissions to execute xp_cmdshell. ... In order for a> client to change their password they have to call the "Client Relations"> department who change the password in the table with access. ... >> a table on a SQL 7 server and the accounts for the local file server were ...
    (microsoft.public.sqlserver.programming)