CODEWITHSUNDEEP
windowsoracle-databasevisual-studioodbc
masospaghetti
masospaghetti

Reputation: 348

Connecting to ODBC Data Source in Visual Studio

I had this working on my old 32-bit Windows 7 machine running VS 2010 but am having trouble on my new 64-bit Windows 7 machine running VS 2015.

All I want to do is add an Oracle ODBC connection to Visual Studio's Server Explorer. I get the following error:

Visual Studio error with connecting to ODBC

I have successfully configured and set up the 32-bit and 64-bit ODBC utilities with ODBC drivers, both pass the "test connection". Also I have set up Oracle SQL Developer to connect to the exact same source using the same credentials and I am able to read from the server in question. Here is the successful connection attempt in the ODBC utility:

ODBC Success

Upvotes: 0

Views: 10739

Answers (1)

masospaghetti
masospaghetti

Reputation: 348

I removed the Oracle ODP.NET developer toolset for Visual Studio and now the connections are working. I find Oracle's software incredibly frustrating and hard to use.

Wernfried thank you for taking the time to help.

Upvotes: 1

Related Questions