Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In with Facebook Sign In with Google Sign In with OpenID

Categories

We have migrated to a new platform! Please note that you will need to reset your password to log in (your credentials are still in-tact though). Please contact lee@programmersheaven.com if you have questions.
Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.

ado adodb.recordset on a mapped drive

Accessing a dbf through ado directly with an adodb.recordset ( with a
simple select that send a query to populate a datagrid in vb6 ) all goes well and
very fast when the dbf resides on the same computer (pc1) from where the query
is executed (es: c:database on pc1)

Instead if i run the query from another pc (pc2) of the same group of pc1 in the
network pointing to the dbf on a mapped directory ( es: w: mapped as
c:database on pc1 ) query becomes very slowly and it appears as it is downloading
the entire dbf from pc1 to pc2...

p.s. the recordset is created with

rs1.open "SELECT TOP 10
COGNOME,NOME,NATODOVE,IL,ETA,DATAVISIT,IDONEITA1,MEDIX,SPORT,SCORTANUME
FROM "
& archivio & " WHERE ( 1=1) order by DATAVISIT desc, SCORTANUME desc
", conn, adOpenForwardOnly, adLockReadOnly

and then disconnected

rs1.ActiveConnection = Nothing
conn.Close

where did i go wrong?

Thanks

Sign In or Register to comment.