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 […]
Read More → Why my 32 bit applications cannot see the ODBC DSNs that I created on my 64 bit machine ?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 […]
Read More → What if your ODBC DSNs want to play “hide-and-seek” with you ?“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 […]
Read More → “Please take a shower before entering the connection pool” !Moving a Visual Studio 2005 project containing ADOX references from XP to Vista may fail with ADOX references
If you had developed a VS 2005 project containing ADOX references on a Win XP machine and moved the project to a Vista machine, VS 2005 may not access to ADOX reference. Then you’ll need to use the “tlbimp.exe” (Type Library Importer) tool which is shipped with Visual Studio 2005 (full path is “\Microsoft […]
Read More → Moving a Visual Studio 2005 project containing ADOX references from XP to Vista may fail with ADOX referencesHow 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 […]
Read More → How to set up a Kerberos Authentication Scenario with SQL Server Linked Servers“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”