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)

  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…

0

Why my 32 bit applications cannot see the ODBC DSNs that I created on my 64 bit machine ?

As we all database developers know that a ODBC DSN is an entry that we created through “ODBC Data Source Administrator” that we reached from Start/Control Panel/AdministrativeTools  or typing “odbcad32” from Start/Run . On a 64bit machine when you run “ODBC Data Source Administrator” and created an ODBC DSN, actually you are creating an ODBC…

18

“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…

8

Basics 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…

6