newbie ODBC question

[Tracy3e]

I do not understand this ODBC setup on Win2K very well. I keep getting a pesky error that I do not know how to get rid of.

From Excel we choose
- Data
- Get External Data
- Run Saved Query
- Choose Query
- Then asks where to put the data (choose OK to leave as default $A$1)

[Microsoft] [ODBC Driver Manager] Data Source Not found and no default driver specified.

Then you have to click OK and choose the DSN from the list of Machine Data Sources.

Can you tell me why it says the above error when the DSN is configured in "Data Sources ODBC" under Control Panel, Administration Tools!?! What am I missing?

 

[Tracy3e]

Does anyone have any ideas about the above error?

 

[ETID]

Did you select the data source/driver before you pointed odbc to your database path?

 

[Required]

You might have a look at Microsoft's Knowledge Base.
Here are the (long) URLs from three entries related to this error (136481, 140895 and 174655):

http://support.microsoft.com/direct...specified.&src=DHCS_MSPSS_msdn_SRCH&SPR=ODBC&

http://support.microsoft.com/direct...specified.&src=DHCS_MSPSS_msdn_SRCH&SPR=ODBC&

http://support.microsoft.com/direct...specified.&src=DHCS_MSPSS_msdn_SRCH&SPR=ODBC&