data source name not found and no default driver specified

B

Brett Martin

Has anyone came across a solution to the following error message when
connecting to SQL table?

[Microsoft][odbc driver manager] data source name not found and no default
driver specified.

This occurrs when I refresh an external data link on a pc which is different
to the one when the original link was created on. Previous links of this
type still work ok on multiple pc's but not new ones!

Is there a way of setting an odbc link that can then be used on multiple pc's.

Excel 2003.

thanks

Brett Martin.
 
Top