Re: ODBC: oracle8 on nt and ms-access on w95

I cannot give you any advice specifically relating to Oracle 8, but we have used Access via ODBC to Oracle 7, almost exclusively for ad hoc reporting. We use Oracle Objects for OLE (oo4o) for interactive data-entry forms because oo4o exposes Oracle-native server-side functionality.

From time to time there has been a bug in the ODBC drivers supplied by Oracle that causes Access to be unable to remember the password to a linked table. We have had much better success with the Intersolv ODBC drivers for Oracle.

As an aside to Oracle Corp: we would be able to make far less use of MS-Access if Oracle had a truly competitive pricing model on its productivity tools such as Oracle Query and Oracle Reports. The developer-seat pricing all but eliminates use of Oracle productivity tools, on the departmental desktop, for the creation of ad hoc queries and reports. Although Oracle prices the database itself competitively, with its Workgroup pricing scheme, the tools division (is there such a division?) has not followed suit, and in our experience it has been Microsoft and ODBC on the desktop for ad hoc user-created reports, in spite of the monstrous bandwidth inefficiency of client-side joins. (Most users don't know how to write a SQL statement, so the Access "passthrough" option, which would eliminate the bandwidth issue, is a rarely-used because out-of-reach option.) Microsoft productivity tools are not only easy to use. They are priced to sell.

Tim Romano

karsten reincke wrote:

> hello;
>
> we need a little help for connecting a win95- and a nt-machine:
>
> (1) is it possible to use oracle8 on the nt-machine as database-server
> (all tables and tablespaces shall lying on this machine) and ms-access
> as database-client running on a win95-machine and asking and working
> with the query-results of the data-abse-server?
>
> (2) is it really possible to use ODBC and if what shall we install on
> which machine to organise the odbc-net-access?
>
> we are very sorry, but we are knowing the ODBC-FAQ of oracle, which is
> still a little mystery for us.
>
> any help is welcome, even it's "only" link.
>
>
> salut d'Allemagne kr
> -----------------------------------
> les chats cont les vrais hédonistes
> et devraient être donc notre idéal.
> -----------------------------------
> karsten reincke [ 0541/9696223 ]
> kreincke_at_cl-ki.uni-osnabrueck.de
Received on Tue Jun 08 1999 - 10:10:51 CDT