Recently I was working on a problem where the scenario was as below. There are various applications connecting to SQL Server to fetch data. But the actual data was not resident on the SQL Server rather on Oracle 10g and IBM DB2 Databases. The applications...

If you are migrating a 32 bit application from Vista x64 to Windows 7 x64 and your application relies on some information in registry. There are few things you should consider as following. In Windows 7, registry is virtualized. As a result,...

This is one of the most common errors while creating linked server to Oracle database. Today I will discuss the reason for this error and possible resolutions. Full error message: OLE DB provider "MSDAORA" for linked server "LINKED_ORA...

Recently I was trying out the SSIS connector for Teradata by Attunity in one of my sample SSIS packages. While the installation and the registration process of the components went fine I faced an issue when I tried to run a really simple SSIS Package...

Intermittent connectivity issues from a client machine when connecting to a remote database server can be often attributed to the network layer. By collecting the network traces and reviewing them we can tell why the connections failed to succeed or if...

Using the Windows Debugging tool WinDBG you can attach a live process and debug. You can set up break-points at different function calls and debug when the process hits and stops to the break-points. When you do not have the source code (which is true...