Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL server to Oracle Migration
Thanks,
We are using the Oracle driver the comes from the OTN site. Do you know of a way using the Oracle driver to force the return values of a NUMBER(n,0) to SQL_INTEGER, we tried declaring the value in the schema an INTEGER and it was to no avail. Thank you for your help.
Nate Tobik
VigilantMinds
"Dmitry" <support_at_ispirer.com> wrote in message
news:badjbr$s1h63$1_at_ID-75577.news.dfncis.de...
> Hi,
>
> ODBC driver recognizes Oracle NUMBER(n,0) as ODBC SQL_NUMERIC, not
> SQL_INTEGER. This may cause errors in your application.
> Try to use Oracle ODBC driver for your application, Microsoft ODBC driver
> for Oracle has many limitations.
>
> Best regards, Dmitry
> --
> SQLWays - Database migration software for IBM DB2, Oracle, SQL Server,
> Sybase and MySQL
> http://www.ispirer.com/products
>
> "Nate Tobik" <nathan.tobik_at_vigilantminds.com> wrote in message
> news:bab6mc$11ep$1_at_news.aspstation.net...
> > Hi
> >
> > We are currently trying to migrate from SQL server to Oracle. But
> > we're running into a problem with the values of the table. The datatype
> in
> > SQL Server is an integer type, and in Oracle a number (10,0), the
> > application we're using to connect with Oracle is reporting a
> > "[Microsoft][ODBC Driver Manager] Program type out of range, state:
S1003"
> > error. What is happening is the program is looking for an integer and
> > Oracle has a number. We changed the field from NUMBER (10,0) to NUMBER
> (9)
> > in hopes that the ODBC driver would recognize the NUMBER (9) as an
> integer.
> > It didn't work, does anyone have any ideas, or anythink we can try next?
> > thank you.
> >
> > Nate Tobik
> > VigilantMinds
> >
> >
>
>
Received on Tue May 20 2003 - 14:08:14 CDT