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 5

    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:

    There are two possibilities for receiving this error message:

    1. 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.

     

     

     

    2. Special character in the connection password such as a single quote, double quote, or a semi-colon.

     

    Solution / Workaround:

    1. 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.

     

    2. Utilize a connection password that does not contain special characters.