none
ORA-06413 Connection not Open RRS feed

  • Question

  • Hi,

    When I try to create a connection between Excel 2013 and MS Access on a Windows 10,  64-bit (x64) machine, I received the following error.  Actually, it's a surprise for me because I was using the same file on my old computer windows 7.

    Please advice

    Thanks,

    Run-time error '-2147467259 (80004005)':

    ORA-06413 Connection not Open

    Query Detail and References:

    Dim conn As New ADODB.Connection
    Dim <g class="gr_ gr_342 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" data-gr-id="342" id="342">rst</g> As New ADODB.Recordset
    Dim ConnectionString As String
    Dim Query As String
    Dim user As String
    Dim pass As String

    ConnectionString = "Provider=msdaora;Data Source=P007.ORACLEDB.UPS.COM;User Id=" & user & ";Password=" & pass & ""
    conn.Open ConnectionString

    

    Tuesday, May 22, 2018 9:01 AM

All replies

  • Hi,

    This is the forum to discuss questions and feedback for Microsoft Excel features, I'll move your question to the MSDN forum for Excel

    https://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev

    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

    Regards,

    Emi


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.


    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    Wednesday, May 23, 2018 2:03 AM
  • Hello Merve,

    Are you connect excel to access? "msdaora"  is usually used to connect to Oracle.

    I would suggest you  go to Data->Get Data->From Database to try to connect to the database manually. 

    Once you could build the connection manually, you could right click the connection and select properties to check its connecting string. You could adjust your ConnectionString according to the connection's connecting string.

    Best Regards,

    Terry


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, May 24, 2018 2:52 AM