Page 1 of 1

SQl Server error

Posted: Wed Sep 21, 2005 6:01 am
by Carol_P_(Guest)
Hello,____Sometimes when running a report (R&R v10 RSWRun.exe on XP Pro) either from the OCX or using CreateProcess I get the following error when connecting to SQl Server (but never when connecting to Access)____Db Access: The connection, statement, or query handle you provided is not valid____It only seems to happen for reports with complex SQL statements.____Does anyone know what causes this and how to fix it?____Thanks__Carol____

=> RE: SQL Server error

Posted: Wed Sep 21, 2005 8:41 am
by kfleming
Try adding a section called DATABASE to your c:RSW.INI file and in that file add the line:__USEQECONNECT=1____and see if that helps.____Kathleen__R&R Support