Icon View Incident Report

Serious Serious
Reported By: Garry Harris
Reported On: 10/23/2007
For: Version 1.05 Build 2
# 2466 Unicode ODBC Driver Not Working Properly

I tried connecting the application I built the database for and hit the test connection button to see if it could connect to ElevateDB and got this error:

Unable to Connect: [Elevate Software][ElevateDB] Access Violation at....

I closed the dialog and hit the test button again, and got this error:

Unable to Connect: Catastrophic failure

I tried connecting to the ElevateDB using PowerBuilder. I got absolutely no errors, but PowerBuilder would just crash and burn. I would restart it, try it again, and got the same results. Here is what I got from PowerBuilder when trying to connect to it:

Sybase PowerBuilder 10.5 has encountered a problem and needs to close.

I tried connecting to it with MS Access, and it would not connect. It just did nothing when I selected the EDB DSN I set up in the ODBC Administrator. I guess the good thing is it didn't crash or give any errors.

During this whole time I had ODBC tracing turned on in the ODBC Administrator and also in PowerBuilder. It did not create an ODBC Trace Log at all. And the PowerBuilder Log was worthless. Here is what was in the PowerBuilder Log:

/* 10/23/2007 16:33 */
(2dd0008): DBPARM=ConnectString='DSN=CA_EDB;UID=Administrator;PWD=EDBDefault'(DBI_DIALOG_CONNECT)

Comments Comments
There were several issues involved here. The most prominent was incorrect buffer length calculations in the ODBC Driver for the Unicode (WideString) versions of the ODBC API calls. The rest of the issues were minor incompatibilities with PowerBuilder with respect to fetching. For example, PowerBuilder didn't like a fetch returning a status of SQL_SUCCESS_WITH_INFO and would treat it like an error instead.

Resolution Resolution
Fixed Problem on 10/25/2007 in version 1.06 build 1

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