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
d. 4

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;

Post your comment / Share knowledge

Enter the code shown above:
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)