S1091[ODBC Oracle]Descriptor type is out of range

From: Shawn Lee <shawnlee_at_cris.com>
Date: 1998/03/13
Message-ID: <6ebhs2$5cu@dfw-ixnews6.ix.netcom.com>#1/1

VB5, Win95, Oracle ODBC Driver, RDO

I'm getting the following error when executing the Set RdoRecordset = RdoQrydef.OpenResultset... line.

40002 S1091: [Oracle][ODBC Oracle Driver]Descriptor type is out of range.

I got this code off the Oracles support site.

Dim RdoEnvironment As RdoEnvironment
Dim RdoDatabase As rdoConnection
Dim RdoRecordset As rdoResultset
Dim RdoQrydef As RdoQuery

Set RdoEnvironment = rdoEnvironments(0) Set RdoDatabase = RdoEnvironment.OpenConnection("", rdDriverNoPrompt, False, _

"DSN=myDSN_Oracle;UID=myid;PWD=secret;") Set RdoQrydef = RdoDatabase.CreateQuery("q1", "select * from customer")

'I had to comment out the .direction, type lines, because the driver

doesn't support it.


    ' RdoQrydef(0).Direction = rdParamInputOutput

' RdoQrydef(0).Type = rdTypeCHAR
' RdoQrydef(0).Value = ""

'------here is where the error occurs
Set RdoRecordset = RdoQrydef.OpenResultset(rdOpenForwardOnly, rdConcurReadOnly)

Thanks,
Please copy responses to my email as well as this group, I'm really under the gun to get this resolved, shawnlee_at_cris.com. Shawn
-
Software Developer
Maxim Group/BellSouth Communication Systems shawnlee_at_cris.com
http://www.cris.com/~shawnlee/
Borg Pursuit Screen Saver for Windows
"I am Flanders of Borg. Prepare to be assimilly-limilly-lated" Received on Fri Mar 13 1998 - 00:00:00 CST