Tag: oledb
Access Database Engine 2010 Service Pack 1 released
If you’ve read my previous blog post “Accessing Excel files on a x64 machine” and you loved our ACE OLEDB Provider, I want to let you know that we released “Access Database Engine 2010 Service Pack 1“. This update is also available in Windows Update. That means if you’ve already installed Access Database Engine 2010 and […]
Read More → Access Database Engine 2010 Service Pack 1 releasedAccessing Excel files on a x64 machine
In the old times while all the CPUs were 32bit, we were happily using JET OLEDB Provider reaching Excel or MDB files for long time without any issues. After we started using x64 CPUs and x64 Windows machines, we noticed that JET OLEDB Provider is not working. The reason for this was x64 Windows operating […]
Read More → Accessing Excel files on a x64 machineThe points that you should think again and again using JET Database Engine in a multi-threaded application (like a classic ASP or ASP.Net web application)
Microsoft JET (Joint Engine Techonology) Database Engine is an implementation of JET Red and it should not be mixed with the JET Blue ESE (Extensible Storage Engine) which is the core of Microsoft Exchange and Active Directory. We had released the first versions of the JET OLE DB Provider and JET ODBC Drivers in […]
Read More → The points that you should think again and again using JET Database Engine in a multi-threaded application (like a classic ASP or ASP.Net web application)“UDL Test” on a 64 bit machine
“UDL Test” on a 64 bit machine Let’s say you’ve started playing with UDL files on your “32 bit” machine and this tiny little UDL files helped you to identify connectivity issues or you’ve easily obtained the OLE DB connection strings for your applications. So far so good. But one day, you followed the same procedure […]
Read More → “UDL Test” on a 64 bit machineBasics first : “UDL Test”
When an application failed with a database/datasource connectivity problem, the first thing to check is if the box really cannot connect to the database/datasource using a “generic” way. The simplest technique is “UDL Test” using the OLE DB providers installed on the box . For example, if the application is failing to connect to a SQL […]
Read More → Basics first : “UDL Test”