CODEWITHSUNDEEP
c#exceloledb
Thanushka
Thanushka

Reputation: 1445

C#.Net, Get the OLEDB provider version

I need to Identify the Installed OLEDB provider version. before reading an Excel file. How can I do that?

Upvotes: 4

Views: 15769

Answers (2)

Carlos Quintanilla
Carlos Quintanilla

Reputation: 13313

Have a look in the registry and see if the Jet OLE DB provider is there

The Path is: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines

Then you will have

Jet 4.0 Engines Jet 2.0 Jet 3.0 Jet 4.0

Upvotes: 1

cgon
cgon

Reputation: 1981

You can use the OleDbEnumerator.GetElements Method . http://msdn.microsoft.com/en-us/library/system.data.oledb.oledbenumerator.getelements.aspx to enumarate the drivers. You ask the versions of them maybe this link helps: http://dotnetref.blogspot.com/2009/04/getting-version-of-oledb-provider.html

Upvotes: 9

Related Questions