HI,
I use vb6 to access database. I can select between "local" data base
and "remote" data base. Both connection calls the same Access 2000
Mdb.
The Mdb contains local tables (on the hard disk) and remote links to
Oracle tables via odbc link.
The local connection (to the recordset) is fast, but the "remote"
connection takes around 7 minuits.
NOTE: Connecting to the "remote" tables, manually via Access2000, is
fast!!
I'm desperate to find a solution to that problem. Any idia will be
appriciated.
Rafi
The program:
'-------Connection---------
Set dbsConn = New ADODB.Connection
dbsConn.CursorLocation = adUseClient
dbsConn.ConnectionString =
"Provider=Microsoft.Jet.OLEDB.4.0;PersisSecuri ty
Info=False;Data Source= " & MdbPath
'MdbPath=location of Access 2000 DB
dbsConn.Open
'---------Record Set -----------------
Set dbsRSCard = New ADODB.Recordset
DoEvents
Set dbsRSTest = New ADODB.Recordset
DoEvents
dbsRSCard.Open tblCard, dbsConn, adOpenDynamic, adLockOptimistic
'rafi
DoEvents
dbsRSTest.Open tblTest, dbsConn, adOpenDynamic, adLockOptimistic
'rafi
'Local - tblCard, tblTest are local Access tables
'Remote - tblCard, tblTest are remote links to Oracle tables via
odbc