Oracle Table Conversion

[TT]

Hi there,

I have a quick question regarding a linked oracle table in my DB.

In oracle, the table is set up as follows:
TEAM_ID NUMBER(38)
ACTIVE NUMBER(38)

These two fields are showing up as text fields in my linked table.

I read this article on microsoft's website:
http://support.microsoft.com/kb/104977

I was just wondering if there was fix for this at all or is this just one of
the things we have to live with?

Thanks for your assistance!

 

[Tom van Stiphout]

On Thu, 24 Apr 2008 09:25:04 -0700, TT <[email protected]>
wrote:

did you see the note in that article:
Note that the Smallint data type is the same as an ORACLE data type
of Number(38,0).

Perhaps you can use it to your advantage.

-Tom.

 

[TT]

Thanks for getting back to me Tom.

I did see that comment, but wasn't exactly sure how to interpret it. Would
you be able to elaborate a little for me??

Thanks!!