Creating a Connection

To create a connection, set the Cursor Location, and then either set the ConnectionString and then call Open, or specify the connection string on the Open call.

cn.ConnectionString = "Provider=PervasiveOLEDB;Data Source=Demodata"

cn.CursorLocation = adUseServer

cn.Open

or

cn.CursorLocation = adUseServer

cn.Open "Provider=PervasiveOLEDB;Data Source=Demodata"