RE: [sqr-users] SQR 4.1 and Windows 2000

["Knapp, Richard" <KnappR@umsystem.edu>]

SRQ 4.x does work with an Oracle8 client so you can cross that one off the 
list.  I vote for Dave's first choice.

Richard Knapp
Database Programmer/Analyst
Institutional Research and Planning
University of Missouri System
573-882-8856
knappr@umsystem.edu


-----Original Message-----
From: David Donnelly [mailto:Dave@isisbio.com]
Sent: Saturday, November 09, 2002 3:09 PM
To: sqr-users@sqrug.org
Subject: Re: [sqr-users] SQR 4.1 and Windows 2000


Keith,

Welcome to DLL hell.  You may have some trouble getting SQR 4 to work with 
Oracle8 on win2k.

In order of increasing annoyance, here are the things I can think of that 
may be the problem.

1. I wonder why the message says "specify the filename in your SQR.INI" and 
not "hey, I don't like the file you specified in your SQR.INI"... makes me 
think your SQR.INI is not being found. On my Win2000 system, it's in 
\WINNT.  I have SQR v6 loaded, and I don't have an ORACLE_DLL entry, just

[Environment:Common]
SQRDIR=D:\Program Files\Brio\BrioReportViewer\BINW
[Environment:Oracle]
SQRDIR=D:\Program Files\Brio\PersonalSQR\ORA\BINW

which also made me think that your odd SQRDIR entry might be to blame too. 
Try making it specify the actual binw directory.

2. SQR 4 may not recognize filenames longer than the 8.3 format.  You could 
try changing that entry to C:\PROGRA~1\Oracle\Ora81\bin\oracli~1.dll which 
should be the equivalent.

3. Even so, SQR4 may not work with an Oracle8 client. If not, you might try 
copying orant71.dll from the old machine to the new bin directory and 
changing the ORACLE_DLL entry to match it.


Good luck, and let us know how it comes out.
Dave


At 09:21 AM 11/9/2002, you wrote:
>We are using SQR version 4.1 in an application that I support.  It works
>fine in the application but when I reinstalled the viewer and workbench on
>my Windows 2000 machine (we had been using WIN95 without this problem) I
>now get the following error message when I try to run a report:
>
>(SQR 5543) Specify the Oracle DLL name in the SQR.INI file in (Environment
>Oracle] section for ORAVLE_DLL entry such as
>
>ORACLE_DLL =orant71.dll
>
>The contents of the sqr.ini file (currently in my C:\SQR\Viewer directory
>is:
>; This is a dummy SQR.INI only to make sqrw32.exe happy.
>
>[Environment:Common]
>SQRDIR=.\
>[Environment:Oracle]
>ORACLE_DLL=C:\PROGRA~1\Oracle\Ora81\bin\oraclient8.dll
>
>I modified the last line as on my WIN95 machine it was set to orant71.dll.
>
>I have searched the web and the oraclient8.dll SHOULD be the equivalent
>file but I also tried loading orant71.dll and changing the ini file.  I
>have actually tried just about everything I can think of and nothing has
>worked so far.
>
>Any suggestions will be appreciated.
>
>
>Keith E. Glading
>Pharmaceutical Product Development
>CTMD
>Application Support
>(317) 651-1502
>
>_______________________________________________
>sqr-users mailing list
>sqr-users@sqrug.org
>http://www.sqrug.org/mailman/listinfo/sqr-users


Dave Donnelly           <dave@isisbio.com>
ISIS BioComp            phone (909) 677-2446      fax (781) 207-5533

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users