Hi All,

I have been struggling with RDO for quite a while. Phone calls to Microsoft and Oracle were put on long
queue. I decided to turn to the net community for help.

Environment:
        Server: Windows NT 3.51 Server with Oracle Workgroup Server 7.3.2.1.1
        Client: Windows 95 with Oracle ODBC Driver 1.15.3.1.0, Visual Basic 4.0 Enterprise (RDO 1.0)

The following code generate error in VB:
        Dim Cn As rdoConnection
        Dim En As rdoEnvironment
        Dim Result As rdoResultset
        Dim Conn As String
        Set En = rdoCrea{*filter*}vironment("", "myUserName", "myPassword")
        Set Cn = En.OpenConnection("myDSN")
        Set Result = Cn.OpenResultset("Select Col1 from TestTable", rdOpenForwardOnly, ,ConcurReadOnly)

I tried all the possible combinations of cursor types and lock types. It still did not work. The errors I
got were either:
        [Microsoft][ODBC Driver Manager] Driver does not support this function
        [Oracle][ODBC Oracle Driver] Driver not capable.
or
        [Microsoft][ODBC Driver Manager] Cursor library not capable
        [Oracle][ODBC Oracle Driver] Driver not capable.

Strange enough, I could make some action query work (such as "create table", "delete from"). I could also
make it work (including the "select" statement) by using DAO.
Could anyone shed some light on this for me? Your help is highly appreciated. Thanks in advance.

Jin Yang

(914)945-6379

Hi All,

I have been struggling with RDO for quite a while. Phone calls to Microsoft and Oracle were put on long
queue. I decided to turn to the net community for help.

Environment:
        Server: Windows NT 3.51 Server with Oracle Workgroup Server 7.3.2.1.1
        Client: Windows 95 with Oracle ODBC Driver 1.15.3.1.0, Visual Basic 4.0 Enterprise (RDO 1.0)

The following code generate error in VB:
        Dim Cn As rdoConnection
        Dim En As rdoEnvironment
        Dim Result As rdoResultset
        Dim Conn As String
        Set En = rdoCrea{*filter*}vironment("", "myUserName", "myPassword")
        Set Cn = En.OpenConnection("myDSN")
        Set Result = Cn.OpenResultset("Select Col1 from TestTable", rdOpenForwardOnly, ,ConcurReadOnly)

I tried all the possible combinations of cursor types and lock types. It still did not work. The errors I
got were either:
        [Microsoft][ODBC Driver Manager] Driver does not support this function
        [Oracle][ODBC Oracle Driver] Driver not capable.
or
        [Microsoft][ODBC Driver Manager] Cursor library not capable
        [Oracle][ODBC Oracle Driver] Driver not capable.

Strange enough, I could make some action query work (such as "create table", "delete from"). I could also
make it work (including the "select" statement) by using DAO.
Could anyone shed some light on this for me? Your help is highly appreciated. Thanks in advance.

Jin Yang

(914)945-6379

Paul Card

Paul is correct, the Oracle ODBC drivers are not level 2 compliant.  You
need to replace the drivers.

--
Mark Wagoner