ODBC Driver Manager data source name not found

[123gad]

Hi I have a W2K Prof computer brandnew with MS Office 2000, and I have a lot of queries, and run the report in Excel with different pivot tables, with this PC I can not go to Excel go to Data and select run saved query - I receive the following message:
ODBC Driver Manager - Data source name not found and no default driver specified

I am able to create a query from scratch, but that does not help me, I already installed all the ODBC drivers from the Office 2000 CD.
It works fine on all Windows 98 SE machine.

Any Ideas what else I can try?
I have another W2K Prof PC and it is working there.

thanks for all your help

 

[cheerio]

Data source name or DSN is a pointer to the data source. For example, it might indicate that the data is in a SQL Server Database on a Server called PingPong and in a database called FRED. It might specify a login and password.

A DSN could be a file or it might be a set of registry entries. What you have to do is go to one of your working PCs and identify the DSN and its type.

On such a PC start a new query in Excel. It should bring you to a screen called choose database source. Generally system DSNs which are stored in the registry have a * after the name and file DSNs do not.

 

[pauldes]

You will have to rebuild the old data sources(ODBC connections) in Control Panel>Administrative Tools>Data Sources(ODBC). You'd be best advised, if you can, to somehow resurect the old PC, and find out the ODBC connection names and all their details to create identical new entries in your new PC. Your queries are looking to match the names you gave your ODBC connections on your old machine exactly when being run on the new machine.