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)