Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Solutions:

One of the possible causes for the error is the driver that is used in the connection string.

Some uses SQL Native Client and some uses SQL Server as their drivers.

Another possible cause may be the DSN is not set up correctly. Ensure that you test your DSN setting.