Re: ODBC 0722 Invalid number error when using parameters in MSQuery

jeroen002_at_hotmail.com (Jeroen) wrote in message news:<76d0c588.0211110752.22b603a3_at_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 <http://www.microsoft.com/data> and download the MDAC version checker and/or the version of the MDAC your driver is designed for.

Justin Cave Received on Mon Nov 11 2002 - 21:59:02 CET