Jim Bonnie's Blog

SQL Server 2005 and Oracle Linked Server

Dec 5

Written by: jbonnie
Monday, December 05, 2005 11:00:00 PM 

Started playing with SQL Server 2005 and Linked Oracle Servers.

The SQL Server 2005 Management studio gave some framework errors and I was forced to re-install the dot net 2.0 framework to get a clean start up.

After that I ws able to get a linked server added from the graphical editor.

The parameters are in a slightly different order than the stored procedure so be careful.

For example,

sp_addlinkedserver 'GOLF', 'Oracle',
'MSDAORA', 'GOLF'

where the first GOLF is the name of the local DB, and the second GOLF is the TNSNAMES entry for the oracle would appear as follow:

 

SQL Server 2005 Management Screen

Trackback Print
Location: Blogs Jim Bonnie's Blog
Tags:

Your name:
Your email:
(Optional) Email used only to show Gravatar.
Your website:
Title:
Comment:
Add Comment   Cancel 

Navigation

Register Login

About Me

Thanks for stopping by. My name is Jim Bonnie and I have been writing software for over 20 years. After building financial data systems for Reuters for nearly 18 years I have started doing contract work and am excited about technology and currently focus on Microsoft solutions. DotNetNuke has helped provide a good introduction to ASP.NET web application development, and I am now starting to branch out into other areas. Data Access techniques and SubSonic is something that I am looking into now. This has helped me get an invitation to speak at Las Vegas at DNN Open Force 07. it was a great time. And I am looking forward to OpenForce08, where I wil be presenting on TDD for DNN.

 

Reading the codebetter blogs and attending a nothing but .net training class with JP Boodhoo helped spark my interest in ALT.NET. I attended the first conference in Austin Texas, and it was amazing to see Scott Guthrie introduce the ASP.NET MVC framework.

Add to Technorati Favorites

View blog top tags

Links

Jim Bonnie's Blog

Jim Bonnie's Blog

Jim Bonnie's Blog