Re: ROWID added to SQL from OLE DB driver


"Sybrand Bakker" <postbus@xxxxxxxxxxxxxxxxx> wrote in message
news:g7pep19ri5jkdd2sdqa10pj3e36od4dn3q@xxxxxxxxxx
> On Wed, 7 Dec 2005 22:22:48 +0100, "Matthias Hoys"
> <idmwarpzone_NOSPAM_@xxxxxxxxx> wrote:
>
>>Has anyone seen this weird behaviour before ? Could this be a
>>configuration
>>issue of the OLE DB Provider ? I couldn't find anything on the support
>>site
>>of Mickeysoft, will create a TAR tomorrow ...
>>
>
> Dump the Mickeysoft OLE DB provider, the Oracle provider is about
> twice as fast. Never ever use Mickeysoft drivers in conjunction with
> Oracle, it won't work without problems, ever.
>
> --
> Sybrand Bakker, Senior Oracle DBA

I found the origin of the problem, it has nothing to do with the MS OLE DB
provider (since the Oracle driver gave the same error), but with the
incorrect use of certain cursor types from within ADO.

It's explained by Metalink note 338383.1 :

This is caused by that cursor type (SQL_ATTR_CURSOR_TYPE) is downgraded from
adOpenStatic
(SQL_CURSOR_STATIC) to adOpenForwardOnly (SQL_CURSOR_FORWARD_ONLY, default).

adOpenStatic (SQL_CURSOR_STATIC) admit a scrollable cursor, which requires
a ROWID in the SQL, if the SQL will not admit a ROWID, then the cursor is
downgraded to Forward Only.

=> this is what happens here : SELECT on tables works fine, but not on views

The ODBC Driver get a PARSE error (ORA-01446) which indicate a downgrade of
the cursor to SQL
without ROWID, this is what going on beneath the Driver and the errorcode
should be restrained,
however in this case the error is populated since SQLCancel is issued by the
SQL_ATTR_QUERY_TIMEOUT is set.


.

Relevant Pages

  • Problem with Linked Server from SQL to DB2
    ... I'm trying to setup a linked server from SQL to DB2 UDB. ... Microsoft provided OLE DB driver for DB2 and the IBM DB2 OLE DB ... -- Invalid schema or catalog specified for provider 'IBMDADB2'. ...
    (microsoft.public.data.oledb)
  • Re: Reading mm datasource
    ... the OLE syntax is not relevant here. ... Doug's post helped me identify that the client has the odbc dbase driver ... Word is trying to connect using the OLE DB provider ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Reading mm datasource
    ... If you don't specify one, it will probably try OLE DB first, then possibly ODBC. ... Doug's post helped me identify that the client has the odbc dbase driver ... Word is trying to connect using the OLE DB provider ...
    (microsoft.public.word.mailmerge.fields)
  • OLE DB Provider - how tell to not use cursor internally for join
    ... The OLE DB provider find way for join table in distributed query. ... My question is - May I tell to the OLE DB provider to prohibit use te cursor ... run well under SQL 7.0 (target server for distibuted query), ...
    (microsoft.public.sqlserver.programming)
  • Registering VFPOLEDB to use as linked server
    ... VFP, however, I can't use VFPOLEDB.1 as the provider in a linked server. ... Could not locate registry entry for OLE DB provider 'VFPOLEDB'. ... I was able to use the OLE DB Provider for ODBC, ... FoxPro Driver" to create a linked server, tables and views are listed in EM, ...
    (microsoft.public.sqlserver.connect)
Loading