DAO versus ADO access to remote database.

Hi,

    in my VB application I have been using DAO to access an Oracle database on a remote server. Any SQL statements run on the database however take approximately 40 seconds even for the most basic INSERT statement. When I changed the access control to ADO the SQL statements were executed instantaneously as expected.

    Could anyone clarify my thoughts on this matter: When using DAO, the connection to the JET database engine is established when the DAO connection is opened. However, a connection has to be established between the JET database engine and the Oracle database each time a SQL staement is executed and hence this takes ~ half a minute for each SQL statement executed.

    When using ADO, the connection to the Oracle database is made when the ADO connection is made and so any SQL statements executed happen in the expected time.

    Additionally, I have used DAO to access a database on the same machine as the client VB application and the time taken to execute SQL statements is short as expected.

Thanks for your help,
Adrian Roach. Received on Fri May 26 2000 - 00:00:00 CDT