ODBC drivers not visible in the ODBC Data Source Administrator (odbcad32.exe)

I recently had an issue where after the installation of a Third party Client side tools, we were not able view the drivers listed in the ODBC Data Source Administrator (odbcad32.exe). In order to create a DSN to use this third party driver, we had to take a backup/export of the registry key of an…

9

Java two tier applications will show connection leak symptoms with Microsoft SQL JDBC driver when running outside of a Web Server or Web Container

Java two tier applications running outside a java web server or java web container using SQL Server as the database may show symptoms of connection leak . This applies to new applications as well as the ones migrated from Oracle/DB2 or other databases. If the command netstat –anob is run from command prompt there will…

0

Who takes care of my database connection when I don’t close it in my code?

A lot of customer has asked me a common question : How should I expect my connections to  behave if I don’t close it properly in the code. Though it is highly recommended to close the connection in your code itself and not depend on any other ways to close it, I think there should…

3

How to log ODBC DSN changes

There is often a challenge to determine the last user who changed the ODBC DSN and when these changes were made. It is even more challenging in the environment where multiple users have remote access to the machine. In many cases unauthorized changes could cause a system malfunction or even a crash. In most cases…

0