This forum is currently locked. You can't register or post questions at this time. (read more)

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

All posts relating to Oracle database administration.

Moderator: Tim...

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

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

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

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

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

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

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

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


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 4 guests

cron