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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 SSMS linked server vs Aqua Data Studio

Author  Topic 

psugak
Starting Member

4 Posts

Posted - 2010-03-16 : 16:56:31
I created a linked server in SSMS that links to oracle. When i run a query, i return 161 results. HOWEVER, when i run the same exact query in aqua data studio (from a different server than the one SSMS is on), i pull back 260 records and there are no duplicates. Do any of you know why the linked server is not pulling back all the data?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-03-16 : 18:01:01
To me it sounds like a faulty driver.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

psugak
Starting Member

4 Posts

Posted - 2010-03-17 : 08:03:41
I just ran the same code from another server using the same version oracle driver and im still only pulling back 161 records. hmmmm
Go to Top of Page
   

- Advertisement -