RR SQL 9 DB access error

[Peter_Zimmer_(Guest)]

I am trying to hook a report into my Delphi 5 Oracle 7 app and I^m getting the error:____DB access: The connection, statement, or query handle you provided is not valid.____If I pause the program and paste the command call from Delphi to the Windows Run prompt it runs fine. ____I can not figure out what this message is trying to tell me so I don^t know where to start trying to fix it. ____The report was originally a R&R 3 report using DBF and CDX files that I moved up to R&R xBase 8.1 then converted over to R&R SQL 9 with the report convertion utility.

[kfleming]

Try editing the file c:windows sw.ini____Add a section whose name is Database. This will be a single line with an opening bracket then Database the a closing bracket. (sorry that the forum software will not let me use actual brackets in a message.__Then below the Database line add:__UseQEConnect=1____Save this file, re-start R&R and see if it helps.____Kathleen__R&R Support

[crasaur]

Thanks for the quick response Kathleen. I tried that and it worked great!____One other question, will that have any effect on any of the other reports we have in production? We have at least a couple dozen reports in use being called from VB 4 and VB 5 from our Oracle 7 database, as well as the several dozen or so reports we have yet to move out of DBF/CDX files into Delphi/Oracle tables.____Thanks again.

[kfleming]

It should not have any negative impact on other reports.____Kathleen__R&R Support

[crasaur]

This took a while to run across because I was side tracked onto another project. ____I have now added a second report to the system and I am getting the same DB Acces error as with the first report. This seems kind of odd. The first report still works just fine since I made the entry in the .ini file. ____What can I do to correct this and prevent it from happening again.____Thanks__Peter

[kfleming]

Seems equally odd to me. What database driver are you using?__Is the problem in an existing report or a new report?____Kathleen__R&R Support

[crasaur]

This is the same scenario as the other report. It was a R&R 3 report that I moved up to R&R 8.1 xBase. Then I ran it through the R&R ver 9 SQL xBase conversion Utility. After I first got the DB access error on this report, I figured that the query on the conversion may have been too complicated for R&R, since all 6 of the joins came up as related blank, so I reworked the report to use a temporary Oracle table as an alias in a smaller 3 file join instead of the big 6 file join. But the DB access error is still occurring. ____I am actually now getting a second error on this report as well. Now when I run the report directly from the Windows Run prompt I get the error "Cannot find related table" and the table name of the aliased table. If I set the report itself to use the aliased temporary table directly and don^t put the alias into the control table, the report runs fine from the run prompt. I have checked my syntax in the alias field and it is ok, but I^m not yet sure this isn^t something I am doing wrong. I just wanted to let you know in case it may be related to the DB access problem.____I am using the Oracle7 32-bit ODBC driver (production) Ver. 2.5.3.1.7. __I am using R&R SQL ver 9.0.009 RSWRUN as a WinExec command call to run the reports. __I am using Delphi 5 Professional with Update Pack 1 build 6.18 and ADOExpress with update 2.__I am working on a Windows 2000 build 2195 service pack 2 workstation connected to a Novell network using the Netware client for NT/2000 ver 4.81.____I hope that helps.____Thanks