p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

access thread: Access/Oracle pass-through query error


Message #1 by tedalmeida@h... on Fri, 29 Jun 2001 06:35:04
I'm writing a pass-through query using Access to retrieve a column from an 

Oracle table. The column is a non-indexed double with a max length of 22 

characters.



The problem is when the query returns a value over 32,768 Access gives me 

an error message stating that "the value is out of range (#0)". I'm using 

Win2000, but we get the same error on NT 4.0 & Win98. It also happens with 

both Access 97 & 2000.



The SQL statement is:



SELECT UNIT_MAIN.UNIT_ID, UNIT_MAIN.IN_SERV_METER

FROM UNIT_MAIN



Is there a property setting that I should be changing, or maybe the ODBC 

driver? Or something else?




  Return to Index