10g Oracle dblink to SQL Server ( Heterogeneous Services ?)

All posts relating to Oracle database administration.

Moderator: Tim...

10g Oracle dblink to SQL Server ( Heterogeneous Services ?)

Postby jrmtl » Thu Jun 27, 2013 6:32 pm

Hello all,

It's been a while since I haven`t posted a questions :)
I am trying to define a dblink on my oracle server over towards an SQL Server . Although a few articles mention the steps online, they seem convoluted.
The article on oracle-base is for 9i but does it apply to 10.2.0.3 ?

Thanks !
JR
jrmtl
Senior Member
 
Posts: 195
Joined: Tue Feb 22, 2005 7:08 pm
Location: Montreal

Re: 10g Oracle dblink to SQL Server ( Heterogeneous Services

Postby Tim... » Thu Jun 27, 2013 10:36 pm

Hi.

Yes. That bit of functionality hasn't changed much since it was introduced.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17966
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: 10g Oracle dblink to SQL Server ( Heterogeneous Services

Postby jrmtl » Fri Jun 28, 2013 12:22 pm

Great thx tim

So I`ll follow those instructions

JR
jrmtl
Senior Member
 
Posts: 195
Joined: Tue Feb 22, 2005 7:08 pm
Location: Montreal

Re: 10g Oracle dblink to SQL Server ( Heterogeneous Services

Postby Tim... » Fri Jun 28, 2013 7:23 pm

Hi.

Let me know how you get on. :)

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17966
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 1 guest

cron