This is a migrated thread and some comments may be shown as answers.

Not Able to Connect to Oracle Database

1 Answer 143 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Nitin Koka
Top achievements
Rank 1
Nitin Koka asked on 11 May 2010, 05:34 PM
Hello,

I am trying to connect to an Oracle Database using ODP.NET
I am able to create a SQL Data Source without any issues with ODP.NET and to my database server. The problem is when i create my query and try to execute the query in the wizard i get an error. And the error dialog box only says Oracle.DataAccess.Client.

Please help i am really stuck here

Thanks

Nitin K Koka

1 Answer, 1 is accepted

Sort by
0
roberto
Top achievements
Rank 1
answered on 11 May 2010, 08:00 PM
Try to connect using System.Data.OracleClient instead of Oracle.DataAccess.Client.
using the Microsoft provider i was able to use the wizard,


Tags
General Discussions
Asked by
Nitin Koka
Top achievements
Rank 1
Answers by
roberto
Top achievements
Rank 1
Share this question
or