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
Read More...
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
Read More...
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
Read More...
“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.
Read More...
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
Read More...
