VB Crystal Report, Crystal, SQL Server Help!

Crystal, SQL Server Help!

Author	Message
tek_ge.. #1 / 2	Crystal, SQL Server Help! We have a Visual Basic DLL that is called by an Active Server page that uses the crystal automation server to create a report. the report is based on a stored procedure that accepts 3 parameters. We have the dll/web pages installed on two web servers that are connecting to the same database server. On web server prints the Crystal Report and the other one i get the "20534 Error detected by Database DLL" i have done an odbc trace on both the web servers. In the webserver that works no "SQL_ERROR" 's are returned by the trace. In the webserver that gives us errors, the sql.log file contains a bunch of errors like: "DIAG [S1092] [Microsoft][ODBC SQL Server Driver]Invalid attribute/option identifier (0) " I believe if i can solve this error/or find out why this is happening, i can fix this. Has this happened to anyone..i am about ready to pull my hair out. I am hoping i dont have to reformat and recreate this webserver! Thanks for any help Sent via Deja.com http://www.--*.com/
Wed, 16 Jul 2003 07:17:05 GMT

Deniss Andrijevsk #2 / 2	Crystal, SQL Server Help! Before trying anything else, I would install latest data components, lets say MDAC 2.5 Yes, even if its brand name out-of-the-box system with all relevant SPs. -- Deniss Andrijevski SKRIINING Quote: > We have a Visual Basic DLL that is called by an Active Server page that > uses the crystal automation server to create a report. the report is > based on a stored procedure that accepts 3 parameters. > We have the dll/web pages installed on two web servers that are > connecting to the same database server. On web server prints the > crystal report and the other one i get the "20534 Error detected by > Database DLL" > i have done an odbc trace on both the web servers. In the webserver > that works no "SQL_ERROR" 's are returned by the trace. In the > webserver that gives us errors, the sql.log file contains a bunch of > errors like: > "DIAG [S1092] [Microsoft][ODBC SQL Server Driver]Invalid > attribute/option identifier (0) "
Sat, 19 Jul 2003 21:39:09 GMT

Page 1 of 1

[ 2 post ]