Re: SQLPassthrough from Visual Basic to Oracle. HOW?

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

 It looks like you are using a sequence. You should be able to get its value using "select inst_head.nextval from dual" (DUAL being the standard 1-row dummy table in Oracle used for returning results of functions, sequences, etc.). If this works in the SQL passthrough query window in Access you should be able to use this in code using DAO. If you are using 32-bit VB4, you can also look into RDO which is similar to DAO in some respects, but is designed for for client/server and does not have it's own query engine.
You can also use Oracle Objects for OLE. It should be on your Oracle install CD.

>Can someone PLEASE help me with the following problem:
>
>I'm trying to get Visual Basic 4.0 Professional Edition to execute and
>return a result of an sql statement on an Oracle V7.x database.
>
>The sqlnet connect string is: T:unix2:NLS
>the sequence name is: inst_head
>the table owner is: aspen
>password is: stracter
>
>How do I get VB to get the inst_head.nextval from the Oracle Database?
>
>I've read everything I can on sqlpassthrough, but cannot get this to
>work. I can attach tables in Microsoft Access and manipulate them, but
>I would really like to know how to execute and return results with
>sqlpassthrough.
>
>Any help would be greatly appreciated!
>
>Chris Geske
>LIMS Manager
>Northern Lake Service, Inc.
>email: norlake_at_newnorth.net
>
Received on Tue Sep 30 1997 - 00:00:00 CDT