ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Data source name not found and no default driver specified (https://www.excelbanter.com/excel-discussion-misc-queries/195731-data-source-name-not-found-no-default-driver-specified.html)

robboll

Data source name not found and no default driver specified
 
I moved a database to another server and after updating the ODBC DSN
to point to the new server I get the error: Data source name not
found and no default driver specified. If I change the DSN back to
the old server and put the old database back online, everything is
fine. Change it back to the new server and I get the error.

If I create a new worksheet and reference the data, it works fine.

Any help from this group greatly appreciated!

RBollinger


All times are GMT +1. The time now is 04:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com