I am developing an application using VB6 with Oracle8 as the database. I'm using the ADO data control, which is bound to form controls, to connect to the database and retrieve data. The problem I'm experiencing is that when I set the recordsource and call the refresh method, there is a 3 - 5 second delay. When I tested the same call to an Access database, the refresh method was fine. Why is it so slow for Oracle? Is there any way to speed this up??? Is there a different call I can make. I tried the following:
set cn = new ADODB.Connection
cn.Open [MyConnectionString]
ADODBControl.Recordset.Open [tablename], cn, adOpenDynamic

However, I keep getting error 91 (object variable not set) when it tries to execute the Open method on the recordset. Then I tried initializing the data control's recordset by:
Set ADODBControl.Recordset = New ADODB.Recordset

but that line causes an error as well. What do I do?