Library > Products > Pervasive.SQL > Pervasive.SQL > OLE DB Provider Guide > ADO/OLE DB Reference Information > Creating a Recordset Using the Location Parameter

PreviousOLE DB Provider Guide ( revision 1) Next

Creating a Recordset Using the Location Parameter

Show this topic in Library frames

As an alternative to a hard-coded path into your application, you can use the Location parameter in the connection string to connect to a remote database. 

rs.Open "Course", "Provider=PervasiveOLEDB;Data 
Source=DEMODATA;Location=MyRemoteServer", 
adOpenDynamic, adLockBatchOptimistic, adCmdTableDirect

Chapter contents
Publication contents

Prev topic: Creating a Recordset Using a Path
Next topic: Creating a Recordset Using an Existing Connection