Re: SQLPassthrough from Visual Basic to Oracle. HOW?

From: Northern Lake Service <norlake_at_newnorth.net>
Date: 1997/10/01
Message-ID: <34326F2D.C873FE3E@newnorth.net>#1/1

Mike Hackett wrote:

> I'm assuming that if you can attach in Access, you've already got SQL*Net
> and ODBC drivers configured correctly.
>

SQL*Net and ODBC are working correctly, but I cannot get the following code to work:

Dim Rs As Recordset, Db As Database, Ndb As Workspace Set Ndb = Workspaces(0)
Set Db = Ndb.OpenDatabase("NLS", False, False, "odbc;dsn=NLS;uid=aspen;pwd=scattner;database=NLS") Set Rs = Db.OpenRecordset("select ih_id.nextval from dual;", dbOpenSnapshot, dbSQLPassThrough)
Rs.Close

The above gives me ------ "Run-time error '3146': ODBC-call failed."

I have NLS in the ODBC Administrator, and the ODBC Test on it works fine.

I've tried the CreateQueryDef too, but must be doing it wrong.

Any ideas on what i'm doing wrong???

Chris Geske
LIMS Manager
Northern Lake Service, Inc.
email: norlake_at_newnorth.net Received on Wed Oct 01 1997 - 00:00:00 CDT