Re: MsAccess vs Oracle

[Jamie Harris <JHarris@FCC.CC.MD.US>]

It's not in the SQR itself -  it's where you run the SQR.

On my side, I go to start, programs, Peoplesoft then SQR.  A window
pops up asking me for report name, datasource, username and password.

Username and password for an Access database would usually be "Admin"
with no password unless you have specifically defined users within the
database.

At the command line, you could run the same way using the standard
command line you'd normally use, something like this:

srqw.exe DATASOURCE/ADMIN/   (and whatever command line switches you
need).

That should get you right in, though depending on how it handles the
DSN/USER/PASSWORD part it may ask for a password since none is
specified.



-----------------------------------------------------
Jamie Harris
Junior Systems Programmer/Analyst
Information Technology Division
Frederick Community College
-----------------------------------------------------

>>> allen.cunningham@SONOMA.EDU 6/17/2002 1:25:05 PM >>>
>>Then, point your SQR to that datasource and you're all set.<<

I know the ODBC setup part, but the above is the part I don't get.
Where in
the SQR do you point to Access??

ac

-----Original Message-----
From: Discussion of SQR, Brio Software's database reporting language
[mailto:SQR-USERS@list.iex.net]On Behalf Of Jamie Harris
Sent: Monday, June 17, 2002 10:02 AM
To: SQR-USERS@list.iex.net
Subject: Re: MsAccess vs Oracle


In your ODBC administrator, you create a new data source using the
Microsoft Access driver.  In the configuration for the data source is
a
place to browse to the actual location of the database (on your hard
drive or on a shared network drive).

Then, point your SQR to that datasource and you're all set. :)  That's
intent of ODBC: to make it so you can write platform independent
database reports for easy migration.

(note my previous email though about making sure the SQR doesn't
reference anything DB specific: ODBC is nice, but it's not perfect yet
:)

-----------------------------------------------------
Jamie Harris
Junior Systems Programmer/Analyst
Information Technology Division
Frederick Community College
-----------------------------------------------------

>>> allen.cunningham@SONOMA.EDU 6/17/2002 12:31:02 PM >>>
John - How does one set up an sqr to have it go against Access?? Do
you
run
from sqrw directly, or go thru a  batch file, or do you create P/S run
control panels. What do you set up to have it use Access as its
database??

Tx,

Allen Cunningham

-----Original Message-----
From: Discussion of SQR, Brio Software's database reporting language
[mailto:SQR-USERS@list.iex.net]On Behalf Of John Willson
Sent: Friday, June 14, 2002 2:13 PM
To: SQR-USERS@list.iex.net
Subject: Re: MsAccess vs Oracle


Hi Joan, there really isn't a comparison of MSAccess versus Oracle.
Some
would argue MSSQL server versus Oracle.  I use MSAccess to develop my
SQR's
and then point to Oracle.  At this point I have only gone to Ora 8 and
not
tried 9 as yet.  If you are going to MSAccess to get at the data with
VB
say, be sure to use ADO and not DAO so that you can just change your
ODBC
drivers to point from Access to Oracle.  (Access lacks a  lot of DBA
functions that can completely hang you in production systems let alone
the
NT/2000 versus Unix stuff; however, for development, testing, and
training
it has many advantages.)

John Willson

----- Original Message -----
From: "Hatcher, Joan A" <joan.hatcher@BAESYSTEMS.COM>
To: <SQR-USERS@list.iex.net>
Sent: Friday, June 14, 2002 2:17 PM
Subject: MsAccess vs Oracle


> I want to transition a Unix-based Oracle 7 database to either a
higher
> version of Oracle or to a windows based  MSAccess database.  Our
current
> report writer is SQR, and I don't want to-re-write all the reports.
>
>   1. If I went with MSAccess, am I correct in assuming that I could
use
ODBC
> to run my old SQRs ?
>   2. If I went with Oracle, what is the highest version that can be
used
> with SQR ?
>
> Thank you for your help.
>
>   Joan Hatcher
>
>
>
> ______________________________________________
> Joan A. Hatcher                       301-862-7177  (phone)
> Programmer Analyst III          301-862-7107  (fax)
>
> joan.hatcher@baesystems.com
>
>
BEGIN:VCARD
VERSION:2.1
X-GWTYPE:USER
FN:Harris, Jamie
TEL;WORK:2668
ORG:Work;Division of Information Technology
EMAIL;WORK;PREF:JHarris@fcc.cc.md.us
N:Harris;Jamie
TITLE:Systems Analyst, PeopleSoft
ADR;DOM;WORK;PARCEL;POSTAL:;L-205
LABEL;DOM;WORK;PARCEL;POSTAL;ENCODING=QUOTED-PRINTABLE:Harris, Jamie=0A=
L-205
END:VCARD