HELP: Data Access Objects w/ ODBC connected to Oracle Database 
Author Message
 HELP: Data Access Objects w/ ODBC connected to Oracle Database

I am writing an application in VB4-ProEdition-16bit that will access and
Oracle DBMS (running on a Sun) using ODBC and the VB Data Access Objects.  I
am new to programming with DAO's and have come across a problem that I cannot
find a solution to.  

Speed is a major consideration in this project.  Using SQL Passthrough, I can
connect to the ODBC data source and retrieve a reasonable amount of records
(read only) with no problems.
I am using a snapshot dynaset to this.  On our LAN (relatively traffic free),
it takes about 12 seconds to initially connect, and about .5-1 seconds to
perform the SQL query to retrieve records.

However, since the recordset returned is read only, I am unable to add/update
records in the table.  It appears, that to do this I must do one of two
things.

1) Not use SQL PassThrough.  This causes the Jet engine to do the Queries on
the database.  I end up with an access time of 17-20 seconds!!!

2) Use the QueryDef Object.  I would love to use this method, but I can't seem
to get it to work.  It always returns an error code saying Feature Not
Available.  

Any help/suggestions on this would be appreciated.

Thank you very much,
  Matthew Appler



Mon, 31 Aug 1998 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. HELP: Data Access Objects w/ ODBC connected to Oracle Database

2. How to connect VB witout usin ODBC to Oracle databases

3. Connecting to an oracle database with dao and odbc

4. Use ODBC API connect Oracle Database

5. how to connect ORACLE database through ODBC?

6. Problem connecting to Oracle Database using ODBC

7. How to use ADO Data Control to connect ot Oracle 8 Database

8. How do I get data from an Oracle database via DAO/ODBC on excel7

9. Pass Data VB>SQL>ODBC>Oracle Database

10. How to connect to an Oracle database using Access

11. Oracle+ODBC+VB4: Cannot access objects from other users

12. Connecting to an Access 95 database via an ODBC driver in VB 5.0

 

 
Powered by phpBB® Forum Software