No place to enter SID in the VS 'Add Connection' dialogue. RRS feed

  • Question

  • Hi, I'm currently trying to add a connection to a remote Oracle 10g (I think) database using the Add Connection-dialogue in Visual Studio 2008.
    Since System.Data.OracleClient is about to go, I have installed ODP.NET and am trying to use that instead. However, I cannot find anywhere to enter the SID required for the connection string, which leads it to get a ORA-12504 because the server didn't receive SERVICE_NAME.

    Of course I can always connect using a manually crated connection string in my own code, but that can be a pain in the ____, so it would be nice if I could get the connection properly into VS.
    • Moved by YiChun Chen Friday, October 23, 2009 8:59 AM ADO.NET issue (From:Visual Studio Setup and Installation)
    Thursday, October 22, 2009 10:49 AM


All replies