Icon View Incident Report

Serious Serious
Reported By: Joni Dee Marx
Reported On: 3/3/2011
For: Version 2.05 Build 3
# 3392 ODBC Driver Can Cause Issue with Client Applications Using Fixed Buffers for Connection Strings

When I am trying to connect using a connection string my IDE is saying that a table cannot be found. It is in the Default Session of my Elevate Manager, and my table is there yet it tells me the tables is missing or has no columns, any ideas you might have would be greatly appreciated.


Comments Comments
The problem was the auto-completion of connection strings by the ODBC Driver during SQLDriverConnect() calls, which would always complete the entire connection string, even for default values. This would make the outbound connection string very large. Certain client applications like MS Access only use a fixed buffer size of around 256 bytes for outbound connection strings, and this would cause the connection string to get truncated, usually at the CATALOGNAME attribute. Truncating the CATALOGNAME attribute would cause the root catalog name to be different, so the catalog would appear empty, i.e. no tables would exist.


Resolution Resolution
Fixed Problem on 3/3/2011 in version 2.05 build 4


Products Affected Products Affected
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial

Image