Icon View Incident Report

Serious Serious
Reported By: David Scheiner
Reported On: 1/11/2008
For: Version 1.07 Build 1
# 2522 Queries That Return Insensitive Result Sets Cause #600 File Manager Error With Temporary Tables Path

The following SQL query causes this error with the ElevateDB .Net Data Provider:

ElevateDB Error #600 File manager error (Cannot create file "C:\Documents and Settings\Administrator\Local Settings\Temp\"\SVR01605210Tutorial1.EDBTbl (OS Error: Warning: A StringBuilder buffer has been overflowed by unmanaged code. The process may become unstable. Insufficient capacity allocated to the StringBuilder before marshaling it.))

Select Text from Guids



Comments Comments
The issue was a cascading failure that was originally caused by the fact that the base DbConnectionStringBuilder object in .Net escapes (with double-quotes) any connection string settings with spaces in them. This caused the creation of any temporary tables to fail due to the invalid temporary tables path with the embedded double-quotes. This in turn exposed a bug in the EDB .Net Data Provider where the calls to retrieve the system error message weren't setting the proper StringBuilder length prior to passing it to the call.


Resolution Resolution
Fixed Problem on 1/12/2008 in version 1.07 build 2


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