How to determine if ACE or JET on windows machine using .net?

c# .net jet
willem picture willem · Mar 16, 2011 · Viewed 9.8k times · Source

How to determine (for a machine running windows xp/vista/7) whether ACE or JET is installed, so I can use an appropiate connection string to connect to a access database.

Answer

Please treat your mods well. picture Please treat your mods well. · Mar 16, 2011

There is a registry key you can check. It is at HKCR\Microsoft.ACE.OLEDB.12.0. You can read it using the RegistryKey class.

Related questions

Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine

I created a windows application developed in .NET 3.5 in a 32 bit Windows 2008 server. When deployed the application in a 64 bit server it shows the error "Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine ". So as a …

Read More
Reading Comma Delimited Text File to C# DataTable, columns get truncated to 255 characters

We are importing from CSV to SQL. To do so, we are reading the CSV file and writing to a temporary .txt file using a schema.ini. (I'm not sure yet exactly why are are writing to this temporary file, …

Read More
How can I get a list of tables in an Access (Jet) database?

I need to see if a table exists in an Access database used by my c# program. Is know there are SQL commands for other databases that will return a list of tables. Is there such a command for Access/…

Read More