SQLPassthrough from Visual Basic to Oracle. HOW?

From: Northern Lake Service <norlake_at_newnorth.net>
Date: 1997/09/30
Message-ID: <34315804.FC1B1045@newnorth.net>#1/1

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