Re: Database links

Hi,

You can certainly use Oracle's Open Connectivity to connect to the Access database and perform select, inserts, updates, etc. against its tables. I discovered recently that connections to remote databases can not be used from within stored procedures and triggers.

I opened a TAR (Technical Assistance Report) with Oracle and this is what they had to say in regards to this issue, quoting a piece of their documentation:

  Oracle8i Distributed Database Systems   Release 2 (8.1.6)
  Part Number A76960-01

  Generic Connectivity Restrictions
  Following are some restrictions for generic   connectivity:

  A table including a BLOB column must have a separate   column that serves as a primary key.

  BLOB/CLOB data cannot be read through passthrough   queries.

  Updates or deletes that include functions within a   WHERE clause are not allowed.

  Stored procedures are not supported.

  Generic connectivity agents cannot participate in   distributed transactions--they support single-site   transactions only.   

Regards,
James Chin

On Thu, 29 May 2003 08:55:12 -0500, TurkBear <john.greco_at_dot.state.mn.us> wrote:

>
>Stop cross-posting ( and that includes replies as well):
>You do not need D2K ( I assume Designer/Developer 2000 ?) - any recent ( 8i and above) Oracle client can use Heterogeneous
>connections ( also called Open Connectivity or Oracle Gateway on a more sophisticated version ) with the proper configuration
>in your ODBC DSN and Tnsnames.ora files...
>
>The issue remains, why?..You can connect your Access directly to your Oracle tables ( as a Remote Link) and, therefore,
>you can use Access to react to changes in the Oracle data or write an Access proc that handles your task using the Oracle
>data
>..
>
>
>kuljeet_twtpl_at_hotmail.com (KULJEET) wrote:
>
>>rs_arwar_at_hotmail.com (Rauf Sarwar) wrote in message news:<92eeeff0.0305280846.7a91e8a2_at_posting.google.com>...
>>> "Nicke Verenius" <nicholaus_verenius_at_hotmail.com> wrote in message news:<5hZAa.18383$X2.506_at_news2.bredband.com>...
>>> > Hi,
>>> >
>>> > Is it possible to create a database link from oracle that use ODBC?
>>> >
>>> > I want a stored procedure in oracle update a table in Access. Is that
>>> > possible??
>>> >
>>> > /nv
>>>
>>>
>>> You may not get a better response to your question because despite
>>> your valiant effort, you still left out few NG's from your cross post
>>> -:).
>>>
>>> Regards
>>> /Rauf Sarwar
>>
>>yes you can do it
>>with he help of front end tool that is d2k
>>install its client tolls on u r machine and its oca (oracle client adapter).
>>From d2k's sql plus u connect to access with the help of odbc.
>>
>>connect user name/password_at_odbc:<odbc name>
>>
>>and u r also connect to oracle.
>>
>>so take this toll as intermediate .you can use access and oracle.
>>
>>for more information you give proper details.
>
>
>
>----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
>http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
>---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---
Received on Wed Jun 11 2003 - 21:53:46 CEST