C# ODBC Connection

An instance of the OdbcConnection Class in C# is supported the ODBC Data Provider. The OdbcConnection instance takes Connection String as argument and pass the value to the Constructor statement. When the connection is established between C# application and the Data Source the SQL Commands will execute with the help of the Connection Object and retrieve or manipulate data in the database.

connetionString = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=yourdatabasename.mdb;"; cnn = new OdbcConnection(connetionString);

Once the Database activities is over you should be closed the Connection and release the Data Source resources . The Close() method in OdbcConnection Class is used to close the Database Connection.

cnn.Close();

The Close method rolls back any pending transactions and releases the Connection from the Database connected by the ODBC Data Provider .

Full Source C#
using System; using System.Windows.Forms; using System.Data.Odbc; namespace WindowsApplication1 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { string connetionString = null; OdbcConnection cnn ; connetionString = "Driver={Microsoft Access Driver (*.mdb)};DBQ=yourdatabasename.mdb;"; cnn = new OdbcConnection(connetionString); try { cnn.Open(); MessageBox.Show ("Connection Open ! "); cnn.Close(); } catch (Exception ex) { MessageBox.Show("Can not open connection ! "); } } } }





Related Topics
  1. C# ADO.NET Connection
  2. C# SQL Server Connection
  3. C# OLEDB Connection
  4. C# ADO.NET Command
  1. C# ADO.NET SqlCommand - ExecuteNonQuery
  2. C# ADO.NET OleDbCommand - ExecuteNonQuery
  3. C# ADO.NET SqlCommand - ExecuteScalar
  4. C# ADO.NET OleDbCommand - ExecuteScalar
  5. C# ADO.NET SqlCommand - ExecuteReader
  6. C# ADO.NET OleDbCommand - ExecuteReader
  7. C# ADO.NET DataReader
  8. C# ADO.NET SqlDataReader
  9. C# ADO.NET OleDbDataReader
  10. C# Multiple Result Sets
  11. C# Table Schema from SqlDataReader
  12. C# Table Schema from OleDbDataReader
  13. C# ADO.NET DataAdapter
  14. C# ADO.NET SqlDataAdapter
  15. C# ADO.NET OleDbDataAdapter
  16. C# ExecuteReader and ExecuteNonQuery
  17. System.Data.SqlClient.SqlException: Login failed for user

Related Links
  1. Stored Procedures in C#
  2. C# Stored Procedure with Parameter