Re: ODBC - Oracle --> Access

"Miles Thomas" <thomasm@"at".logica."dot".com> writes:

>Christoph Geisse <Ch.Geisse_at_kfa-juelich.de> wrote in article
><5l91as$t2k_at_zam201.zam.kfa-juelich.de>...
>> In article <334fa08b.5699976_at_news.univie.ac.at>,
>> John_Steven.Remus_at_akh-wien.ac.at says...
>> >
>> >I got a question about the connection via ODBC from Oracle to Access.
>> >In the other way(Access 7.0 --> Oracle 7.3 both on NT4.0) there was no
>> >problem. Installed ODBC Driver for Oracle73 and connected to Oracle
>> >from Access.
>> >But how can I connect to Access from Oracle?
 [...]
>> >Is it possible at all?
>> >I have found nothing in the Documentations about this.
 [...]
>>
>I don't think that it is possible. Although Oracle do have gateways to
>other databases, they are all bid databases like DB/2, IMS etc. And ODBC
>is sort of a one-way protocol
>(PC-->big_database_server).

From "Oracle Networking" by Hugh Toledo, Jr:

	Typically, ODBC is used where non-Oracle applications need to
	communicate with Oracle7 databases.  However, there is also the need
	for Oracle applications, such as those in Developer/2000 and
	Discoverer/2000, to access non-Oracle7 data sources.  In such cases,
	the Open Client Adapter for ODBC is used.
	[...]
	Oracle Open Client Adapter for ODBC supports the following non-Oracle7
	data sources:
	o	Microsoft SQL Server
	o	Microsoft Access
	o	RDB
	o	Sybase SQL Server and System 10
	o	Tandem NonStop ODBC Server
	o	Informix Online

>Think about it--how would Oracle correctly maintain transactional integrity
>in such an environment (Access can't handle multi-sql-statement
>transactions where all succeed or all rollback.)

From the same source (actually, the line represented by [...] in the above quotation):

	Of course, functionality may be limited because not all Oracle7
	features are available from the foreign data source through ODBC.

>Miles Thomas
>Logica UK Ltd
>thomasm "at" logica "dot" com

Hope this helps -- Reino

--
Reino R. A. de Boer
I & A, Faculty of Economics, Erasmus University Rotterdam
email: rdeboer_at_few.eur.nl
Let's provide the best service we can --- not because we have to,
but because we want to (after Scott Robert Ladd 1989).
-- 
Reino R. A. de Boer
I & A, Faculty of Economics, Erasmus University Rotterdam
email: deboer_at_facb.few.eur.nl
Let's provide the best service we can --- not because we have to,