Connect to Oracle 10g with Visual Studio

[crazyboybert]

Hey All

I know this post is off-topic for this forum but there doesn't seem to be a great deal of activity over in the Oracle forums. I want to connect VS.NET to an Oracle 10g server to create xsd files using the designer (drag and drop from Server Explorer). I had this working in the past but now it fails.

I can connect to the Oracle server using Microsoft Provider for ODBC Drivers and the Oracle Provider for .NET. However, if you try to drag a table onto the designer then you get the following error...


Connecting to Oracle databases through ODBC is not supported by Visual Studio. To enable Visual Studio Oracle support the data connection must use Microsoft OLE DB Provider for Oracle.

The problem being when I try to connect to Oracle using the Microsoft OLE DB Procider for Oracle I get the following error (note this is any connection not just VS server explorer)...

Test connection failed because of an error in initializing provider. Oracle error occurred, but error message could not be retrieved from Oracle.

So the problme is with the Microsoft Oracle Provider but what is it. I've tried reinstalling MDAC 2.7 SP1 with no joy. What else could it be?

TIA

Rob

i'm a boy, called Bert, and I may not be crazy, but if i'm not the rest of you are...

 

[chiph]

Did you try Oracle's .net provider? The one from Oracle, not Microsoft.

Chip H.


____________________________________________________________________
Click here to learn Ways to help with Tsunami Relief
If you want to get the best response to a question, please read FAQ222-2244 first

 

[chrissie1]

Did you install the oracle client tools and can you make a connection via ODBC?

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting

 

[crazyboybert]

Chip: Yes I did try the Oracle Provider. I'm actualluy using that for the application DA code. Unfortunately Visual Studio doesn't support drag and drop from Server Explorer with this provider.

Christiaan: Yeah got client tools installed, can connect fine with Enterprise Manager, SQL*Plus, Designer etc and with ODBC driver provider also. Again though VS doesnt support XSD designer with this provider.

Cheers though

Rob

i'm a boy, called Bert, and I may not be crazy, but if i'm not the rest of you are...