locked
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

Answers

All replies

  • Hi Javanese,

    I am moving this thread from Base "Visual Studio Setup and Installation" forum to the "ADO.NET Data Providers" forum, since the issue is related to ADO.NET. There are more ADO.NET experts in the "ADO.NET Data Providers" forum.

    Thanks
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
    Friday, October 23, 2009 8:59 AM
  • Hi Javanese,

     

    There is a document about how to use ODP.NET,

    http://www.oracle.com/technology/sample_code/tech/windows/odpnet/howto/connect/index.html

     

    One part of the document talking about the Server Name,

    Add Net Service Names

    ODP.NET uses Net Service Names to identify the data source (database) it connects to. The Oracle Net Configuration Assistant Tool, a post installation tool that configures basic network components, can be used to setup the Net Service Names. Please refer to the Oracle9i Net Services Administrator's Guide available at OTN for the details on using this tool to setup the Net Services Names.

     

    There is another URL talking about adding service name in connection string,

     

    http://www.connectionstrings.com/oracle

     

    Since ODP.NET is developed by third party, it is not supported in MSDN forums.

    You can go to Oracle forum for better support,

    http://www.orafaq.com/forum/

     

     

    Best Regards

    Yichun Feng


    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
    • Marked as answer by Yichun_Feng Wednesday, October 28, 2009 2:33 AM
    Monday, October 26, 2009 8:38 AM
  • Hi,

     

    you have to type in Datasourcefield: Datasouce/SID

     

    than it works..

    • Proposed as answer by MikroDel Thursday, December 16, 2010 2:35 PM
    Wednesday, October 6, 2010 6:21 AM