Why do I see “A ‘Create Data Source’ error has occurred. Database: Test1” error when starting a database for format of ODBC?

[LindaYu]

Why do I see “A ‘Create Data Source’ error has occurred. Database: Test1” error when starting a database for format of ODBC?

[LindaYu · Accepted solution]

When you start a DBC to send the data to SQL server, you may see this error: 

This is because the ODBC Data Source is already created on this server, however you are trying to create the same DSN again when starting the Database.

To resolve it:

1. Right click on the Database to select proprieties.
2. Under the Format tab, un-select “Create DSN” option
3. Save the Database document
4. Start the database again.

Here is a demo video. Hope this helps.