Re: Accessing oracle database from Visual Basic

In addition I believe there may be a migration assistant to Oracle 7.3 there's one for 8. I agree with the RDO statement. From my experience with VB and Delphi you with have less problems with Delphi.

-- 
Patrick Lanphier

email: P-Lanphier_at_psu.edu                 Applied Research Laboratory
phone: (814) 861-6723                     Pennsylvania State University

exe wrote:


> 

> > 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?

> 

> There are two better ways,

> 

> 1.    If you stay with Access97 or go to Visual Basic use RDO

> 2.    Drop those cheap Microsoft tools that are designed to not work well with

> any

>         product not made by Microsoft and get something robust like:

> 

>         Designer/2000

>         Developer/2000

>         PowerBuilder

>         Delphi 3

>         Crystal Reports

>         Paradox for Windows 8

>         or anyone of a large number of better quality tools.

> 

> And remember that ODBC access to any database is no longer secure as the new

> ODBC manager allows anyone to capture user ids and passwords.

> 

> Regards,

> 

> Daniel A. Morgan