locked
Error in ASP Database connection RRS feed

  • Question

  • User-1348374848 posted

    Using this connection string to reach the Database Dim strConexao As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\gustavodata.accdb;Persist Security Info= False; Jet OLEDB:Database Password:gustavo123;"

    And calling strConexao as   Dim cn As New OleDbConnection(strConexao), i got the following error ="Format of the initialization string does not conform to specification starting at index 110."

    Is there anything to do?

    Friday, October 25, 2013 2:35 PM

Answers

  • User-821857111 posted

    Remove 'Persist Security Info = false' - it's either that or a passsword:

    "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\gustavodata.accdb;Jet OLEDB:Database Password:gustavo123;"

    http://www.connectionstrings.com/access/


    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, October 25, 2013 3:50 PM