DB2
database is most useful RDBMS developed by IBM. Basically it is not
easy to remember different database connection strings in Ado.Net. In
Ado.net to make connection to DB2 we have multiple options. We have
different connection string to connect to the DB2 database. So I am
sharing some connection strings to connect to the DB2 database using
different drivers.
Using ODBC
// ODBC without DSN
using System.Data.Odbc;
OdbcConnection conn = new OdbcConnection();
conn.ConnectionString = "Driver={IBM DB2 ODBC DRIVER};DataBase=DataBaseName;.
Showing posts with label ado.net. Show all posts
Showing posts with label ado.net. Show all posts
MySql Connection Strings in Ado.Net
Today,
MySql is open source database in the world. In Ado.net to make
connection to MySql , we have different connection strings. Basically it
is not easy to remember different database connection strings in
Ado.Net. So I am sharing some connection strings to connect to the MySql
database using different drivers.
Using ODBC
// ODBC -- MyODBC Driver -- remote database
using System.Data.Odbc;
OdbcConnection conn = new OdbcConnection();
conn.ConnectionString = "Driver={MySql}; Server=db.domain.com; Option=131072;.
Oracle Connection Strings in Ado.Net
Oracle
is most used database in the world. In Ado.net to make connection to
Oracle we have multiple options. For this purpose we have different
connection string to connect to the Oracle. Basically it is not easy to
remember different database connection strings in Ado.Net. So I am
sharing some connection strings to connect to the Oracle database using
different drivers.
Using ODBC
// ODBC -- New Microsoft Driver
using System.Data.Odbc;
OdbcConnection conn = new OdbcConnection();
conn.ConnectionString = "Driver={Microsoft.
Microsoft Access Connection Strings
In Ado.net we have multiple options to connect to Microsoft Access database. For this purpose we have different connection string to connect to the Microsoft Access database. Basically it is not easy to remember different database connection strings in Ado.Net. So I am sharing some connection strings to connect to the Microsoft Access database using different drivers.
Using ODBC
// ODBC -- Standard Security
using System.Data.Odbc;
OdbcConnection conn = new OdbcConnection();
conn.ConnectionString = "Driver={Microsoft.
Microsoft SQL Server Connection Strings
Sql Server database is more compatible database with Ado.Net. Since Sql Server and Ado.Net, both are the product of Microsoft. Basically it is not easy to remember different database connection strings in Ado.Net. In Ado.net to make connection to Sql Server we have multiple options. We have different connection string to connect to the Sql Server database. So I am sharing some connection strings to connect to the Sql Server database using different drivers.
Using ODBC
// ODBC -- Standard Connection
using System.Data.Odbc;
OdbcConnection.
Introduction to Ado.net
Before Ado.net we use Ado (Active Database Object) to access data from database. Basically Ado has automatic driver detection technique and it has only one drawback that it only provide a connected environment so efficiency of system may decrease.
ADO.NET is a new database technology used by .Net platform (introduced in 2002). Infact it is a set of classes used to communicate between an application front end and a database.It supports both connected & disconnection mode of data access.
Mandatory Namespaces used in.
