[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
RE: [sqr-users] SQR 4.1 and Windows 2000
- Subject: RE: [sqr-users] SQR 4.1 and Windows 2000
- From: Gene.R.Billings@jci.com
- Date: Mon, 11 Nov 2002 10:18:12 -0500
- List-id: This list is for discussion about the SQR database reporting language from Brio Software. <sqr-users.sqrug.org>
We use Win2K against Oracle databases 7.3 or better. (I use an 8.1.7 Oracle
client with SQR 4.3.4 and SQR 5)
#1 & #2 is correct. No Oracle DLL entry is needed but a full path to the
EXEs is required in the SQR.INI file as stated by Dave. SQR 4 does not
recogize long file names but you don't have to reference a specific DLL
You shouldn't have to reference anything in Oracle at all in the SQR.INI
file. For us, the Common and Oracle Environment SQR_PATH setting should
match exactly.
Below is the first few lines of my SQR.INI file.
[Default-Settings]
Locale=SYSTEM
Default-Numeric=V30
output-file-mode=long
OutputTwoDigitYearWarningMsg=TRUE
[Environment:Common]
;SQRDIR=u:\SQR5
SQRDIR=C:\SQR434\SQRServer\ORA\BINW
SQRFLAGS=-KEEP -XCB
SQRW_SPOOL=C:\SPL
[Environment:Sybase]
SQRDIR={Location of SQR}
[Environment:Oracle]
;SQRDIR=u:\SQR5
SQRDIR=C:\SQR434\SQRServer\ORA\BINW
SQRFLAGS=-KEEP -XCB
SQRW_SPOOL=C:\SPL
SQR_DB_DATE_FORMAT='DD-MON-YYYY'
[Environment:ODBC]
SQRDIR={Location of SQR}
Hope this helps,
Raemil Billings
====================================
Raemil Billings
Systems Engineer
Johnson Controls
321-784-7796
KnappR@umsystem.
edu To: sqr-users@sqrug.org
Sent by: cc:
sqr-users-admin@ Subject: RE: [sqr-users] SQR 4.1
and Windows 2000
sqrug.org
11/11/2002 09:21
AM
Please respond
to sqr-users
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
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users