Menu
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.
422
Navigate to Start, and enter C:\Windows\System32\odbcad32.exe into the Search programs and files field. When the ODBC Administrator opens, click the Drivers tab and look for Microsoft Excel Driver or Microsoft Access Driver. If these drivers are present, this confirms the existence of 64-bit ACE components.
Right-click on the file, nzoledb. dll, and select Properties. The version number is displayed either in the Product Version field on the Details tab or under the Version tab, depending on your OS. Note: The System32 directory contains either a 32-bit driver (on a 32-bit system) or a 64-bit driver (on a 64-bit system).
Microsoft OLE DB Driver 19.2. 0 for SQL Server is the latest general availability (GA) version. The Microsoft OLE DB Driver 19 for SQL Server will install side by side with Microsoft OLE DB Driver 18 for SQL Server.
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.
141
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
