Help! Problems with VB40/32 RDO and Win95 Oracle ODBC driver

From: Ståle Prestøy <sp_at_sds.no>
Date: 1996/04/27
Message-ID: <3182131C.164F_at_sds.no>#1/1


After I successfuly have created a rdoEnvironment and rdoConnection, I try = to create a Resultset with a =

SQL-string.

During this I end up with the following ODBC-errors:

	S1C00: [Oracle][ODBC Oracle Driver]Driver not capable.
	01S02: [Microsoft][ODBC Cursor Library] Option value changed
	IM001: [Microsoft][ODBC Driver Manager] Driver does not support this funct=
ion

Is this a known error among Oracle ODBC32-users (Oracle support i Norway di= dn't know of such problems), =

or is it my code which is the problem?

A copy of the code follows here:

Private Sub Form_Load()

Dim rdoGEnv As rdoEnvironment
Dim rdoGDemoModel As rdoConnection
Dim stmtPerson As rdoPreparedStatement
Dim setPerson As rdoResultset

Set rdoGEnv =3D rdoCreateEnvironment("DemoModel", "SR", "SR") Set rdoGDemoModel =3D rdoGEnv.OpenConnection("cors") Set stmtPerson =3D rdoGDemoModel.CreatePreparedStatement("", _

                 "select LASTNAME, FIRSTNAME from person where PERSONID=3D1=
708478754")
Set setPerson =3D stmtPerson.OpenResultset(rdOpenKeyset, rdConcurReadOnly)

Text1.Text =3D setPerson("lastname").Value & " " & setPerson("firstname").V= alue

End Sub

  • =

St=E5le Prest=F8y, Statens Datasentral a.s

Internet : sp_at_sds.no
X.400 : G=3DStale;S=3DPrestoy;O=3Dsds;P=3Dmultinett;A=3Dtelemax;C=3Dno; HomePage: http://www.sds.no/~sp/
Finger: sp_at_daneel.sds.no Received on Sat Apr 27 1996 - 00:00:00 CEST

Original text of this message