OracleDataAdapter Help

[Jairo Nieto]

Hi, I had developed 2 solutions with Oracle 9i as my database, using
OracleDataAdapter to connect and invoke stored procedures (packages). It
worked fine, until i had to create a console application that queried the
database. I started getting object reference not set to an instance of an
object, until I gave both the OracleDataAdapter.dll and the .exe console app
full trust in the framework configuration. The console app works fine now,
but my 2 previous solutions now throw Object reference not set to an
instance of an Object, in every page I used a DataAdapter or a
DataReader.The exception is thrown on the Fill method of the DataAdapter.
What could have happened???

Thanks a ton,
Jairo Nieto
MCAD

 

[Rami Saad]

Hello,

check out the following link. It has useful information about the usage of
OracleDataAdapter:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/
frlrfsystemdataoracleclientoracledataadapterclasstopic.asp
Also browse through the sublist in the left frame of the window.
Hope this helps.
If you have further questions regarding this issue, please don't hesitate
to reply back.

Regards,
Rami Saad
MEA Developer Support Center
ITworx on behalf of Microsoft EMEA GTSC