locked
Need help on connecting to Oracle with VS 2012 +.NET 4.5 + ORacleDataAccess.client ? RRS feed

  • Question

  • User1122123312 posted

    Hi Team,

    Tried to connect with Oracle from .NET 4.5 + VS 2012;

    1.Using System.Data.OracleClient
    works fine from VS 2012, and throws TNS connect time out error when dpeloyed to web server

    2. Using Oracle.Dataaccess.Client
    Throws erors in VS 2012 itself saying wrong number of arguments;

    Could some please suggest the best way to connect to Oracle in any 32/64 bit server. This is dead important for our project to go LIVE asap;

    This is the major obstacle we are facing right now.

    Sunday, January 5, 2014 1:26 PM

All replies

  • User44562928 posted

    Hi

    Try this , If you have a firewall enabled on that system, try disabling the firewall and try again or modify tansnames.ora file and pass fully qualified SERVICE_NAME

     

    Sunday, January 5, 2014 2:18 PM
  • User1122123312 posted

    Thank you amol; Tried that too, but did not work.

    Sunday, January 5, 2014 2:43 PM