locked
Visual Studio 2008 support for Oracle 11g and Oracle 10g RRS feed

  • 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

    Tuesday, May 31, 2011 1:12 PM

Answers

  • 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.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, June 20, 2011 3:48 AM

All replies

  • 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...

    Tuesday, May 31, 2011 2:01 PM
  • 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.

    Tuesday, May 31, 2011 3:39 PM
  • 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...

    Tuesday, May 31, 2011 4:09 PM
  • 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.

    Wednesday, June 1, 2011 3:19 AM
  • 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.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, June 20, 2011 3:48 AM