ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Links and Linking in Excel (https://www.excelbanter.com/links-linking-excel/)
-   -   Query Link error (https://www.excelbanter.com/links-linking-excel/14656-query-link-error.html)

totoro

Query Link error
 
we have a shared spreadsheet ,numerous users access, and there are many
copies, and all r affected: it pulls data from a SQLbase db based on a range
of dates. when we open the file we often see this Excel error:
[INTERSOLV][ODBC SQLBase driver][SQLBase]02212 EVA NOF Numeric overflow
but you click ok, it refreshes the data, and you see the results.
we found that if you put in dates for February (eg 2/1/2005 through
2/28/2005) the data stops refreshing and the data disappears. by trial and
error i found if you go back to January, and going to the sheet where the
query is run from, you can go to DataImport Ext DataEdit QUery and get it
to works again, even for February. Is this a connection error? Any
suggestions?

Bill Manville

I don't know anything about the Intersolv driver.

Google showed me other messages on a similar subject (without replies)
in other groups, relating to the Intersolv driver.

You could try contacting Intersolv:
http://www.intersolv.com

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup



All times are GMT +1. The time now is 08:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com