MSDAORA Provider Question

[Dynapen]

I need to know if anyone knows a good resource for what properties are supported by the MSDAORA provider (the Microsoft OLE DB for Oracle provider).

I am building a web app with Paged reports. So that each page only shows a certain number of records. I can set the pagesize using rs.pagesize. But when I try to set rs.absolutepage, or rs.absolutepositon, it tells me that bookmarks are not supported either by the cursor or the provider.

I am using
rs.cursorlocation = adUseClient
rs.cursortype = adOpenStatic

which is what MS says to use for these properties. So I need to verify that the provider supports the absolutepage/positon commands.

Anyone know where I can look. I checked MSDN, but I couldn't find a list of what is and is not supported. The money's gone, the brain is shot.....but the liquor we still got.

 

[Turkbear]

Have you tried using the Oracle provider?

 

[Dynapen]

Actually, I found the answer.

I was using the open as such.

set rsobj = commobj.execute

So that the commobj would execute the command text I had already passed it. When I switched it to work this way, everything worked fine.

rsobj.open commobj

This way it still uses the commobj and the commandtext, so i can parameterize the query fairly easily, but the rs properties i needed came back. The money's gone, the brain is shot.....but the liquor we still got.