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: