Re: MsAccess vs Oracle

[Allen Cunningham <allen.cunningham@SONOMA.EDU>]

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
>
>