MSDAORA.1 and OraOLEDB.Oracle.1 Issue

Hi I am using .Net Application.I am having issue using database provider as MSDAORA.1 and OraOLEDB.Oracle.1.In my 2003 server I was using provider as MSDAORA.1 But Then I changed my machine,Now its 2008 server.When I am trying to use MSDAORA.1 then no database connection is working But if do use OraOLEDB.Oracle.1 then its working fine.I dont know why its happening like that. Also in different 2008 machine(other than previous one), MSDAORA.1 is working,I dont know why it's working like that.Please help.

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
MSDAORA is deprecated and shouldn't be used.  The Microsoft drivers only sat on top of the Oracle Client so why not just use the Oracle native drivers since you had to install them anyway?

When using .Net and Oracle I would strongly encourage you to use ODP.Net as the data access provider.  There is now a Managed Client that doesn't need a full Oracle Client install.  I've been using the Managed Client since it was released and have been very happy with it.

All that said:  What is the error you get when trying to use MSDAORA?
SudhanshumAuthor Commented:
Thanks for reply.I checked today my site with MSDORA and it seems to be working fine.I have not done anything so I am not sure why it is working today and not yesterday.
 Which one is better in ODP.Net  and OraOLEDB.Also please tell me how to use things.

SudhanshumAuthor Commented:
Yesterday I was getting this error when i debugged Error while trying to retrieve text for error ORA-01019.

slightwv (䄆 Netminder) Commented:
>>I have not done anything so I am not sure why it is working today and not yesterday.

Check the site referenced below on the error message.  If you were receiving an error message it would have been helpful to have that in the original question.

Looks like a memory issue of some type.  Could be just about anything.  A bad database call that returned way too much data, a memory leak, cleanup not running in time, app pool not recycling in time, etc...

>>Which one is better in ODP.Net  and OraOLEDB.

ODP.Net is a data access provider specifically for .Net apps connecting to Oracle.  I' not aware of anything that compares the different drivers and what one offers over another.

>>Also please tell me how to use things.

You reference the correct driver and use it like any other data access provider.  Depending on what you install, ODP.Net comes with examples on just about everything.  If you don't get the examples, they are available online.

If you are familiar with .Net and MSDORA and OleDB calls, moving to ODP.Net shouldn't be a big deal.

>>error ORA-01019
Never seen that error but here is what it means:

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.