Enterprise Library problem with oracle 10g installed on Sun Solari

[Wael Nofal]

I faced a problem with .Net 2.0 application working with oracle database
using Entrprise Library

Application installed on Win 2003 web server and oracle insalled on Sun
Solaris 64 bit

The problem I faced was, in select statments, if i run a page have a select
statement in page load, it's some times work and other times not work with no
rules in this issue, this confused me too much

my select statement like this;

select * from Employees where employeeID=10

After testing many trial, i found unlogical reason for this problem

I found if the column name length more than 8 character its making problems
in IDataReader Object calling eg: data["CONTACT_METHOD_ID"]

the reason was column name length "contact_method_id"

i changed my select using alias naming to be like

select CONTACT_METHOD_ID cntmthID from Employees where employeeID=10

data["cntmthID"]

then the system work with no any problems

the important not is this error is not appearing in oracle installed on
Windows operating systems

Can anyone till me, what is the reason, or this is a bug in Enterprise
Library?

=================

Wael Nofal, Software Developer, TacMe.Com