Re: Use ODBC for Oracle DBLink

As far as I know, you cannot use ODBC connections as a DBLink, only native SqlNet ....

If you need access to the remote Oracle database with a tool that only uses ODBC, you could do the following:

Create a DBLink using the tnsnames.ora alias for the remote database ( the entry must be in the tnsnames.ora file on your local Oracle server)

Create view(s) in your Oracle database of the tables you need to access on the remote Oracle database _ create view select * from remote_table_at_dblinkname Use ODBC to access your Oracle and the views you created...

Proceed ...
hth,

"¥òµa" <jemy_at_mail.ht.net.com> wrote:

>Hi :
>I was made DBLink connect to other DataBase for Oracle 8.0.5. I was used
>ODBC driver to connect.That syntax be "Create public database admin
>identified by admin using 'odbc:test';". But it was not work and use sqlplus
>appear a message "ora-06401: netcmn : invalid driver designator". Who can
>soulation my question ?
>thank you !!
>
>mail to: jemy_at_mail.ht.net.tw
>

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Fri Dec 10 1999 - 09:35:42 CST