ADO and MetaData

Hi,

We have a critical problem migrating our application to use SQLServer 2005.
One of our processes is breaking down.
The application is using ADO + Delphi 7 and has been operating without
problem for many years on previous versions of SQLServer.

In the problem process we are executing multiple SP's using TADOStoredProc
components. The SP's are doing inserts or updates.
The process is wrapped with BeginTrans, CommitTrans and on exception:
RollbackTrans. The first time the process is run everything commits
w/o error. The 2nd time the process is run, nothing gets committed.
After each insert or update in the SPs we test IF @@error <> 0 and
RAISERROR(ErrorMsg, 16, 2) WITH NOWAIT SETERROR but no error is ever
returned to the client.
On running the Profiler trace we discovered the SET FMTONLY ON and SET
NO_BROWSETABLE ON statements. Then the SP is being executed with empty
parameters (there is no RPC statement either). The SET FMTONLY OFF and SET
NO_BROWSETABLE OFF statements then follow. The SP is also being executed
with the correct parameters from our application. It is when the SP is being
executed with empty parameters that the internal rollback appears to be
occuring.

Microsoft have indicated that Delphi is trying to collect metadata
information for the client and said it is a Delphi issue.
Does anyone know how to prevent the metadata call?

We are using an asynchronous ADOConnection,
IsolationLevel=ilCursorStability, Persist Security Info=true,Provider=
SQLOLEDB
and a client side cursor.

Thank-you
Michael


.

Relevant Pages

  • Re: Is Borland QA *really* lacking?
    ... web services isn't something that has really ever been well ... > ability to create SOAP clients was only added in a Delphi 6 update. ... The new IW Standard, IW Data, IW Client Side, and IW Control pages provide ... IntraWeb components for developing Web-based applications. ...
    (borland.public.delphi.non-technical)
  • Re: How about "Rapid Rich Internet Application Development"?
    ... Even more because there are many new initiatives targeting the same market (Google API, Adobe AIR and SilverLight). ... I have not looked at the details but if the AMF3 specification was implemented in Delphi you could have binary transfer between the client and the Delphi backend. ... And why should an application developer have to manually write remote functions/objects on the server and then write code on the Client to call these functions? ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: We need Grasshopper for Delphi!!
    ... COM. Delphi GUI client can also access J2ME on embedded devices. ... Java is able to access Delphi component or even ...
    (borland.public.delphi.non-technical)
  • Re: Stop the negativism!
    ... virtually nobody uses Delphi for .Net work, ... RO built a full compiler for VS in a much shorter ... Turbo Delphi Explorer made us take a look at Delphi for the client ... side again as we still have Win32 client components to maintain. ...
    (borland.public.delphi.non-technical)
  • Re: D8 may be 32 bit only
    ... > available for people with knowledge of Borland's Delphi language but it ... Software Developer: ... TEK systems is looking for a Sr Level Tester to work for our client ... Our Client is looking for 5 Senior Programmer Analysts. ...
    (borland.public.delphi.non-technical)