Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 2 of 2 total

ODBC Linker Server returning less rows than standard DB utility query

Tue, Feb 12 2013 9:46 AM	Permanent 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
Thu, Feb 14 2013 10:45 AM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Jon, << 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. >> Are you using a newer version of the DBISAM Database System Utility than the ODBC Driver (Help/About for DBSys version) ? If so, then the later version is correct. However, I wouldn't expect DBISAM to have an issue with a simple SELECT * query, so the problem may be with the fetching in the ODBC driver. << 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? >> Yes, and yes. You can download a trial version here: http://www.elevatesoft.com/download?action=info&category=dbisam&type=dbisamodbctrial&majorversion=4&version=4.34 Both the 32-bit and 64-bit ODBC driver are installed automatically when you install the product. If you have any other questions, please let me know. Tim Young Elevate Software www.elevatesoft.com