ODBC

KB38: You are seeing unexplained exceptions or experiencing increased memory usage

Symptom

You are getting unexplained exceptions and experiencing increased memory usage when using Microsoft's ODBC drivers to connect to your third party database.

Cause

Microsoft's ODBC drivers leak memory over a long period of time.

Solution

When setting up your ODBC data source, use your database vendor's latest ODBC driver rather than the one provided with Windows.

KB139: Your query returns an "Unable to retrieve data" message

Symptom

When you run your query, you get the "Unable to retrieve data" message.

Cause

There are two reasons why this message would be returned:

  1. There is a problem with the syntax of your query which makes it invalid.
  2. Your ODBC connection was created using the ODBC Data Source Administrator from the Users DSN tab.

Solution

Ensure that the query is valid and has correct syntax.

To view the query text:

Subscribe to RSS - ODBC