Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DB Link

Status
Not open for further replies.

mike777

Programmer
Joined
Jun 3, 2000
Messages
387
Location
US
Hello.
Has anyone had any success using a db link to access another database (i.e., a different type of database, in this case Borland Interbase)?
Thank you.
-Mike
 
Hi,
did you read the docs on heterogeneous connections?

For Oracle 8i you can look here:

For 9i ( much easier, it seems) look here:


hth,
[profile]

PS you may need to register with Oracle's Technet - do so, it is free, they respect your privacy, do not spam, and it is a valuable resource.
 
heres an example

#THIS DOES NOT NEED AN ENTRY IN TNSNAMES.ora FILE

CREATE DATABASE LINK DEMO_LINK.WORLD
CONNECT TO APPS
IDENTIFIED BY APPS
USING '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lsi)(PORT=1523))(CONNECT_DATA=(SID=DEMO)))'

Sy UK
 
Hi,
That example might work to connect to an Oracle instance called 'DEMO' , but it will not connect to any non-Oracle database, which is what Mike777 wanted to do.


[profile]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top