Creating Connections to ODBC Data Sources
' Visual Basic
Public Sub ConnectToOdbc()
Dim conn As New System.Data.Odbc.OdbcConnection
' TODO: Modify the connection string and include any
' additional required properties for your database.
conn.ConnectionString = & _
"FIL=MS Access;DSN=valid data source name"
Try
conn.Open()
' Insert code to process data.
Catch ex As Exception
MessageBox.Show("Failed to connect to data source")
Finally
conn.Close()
End Try
End Sub
// C#
public void ConnectToData()
{
System.Data.Odbc.OdbcConnection conn =
new System.Data.Odbc.OdbcConnection ();
// TODO: Modify the connection string and include any
// additional required properties for your database.
conn.ConnectionString = "FIL=MS Access;DSN=valid data source name";
try
{
conn.Open();
// Process data here.
}
catch (Exception ex)
{
MessageBox.Show("Failed to connect to data source");
}
finally
{
conn.Close();
}
}
0 comments:
Subscribe to:
Post Comments (Atom)