Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 1 of 1 total
Thread ODBC Linker Server returning less rows than standard DB utility query
Tue, Feb 12 2013 9:49 AMPermanent Link

JonM

Hi,

I am trying to set up a query to a DBISAM database using a linked server in SQL Server 2005. In particular I am looking at a table that contains product information.

When I query this using the DBISAM-ADD Database System Utility (downloaded from this website) I get 10864 rows. However when I use the linked server approach I get only 10815 rows.

--linked server
--returns a count of 10,815
SELECT COUNT(*) FROM OPENQUERY([ISIS],'SELECT * FROM PRODUCT')

--db system utility
--returns a count of 10,864
SELECT * FROM PRODUCT

Strangely, running the following query on the linked server returns a value of 10,864
SELECT * FROM OPENQUERY([ISIS],'SELECT COUNT(*) FROM PRODUCT')

I have identified a specific product code for which two rows exist in the product table, but only one of these is returned by the linked server approach.

The linked server uses the ODBC driver version 4.23 - and is set up on a 32 bit instance in order to accomodate this. Is a newer ODBC driver required, or is there a 64 bit version which we can use?

Thanks,
Jon
Image