SQL OLEDB Provider problem

The situation is the following on a C++ developed service connecting to SQL
Server 2000:

1 - Same queries using SQLServer 2000 Provider ODBC Driver with ADO ...no
problem

2 - When using SQL OLEDB Provider along with ADO I got several strange
things:

The CursorLocation Param:
Using a Client Side Cursor I've No Problem, but perfomances are really
worst.
Using a Server Side Cursor I got a strange behavement:

When I use a CursorType = adLockOptimistic in those queries the outcoming
recordset doesn't support updating at all.
when Using a CursorType = adLockPessimistic in the same queries, not working
with the adLockOptimistic Cursor, work...but only when I debug with
VisualStudio6 Opened. When using the same debug process(is a service) in
run-time mode (without visual studio opened) it fails for each update when
putting value in the field object. That with an an error saying the the
provider or the cursor type do not support updating on that recordset. The
error given is the Ox800A0CB3
and the query example where I get this problem is :
"SELECT * FROM DB_Titoli_RiskMap WHERE Date_Agg IN (SELECT max(Date_Agg)
FROM DB_Titoli_RiskMap ) ORDER BY ID_ISIN"
On the recordset coming from this query I get the problem.

Anyone can explain to me such a strange behaviour to find out a solution ?

Thank's a lot for anyone so gentle to anwer me..

Bye, Andrea


.

Relevant Pages

  • Re: VB connection to SQL server
    ... > the client machine begins to lose its relevance and accuracy as soon as it ... > aware that the data is probably out of date, a client sided cursor might ... > design minimises the possibility that records will have changed in the ... >> The Database server is in the office, and people use the Vb program from ...
    (microsoft.public.vb.database)
  • Re: Huge memory comsumption of ADODB Connection object
    ... unless the cursor is returning data to the client* I don't see ... I suppose this could cause some extra memory ... Is there a similar behavior in Sybase? ... Server was originally based on that rdbms, so there very well may be. ...
    (microsoft.public.data.ado)
  • Re: VB connection to SQL server
    ... "Chris Barber" wrote in message ... > recordsets (client side cursor) to allow you to persist the recordsets to ... aware that the data is probably out of date, a client sided cursor might fit ... That is because the SELECT statement is executed on the server and the data ...
    (microsoft.public.vb.database)
  • Re: Accessing A Large MS SQL Table Over ADO Components
    ... Client-side cursor fetches all rows, ... Because I had some performance loss when I set it up to Server ... Server-side cursor does not fetch all rows to client, so if server is on the ... > If we want to display the data on a readonly grid wich component is the ...
    (borland.public.delphi.database.ado)
  • Re: ADO server side cursor sloooow
    ... Using the ODBC driver my tests show that both client and server side ... forward only server side cursor is faster than a client side cursor as ... requiring over 1000 trips over the network. ...
    (comp.databases.btrieve)