Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
mlevier
Starting Member
33 Posts |
Posted - 2007-08-30 : 08:25:52
|
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. |
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-31 : 00:30:47
|
What was the error? Which provider did you use to create linked server? |
|
|
|
|
|