Visual Studio 2008 support for Oracle 11g and Oracle 10g

Question

User111611878 posted

Hi,

I am trying to connect to Oracle 11g DB server via an SqlDataSource control.
I hit New Connection>Change > Change Data Source and then select Oracle Database.
Upon doing that I get the following Description on the right hand side:


"Use this selection to connect to Oracle 7.3, 8i or 9i using the .NET Framework Data Provider for Oracle."

What do I do to connect to an Oracle 11g ?

I tried using the 'Oracle (OLE DB)' while entering the TNS Service Name in the 'Server Name' box, but got the "ORA-06413:Connection Not Open" error message.
Also tried using the 'Oracle Database(OracleClient)' , but enetering the TNS Service Name in the 'Server Name' box got me the following error message :
"ORA-12154: TNS:could not resolve the connect identifier specified".

Maybe this is to do with the lack of support for Oracle 11g on my Visual Studio 2008 or maybe it is something else.
Anyone knows how do you get the Visual Studio 2008 to support Oracle 11g and Oracle 10g ?

My Visual Studio 2008 is a 32bit installation on a 64bit Windows 7.
My Visual Studio 2008 version numbers are :

Microsoft Visual Studio 2008
Version 9.0.21022.8 RTM
Microsoft .NET Framework
Version 3.5 SP1

Installed Edition: Professional

Microsoft Visual Basic 2008   91605-270-9658527-60105
Microsoft Visual Basic 2008

Microsoft Visual C# 2008   91605-270-9658527-60105
Microsoft Visual C# 2008

Microsoft Visual C++ 2008   91605-270-9658527-60105
Microsoft Visual C++ 2008

Microsoft Visual Studio 2008 Tools for Office   91605-270-9658527-60105
Microsoft Visual Studio 2008 Tools for Office

Microsoft Visual Web Developer 2008   91605-270-9658527-60105
Microsoft Visual Web Developer 2008

Crystal Reports    AAJ60-G0MSA4K-68000CF
Crystal Reports Basic for Visual Studio 2008

Thanks,

GG

Answer 1

User551462331 posted

u can same connection to connect to 11g.

i have a .Net 2.0 (Vs 2005) application... wherein, oracle backend was upgraded to 11g and my application works without any change required..

make sure that you can connect to Oracle 11g database from any oracle query tool or sqlplusw from same machine where u r usng visual studio. 

the error message indicates some issue with tnsnames.ora file or other configuration file of oracle.... rather that Vs issue.

hope this helps...

Answer 2

User111611878 posted

Hi,

Thanks for your reply, but, I can connect to the DB server via SQLPLUS without a problem.

Using the same TNS Service Name with Visual Studio 2008 results in error messages I have described in the beginning.

I hope Visual Studio doesn't require a local DB Server.

Another thing, my local Oracle client is 10g , while Oracle Server is 11g.

On paper that should not be a problem but one never knows.

Answer 3

User551462331 posted

just a thought...

u r local machine is 64 bit and vs is 32 bit.. so might be, they are referring diffrent client tnsnames...

check oracle folder if there is multiple client folders...

check this out....  i m too curious to know if any compatibility issues

http://chadit.wordpress.com/2009/11/19/windows-x64-oracle-11g-x64-and-visual-studio-20082010-connection/

hope this helps...

Answer 4

User111611878 posted

Here's what I found on the Internet :

http://tiredblogger.wordpress.com/2007/11/21/oracle-data-access-components-odac-with-64-bit-development/

Will install Oracle 11g client X64 and see wheather that fixes it.

Answer 5

User111611878 posted

In the end , the only way to move on was to install Visual Studio 2008 on a 32bit platform.

Once I did that everything was working OK.

The generated code would then also run on 64 bit machines.