Re: SQL server to Oracle Migration

"Nate Tobik" <nathan.tobik_at_vigilantminds.com> wrote:

>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
>

Have you tried migrating using the Oracle Migration Workbench ? Take a look:

http://otn.oracle.com/tech/migration/workbench/content.html

You may need to register with OTN, it is free and will be a very valuable resource ...

----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Received on Mon May 19 2003 - 14:22:52 CDT