SQL Passthrough Problems

From: Northern Lake Service <norlake_at_newnorth.net>
Date: 1997/10/01
Message-ID: <3432749A.5B07AE20@newnorth.net>#1/1

I have an Oracle 7 database on SCO Unix named NLS. From Win 95 computer I made an ODBC connection called NLS to the Oracle Database on the unix computer.

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. Received on Wed Oct 01 1997 - 00:00:00 CDT