Re: S1091[ODBC Oracle]Descriptor type is out of range

        My suggestion to you is to check the cursor type that you use. I use ODBCDirect connection to the Oracle database. I had trouble with the cursor until I specified the DefaultCursorDriver in the workspace object.
Dim wks as Workspace
Dim cnn as Connection
Set wks = DBEngine.createWorkspace("ODBC","","",dbUseOdbc) wks.DefaultCursorDriver = dbUseOdbcCursor strCn = "ODBC;dsn=;uid=;pwd="
Set cnn = wks.OpenConnection("",dbDriverNoPrompt,True,strCn) ...

        Also, I use the Microsoft Oracle driver. Never succeeded with Oracle Odbc driver.

	Good luck.
	Stéphane Paquin

On Fri, 13 Mar 1998 10:00:57 -0500, "Shawn Lee" <shawnlee_at_cris.com> wrote:

>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")
Stephane Paquin stephane.paquin_at_ispatnet.c*m Sidbec-Dosco (Ispat) Inc.

Opinions expressed are mine.
Address changed for spammers. Received on Mon Mar 16 1998 - 00:00:00 CST