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…

13

What if your ODBC DSNs want to play "hide-and-seek" with you ?

One of our customers has been reporting that they cannot see their “System Data Sources” under “System DSN” tab when they clicked on “ODBC Data Source Administrator” Control Panel icon.  They were also trying to add a new DSN, the wizard was completing succesfully but the DSN was not appearing in the list. Strange.. Ain’t…

4

“Please take a shower before entering the connection pool” !

Sometimes pools that we should pay attention to their “hygiene” are not only swimming pools. We should also be careful about our database “connection pool”s. Here comes the story behind this “philosophical” entrance  … One of our customers was reporting an issue when they were about to put their web server farm on production.  Strangely…

1

How to set up a Kerberos Authentication Scenario with SQL Server Linked Servers

Let’s say you’ve got a SQL Server (KIRK) containing a linked server against another SQL Server (SCOTTY)  and you’re connecting the KIRK from remote client machine (SPOCK) using SQL Server Management Studio and receiving the error message below when you executed a query involving the linked server :  “Error 18456: Login failed for user ‘NT…

2