Linked server vs MS-Access odbc Oracle table record count

Recently migrated to windows 2008 / sql 2008 and am connecting to Oracle  via a linked server

Noticed problems in the data results.  I did a test with MSAccess to link to a table and found 8000 rows, when using
select * from openquery(LinkedServerName,'select * from TableName')
I received only 7000 rows

What could be causing this?????

JimDataAsked:
Who is Participating?
 
Jim P.Connect With a Mentor Commented:
>> InstantClient/ODBC to OpenClient/Oracle Provider

I still have not found a better option than using the orignating databases client/provider.
0
 
Jim P.Commented:
I have seen in some database applications that it only returns a certain number of rows if there is not a where clause (and sometimes even if there is).

Its the assumption that most times you only need a sample -- not all the data. Take a look at the Oracle settings and see if there is something like that in it.
0
 
JimDataAuthor Commented:
There is actually a 99 row count difference in table.  This is not related to a record count limit.  I can set the where clause to reduce the record count and still give a difference.
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
Jim P.Commented:
I ran into an issue with a linked Sybase to SQL -- someone had entered a wildly bad date in a field, the SQL Server choked pulling it over until we corrected it.

Is it a consistent 99 records? Do they have null fields, bad dates, anything like that?
0
 
JimDataAuthor Commented:
Yes.  Also, just changed the provider from the InstantClient/ODBC to OpenClient/Oracle Provider and it now works (all tables read the correct recordcount)


0
 
Jim P.Commented:
Glad to be of assistance. May all your days get brighter and brighter.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.