OLE-DB vs ODBC

OLE-DB is the latest technology in the field of object linking to the application. Here linking is done between back-end and front-end application.

1. DBconnection String
http://www.dbconnectionstrings.org

2. What is DB Connection String?
DB Connection String is a special type of string
which provide the information about the data source
i.e. database and the means which is going to
connect with it. The connecting means can be any
front-end application written in any computer
language and the database source is known as
back-end application. The establiched connection
between both the application managed by underlying
driver. This driver works as bridge between the
applications and the data sharing and trasaction
continues through out the process. The DB
Connection string is based on SQL(Structured Query
Language).

3. SQL Server DB Connection String
SQL ODBC connection strings
Standard Security:
"Driver={SQLServer};Server=Server=DBName;Uid=
User;Pwd=Password;"
Trusted connection:
"Driver={SQLServer};Server=Server;Database=DBN
ame;Trusted_Connection=yes;"

4. SQL Server DB Connection String
SQL OleDbConnection .NET strings
Standard Security:
"Provider=SQLOLEDB;Data Source=Server;Initial
Catalog=DBName;UserId=User;Password=Passwo
rd;"
Trusted connection:
"Provider=SQLOLEDB;Data Source=Server;Initial
Catalog=DBName;Integrated Security=SSPI;"

5. Oracle DB Connection String
Data Source
hr = CoCreateInstance(CLSID_OraOLEDB, NULL,
CLSCTX_INPROC_SERVER,
IID_IDBInitialize,
(void**)&pIDBInitialize);
Connecting to an Oracle Database
"Provider=OraOLEDB.Oracle;User
ID=user;Password=pwd;Data Source=constr;"

6. Oracle DB Connection String
Password Expiration(Connect using connectionstring)
Dim con As New ADODB.Connection
con.ConnectionString =
"Provider=OraOLEDB.Oracle;Data
Source=MyOraDb;" & _
"User ID=scott;Password=tiger;"
con.Open

7. MySQL DB Connection String
Open connection to local MySQL database
using MySQL ODBC 3.51 Driver
"Provider=MSDASQL; DRIVER={MySQL
ODBC 3.51Driver}; SERVER= localhost;
DATABASE=DBName; UID=User;
PASSWORD=Password; OPTION=3"

8. Common Errors to DB
Connection String
Common Errors of Oracle:
ORA-03113: TNS:end-of-file on communication
channel
ORA-12154: TNS:could not resolve service name
ORA-03121: no interface driver connection -
function not performed
ORA-12170: TNS:Connect timeout occurred

9. Thank You
Please Visit
http://www.dbconnectionstrings.org