Re: SQL Passthrough Problems

Unfortunately, VB is very poor when it comes to popping the errors sent by the db server. Runtime error 3146 is very generic. Last time I checked, the error number was of no use.

The way to solve this would be to go thru the ODBC traces and get the error being sent by the server. It may be a simple problem... but you need to know the full error message to resolve the issue.

-sm

On Wed, 01 Oct 1997 11:04:43 -0500, Northern Lake Service <norlake_at_newnorth.net> wrote:

>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 Fri Oct 03 1997 - 00:00:00 CDT