SQl Server error
-
- Posts: 22
- Joined: Tue Oct 10, 2017 12:44 pm
SQl Server error
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
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