Home » Infrastructure » Windows » MS Access & SQL passthru error - invalid precision for decimal data type
MS Access & SQL passthru error - invalid precision for decimal data type [message #101292] Fri, 23 July 2004 15:16 Go to next message
ajessop
Messages: 2
Registered: July 2004
Junior Member
I'm using Access 2002 with SP 3 on WinXP Pro.

I've tried using both the Oracle ODBC driver (sqora32.dll 9.2.0.3) and the Microsoft ODBC driver (msorcl32.dll 2.573.9030.0) and have the same problem with both.

With a pass-through query and no sum() function on a number(11,2) column the query works fine, but as soon as I use the sum() function the query won't work and all I get is "invalid precision for decimal data type".

The same query with the sum function works fine in SQL+ and Navigator.

 

Report message to a moderator

Re: MS Access & SQL passthru error - invalid precision for decimal data type [message #101319 is a reply to message #101292] Wed, 04 August 2004 10:25 Go to previous messageGo to next message
Racheal
Messages: 1
Registered: August 2004
Junior Member
I am getting the same error in Access 2000 running on Xp. The query works ok with Access 97. What is the solution?

Report message to a moderator

Re: MS Access & SQL passthru error - invalid precision for decimal data type [message #101372 is a reply to message #101319] Thu, 02 September 2004 10:48 Go to previous message
Rock
Messages: 18
Registered: February 2002
Junior Member
Hi,

I am getting the same error on a passthrough query to Oracle. I didn't realize it might have something to do with Sum() type function. I'm running Access 2000 on a Win@000 PC.

Has anyone given any clues as how to avoid this error?

Rock

Report message to a moderator

Previous Topic: ORACLE NT service starting problem TNS-12514
Next Topic: Windows server 2000 - 10 g install
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 04:06:36 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.