Changing Data Source Driver

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I use Microsoft query in Excel to dowload data using Client Access ODBC (32 - Bit) driver. However, my IT department has recently changed from using Client Access to using Rumba. Although I want my queries to access the same information, I have had to set up new ODBC data source using Rumba AS/400 Optimized Server (32 - Bit) driver. I have named the data source exactly as it was when the Client Access data source was in place, but when I go to edit my query, in Excel, I get the following message:

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

I presume that this message is appearing because I have changed the driver. Is it?
If so, is there anyway of resolving this, short of actually deleting all my queries and starting again?
PLEASE HELP!!
 
S

See my response in querydao

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

S Taylor said:
I use Microsoft query in Excel to dowload data using Client Access ODBC
Click to expand...
(32 - Bit) driver. However, my IT department has recently changed from using
Client Access to using Rumba. Although I want my queries to access the same
information, I have had to set up new ODBC data source using Rumba AS/400
Optimized Server (32 - Bit) driver. I have named the data source exactly as
it was when the Client Access data source was in place, but when I go to
edit my query, in Excel, I get the following message:
Microsoft Excel:
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

I presume that this message is appearing because I have changed the driver. Is it?
If so, is there anyway of resolving this, short of actually deleting all my queries and starting again?
PLEASE HELP!!
Click to expand...
 
Back
Top