Re: Database links

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 Thu May 29 2003 - 15:55:12 CEST