OleDbConnectionobject working - ADO.NET
Q. OleDbConnectionobject works with?
1. When connecting to an Oracle database
2. When connecting to an Office Access database
3. When connecting to SQL Server 6.x or later
4. When connecting to SQL Server 2000
- Published on 31 Aug 15
a. 1, 2
b. 2, 3
c. 1, 3
ANSWER: 2, 3
OleDbConnection object is used to connect to SQL Server 6.x or later. It is also used to connect with access database.
Example of connection string.
Provider = Microsoft.ACE.OLEDB.12.0;
Data Source = C:\myFolder\myAccessFile.accdb;
Persist Security Info = False;