Bug #29888 Crystal wizard throws error on including tables
Submitted: 19 Jul 2007 3:15 Modified: 26 Jul 2007 16:28
Reporter: Jared Sullivan (Silver Quality Contributor)
Status: Closed
Category:Connector/ODBC Severity:S1 (Critical)
Version:3.51.17 OS:Microsoft Windows (Vista)
Assigned to: Jim Winstead Target Version:
Tags: SQLColumns, crystal, Connection, wizard

[19 Jul 2007 3:15] Jared Sullivan 
Description:
Hi,

Having few issues creating new reports in CRXI.  Major SQL syntax issue!

How to repeat:
1. Create new ODBC connection to any DB
2. Create new report for that DB and use connection wizard
[19 Jul 2007 3:16] Jared Sullivan 
ErrMsgBox

Attachment: CrystalErr.jpg (image/pjpeg, text), 21.90 KiB.
[19 Jul 2007 3:17] Jared Sullivan 
See HY000 error

Attachment: SQL.LOG (application/octet-stream, text), 72.99 KiB.
[19 Jul 2007 22:14] Jim Winstead 
Fix problems with SQLColumns() when catalog is specified

Attachment: bug29888.patch (text/plain), 2.31 KiB.
[24 Jul 2007 0:55] Jared Sullivan 
Hi Jim, did you have time to 'preview' simple crystal report, as alot of crystal bugs are
slipping through current releases.
[25 Jul 2007 21:45] Matt Ashley 
Jim, I looked at your patch for this issue but don't know how to apply it. Don't know much
about compiling source code. Do you know which release of the odbc driver this will be
released in and when it is do out?
[25 Jul 2007 22:50] Jim Winstead 
The fix for this bug has been committed, and will be included in 3.51.18.
[26 Jul 2007 0:39] Matt Ashley 
Thanks Jim. Do you know a time frame when 3.51.18 will be released?
[26 Jul 2007 16:28] MC Brown 
A note has been added to the 3.51.18 changelog: 

Getting table metadata (through the SQLColumns() would fail, returning a bad table
definition to calling applications.