Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | 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
 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  
 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.17 seconds. Powered By: Snitz Forums 2000