From: jocave@yahoo.com (Justin Cave) Newsgroups: comp.databases.oracle,microsoft.public.excel.misc,microsoft.public.excel.programming Subject: Re: ODBC 0722 Invalid number error when using parameters in MSQuery Date: 11 Nov 2002 12:59:02 -0800 Organization: http://groups.google.com/ Lines: 17 Message-ID: <233b7a65.0211111259.124c4d72@posting.google.com> References: <76d0c588.0211110752.22b603a3@posting.google.com> NNTP-Posting-Host: 156.153.254.2 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1037048342 23233 127.0.0.1 (11 Nov 2002 20:59:02 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: 11 Nov 2002 20:59:02 GMT jeroen002@hotmail.com (Jeroen) wrote in message news:<76d0c588.0211110752.22b603a3@posting.google.com>... > > On half of our newly installed pcs we have the problem that when we > use a (numeric) parameter in a query from a oracle 8.1 database, we > get an ODBC error (ORA0722 Invalid number). Strange thing is that on > other (supposedly equally installed) pcs this problem does NOT occur. > > Does anyone know what causes this problem? All NLS setting in the > registry and the decimal signs in the regional settings are equal, so > that is not the problem. My guess would be that you have different versions of the MDAC (Microsoft Data Access Components) installed. Go to and download the MDAC version checker and/or the version of the MDAC your driver is designed for. Justin Cave