Configuring the OLE DB Data Source
Before an application program can communicate with the data source, configuration information must be provided. The data source configuration comprises accessible data and its associated operating system. Use the following provider string to configure the OLE DB data source:
"Provider=CONNXOLEDB;Persist Security Info=True;prompt=NoPrompt;User ID=theuser;Password=thepass;Data Source=C:\connx32\utils\CONNX.cdd;Mode=ReadWrite"
To create an OLE DB Provider connection object
Use Visual Basic, C#, or another OLE DB-compliant resource to create a connection object. The following code exemplifies creating a connection in Visual Basic:
Dim cnn As New ADODB.Connection
Dim rs As New ADODB.Recordset
cnn.Open "Provider=CONNXOLEDB;Persist Security Info=True;prompt=NoPrompt;User ID=theuser;Password=thepass;Data Source=C:\connx32\utils\CONNX.cdd;Mode=ReadWrite"
SQL = "SELECT orderid, customerid, productid, orderdate, productquantity FROM orders_rms"
rs.Open SQL, cnn
or in .NET:
Dim cnn As OleDbConnection
Dim cmd As OleDbCommand
Dim sqlda As OleDbDataAdapter
Dim sqlds As DataSet
cnn = New OleDbConnection("Provider=CONNXOLEDB;Persist Security Info=True;prompt=NoPrompt;User ID=theuser;Password=thepass;Data Source=C:\connx32\utils\CONNX.cdd;Mode=ReadWrite")
SQL = "SELECT orderid, customerid, productid, orderdate, productquantity FROM orders_rms"
cmd = New OleDbCommand(SQL, cnn)
sqlda = New OleDbDataAdapter(cmd)
sqlds = New DataSet
sqlda.Fill(sqlds)