DevOps, CI/CD and Automation

Hi,
For some reason, we can not open a resultset of type rdOpenForwardOnly in RDO 2 on certain table (most of them). The error 07006: [Oracle][ODBC]Restricted data type attribute violation. 0 occurs.

Here's the code

Dim cn As rdoConnection
Dim en As rdoEnvironment

Set en = rdoEnvironments(0)
Set cn = en.OpenConnection(dsName:="Oracle_NT-DEV")

Dim rs As rdoResultset
Dim strSQL As String

strSQL = "SELECT * FROM PROJETS"

'NOT Working
Set rs = cn.OpenResultSet(strSQL, rdOpenForwardOnly)

'Working
Set rs = cn.OpenResultSet(strSQL, rdOpenKeyset)


Here's the configuration

Win2000 sp2
MDAC 2.7
Oracle Server 8.1.7
Net8 Client 8.1.7.0.0
Oracle 8i ODBC driver 8.1.7.5.0

Any help would be grealtly appreciated!

Thanks

Frederic Goulet