Connecting to a Database
When using the OLE DB provider, a common question is how to connect to the database. This section details the basics of connecting using the OLE DB provider.
Connecting to OLE DB Provider
Connect String
“Provider=PervasiveOLEDB;Data Source=
(DBName or Path to DataFiles)”
Sample connection and open
Private Sub Form_Load()
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
'This should always be adUseServer unless you
'specifically want to use the Client Cursor Engine
cn.CursorLocation = adUseServer
cn.ConnectionString = "Provider=PervasiveOLEDB;Data Source=Demodata"
cn.Open
rs.Open "Billing", cn, adOpenDynamic, adLockOptimistic, adCmdTableDirect
rs.MoveFirst
MsgBox "The first Student ID: " & rs.Fields("Student_ID")
rs.Close
cn.Close
End Sub
Other Tasks
Other common procedures are documented in Chapter
3
,
ADO/OLE DB Reference Information
.