Error "Unable to create/update databse tables. Format of the initialization string does not conform to specifications starting at index 147" when trying to create/update Xtraction database

Version 4

    Error message:

    Unable to create/update database tables.  Format of the initialization string does not conform to specifications starting at index 147 error appears

     

    Cause:

    Extra spaces in the database connection settings window.

     

     

    SA username has extra spaces entered which causes the error to occur but a test connection will be successful.

     

     

    Solution / Workaround:

    Even though the test connection worked, the actual update statement will fail. Remove the extra spaces from the "Verify or Enter Connection Details" window or completely clear that window and re-enter the connection information.