SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Quering a Linked Oracle Server
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

33 Posts

Posted - 08/30/2007 :  08:25:52  Show Profile  Reply with Quote

I am trying to pull data from an Oracle database on another server. In MS SQL Server 2005 I already set up a linked server connected and it tested fine. Plus all of the tables are there too. However, when I go to query any information it keeps on giving me an error. I tried basic sql statements and I have had no such luck even seeing the data. Is there a special trick to this or am I doing something wrong? I had tried to find resources out there but nothing is out there. I'm wondering if anyone has had experience with this?

I appreciate any amount of imput!
Thanks in advance.

Flowing Fount of Yak Knowledge

7266 Posts

Posted - 08/31/2007 :  00:30:47  Show Profile  Reply with Quote
What was the error? Which provider did you use to create linked server?
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000