#1   Report Post  
totoro
 
Posts: n/a
Default 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?
  #2   Report Post  
Bill Manville
 
Posts: n/a
Default

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with VBA returning the contents of a long formula. [email protected] Excel Discussion (Misc queries) 2 February 23rd 05 12:14 AM
Error on new Data Base Query MESTRELLA29 Excel Discussion (Misc queries) 1 February 9th 05 06:56 PM
Link Access query to refresh an EXCEL file Dancer4u New Users to Excel 1 January 13th 05 05:24 PM
How to use a Access Query that as a parameter into Excel database query Karen Middleton Excel Discussion (Misc queries) 1 December 13th 04 07:54 PM
#REF error Christen Excel Worksheet Functions 5 November 3rd 04 07:29 PM


All times are GMT +1. The time now is 04:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"