Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM ODBC Driver » View Thread |
Messages 1 to 1 of 1 total |
ODBC Linker Server returning less rows than standard DB utility query |
Tue, Feb 12 2013 9:49 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 |
This web page was last updated on Monday, April 29, 2024 at 05:23 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |