I'm using Crystal reports 8.0 with VB 6.0 and SQL Server 2000..I am getting the error "Error detected by database DLL" We were using SQL server 7.0 earlier and have recently upgraded to SQL 2000.The error appeared after this upgradation.Could anyone please help me with this.I've found some threads related to this error but none of them could solve my problem..Any help would be highly appreciated.
I have seen this when trying to set the SQL Query of the Crystal object through code. This has to do with aliasing a table in a left outer join (not sure why - but it consistent across mutiple developer PCs on a VB6 IDE with Crystal 8 and Oracle DB). The SQL code runs fine in TOAD and SQL Plus, and also runs fine in Crystal but when embedded in VB as a string and passed in as part of the Crystal object's SQLQuery property it fails. The only way I have been able to get around this is to remove the alias (and if that is not possible - insert the SQL in Crystal and build with parameters). If anyone knows another work around, let us know!
I also tried putting Chr(34) around the alias names in the join and this did not work.