Re: Accessing oracle database from Visual Basic

From: Sylvain Faust Int'l <webmaster_at_sfi-software.com>
Date: 1997/10/26
Message-ID: <01bce1b9$c04555a0$331bf8ce@not-available.none.non>#1/1

Visual Basic Programmer's Journal 1997 Reader's Choice Award (SQL-Sombrero exposes the native database server API. No need of any middleware, guessware, maybeware or ODBC.)

Sylvain Faust Inc. (SFI) is pleased to announce that SQL-Sombrero/OCX recently received the Visual Basic Programmer's Journal 1997 Reader's Choice Award in the Database Utilities category.

"SQL-Sombrero continues to deliver something hard to find in many other products: it works, it's fast and it's reliable" VBPJ, Spring 1997 Buyer's Guide & Product Directory, P21

For details on the SQL-Sombrero family of products: http://www.sfi-software.com

o SQL-Sombrero/OCX for OCI (ORACLE Call Interface)
o SQL-Sombrero/OCX for Sybase CT-Library
o SQL-Sombrero/OCX for DB-Library 4.x and 6.x (Sybase and Microsoft)

o VBX versions also available

SQL-Sombrero exposes the native database server API. No need of any middleware, guessware, maybeware or ODBC.

###
For more information, queries can be addressed by phone, (819) 778-5045, ext. 152; fax, (819) 778-7943; or the Internet, info_at_sfi-software.com. Visit the SFI Web site at http://www.sfi-software.com for more details, including an on-line product demonstration and free evaluation copy of SFI products.

Founded in 1988, Sylvain Faust Inc. is an international software development firm providing client/server solutions based on Microsoft SQL Server, Sybase SQL Server and Oracle Server. SFI is a Microsoft Solutions Provider and a member of the Oracle Worldwide Business Alliance Programme, the Sybase Open Solutions Program and the Informix Solutions Alliance. In addition to SQL-Programmer, SFI develops and markets SQL-Optimizer and the SQL-Sombrero family of programming utilities for Visual Basic programmers.

# # #

SQL-Programmer is a registered trademark and SQL-Sombrero, SQL-Optimizer and CompressIT are trademarks of Sylvain Faust Inc. All other product and company names mentioned herein are the trademarks of their respective owners.

Zachary Taylor <taylorzac_at_bah.com> wrote in article <62ktr8$9ei$1_at_news.bah.com>...
> Any help would be appreciated, as I am new to Oracle.
>
> I am trying to insert into an Oracle database from Microsoft Access 97.
 I
> am using an ODBC connection to an Oracle 7.3 database. When ever I try
 to
> do multiple Execute sql statement it hangs. If I comment out either of
 the
> two Execute sql commands it runs fine. I will eventually be attempting
 to
> do basically a thousand of so inserts. Is there a better way to do this?
>
> My code follows:
>
> Sub Import_dbf()
> Dim wrkODBC As Workspace
> Dim myDB As Database
> Dim conPubs As Connection
> Dim rs_per_oracle As Recordset
> Dim rs_per_dbf As Recordset
> Dim sql As String
>
> Set wrkODBC = CreateWorkspace("", "dauuser", "dauuser", dbUseODBC)
> Set conPubs = wrkODBC.OpenConnection("Dau", False, False, "odbc;")
> Set myDB = DBEngine.Workspaces(0).Databases(0)
> Set rs_per_dbf = myDB.OpenRecordset("Margpers", DB_OPEN_TABLE)
> rs_per_dbf.MoveFirst
> conPubs.Execute "delete from imppersonnel;"
>
> sql = "insert into imppersonnel (SSN, COMPONENT, COOL, INTERN,
> COOPED, TUITION, STULOAN, DTPRESPOS, ACQEX, CAREERLEVEL) "
> sql = sql + "values ('" + rs_per_dbf("SSN") +
> "','a',1,'a','a','a','a','a',1,1);"
> 'MsgBox sql
> conPubs.Execute sql
>
> MsgBox "hello"
> End Sub
>
>
>
> Thanks
> Zachary Taylor
> taylorzac_at_bah.com
>
>
>
Received on Sun Oct 26 1997 - 00:00:00 CDT