Re: SQL server to Oracle Migration

From: Dmitry <support_at_ispirer.com>
Date: Tue, 20 May 2003 18:58:48 +0300
Message-ID: <badjbr$s1h63$1@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 - 10:58:48 CDT