OPENQUERY ISSUE - 06-18-2008 , 12:01 PM
I have SQL 2005 Enterprise set up with Linked Server using ODBC Driver
(System DSN) to access an AS/400.
When I run the subquery below, I get 2002328 records.
SELECT * FROM OPENQUERY(SILVER, 'SELECT COUNT(*)FROM LOHTDLFP.MPMNMCP_X')
But, only 24 Records for the following one.
SELECT * FROM OPENQUERY(SILVER, 'SELECT * FROM LOHTDLFP.MPMNMCP_X')
Any ideas why the difference here? Is there something I should be looking at
a DSN configuration level?
Thanks very much,