OleDB Connected database tables datatype changed

Discussion created by Indra_Bisen on Jan 4, 2012
Latest reply on Jan 4, 2012 by blin-esristaff
My some other data of features is stored in different sql server database and I would like to join this external database with featurelayer. I'd made OLE DB Connection to other Sql Server Database and added the table into mxd. When I open the external database tables fields properties then we got strange result that it is showing all BigInt type columns to Text type and VarChar type columns to BLOB. 

When we are checking the datatypes of these columns thorugh SQL SERVER MGT STUDIO it is showing proper result.

Due to this reason we are unable to join this external database tables with Feature Layer.

Why it is happening any clues???

With Regards,

Indra Bisen