This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 31st, when you will be able to use this site as normal.

    Forum Stats

  • 3,890,899 Users
  • 2,269,649 Discussions


Does OraOLEDB allow filtering on ADO recordset?

Hello guys,

Here is my problem:

I have a connection opened like this:
cn.Open "Provider=OraOLEDB.Oracle;OLEDB.NET=true;PLSQLRSet=true;Password=" & Application("password2") & _
";User ID=" & Application("username2") & ";Data Source=" & strDSN

I'm reading some data into a recorset and I want to filter it:
Set rs = cn.execute(some SQL querry)
rs.Filter = "GROUPNAME like 'GMPMPRO%'"

I'm getting this error:
Provider error '80004005'
Unspecified error

Can anyone tell me what should I do?

I mention that I'm using Oracle8i Enterprise Edition Release and that prior to switching on OraOLEDB I succesifuly used this connection:
cn.Open strDSN, Application("username2"), Application("password2")

Thank you.
This discussion has been closed.