View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
flowry flowry is offline
external usenet poster
 
Posts: 2
Default odbc error on Excel query into database

Yes, as it works fine when loaded onto other Windows 2000 users PC's. And
definitely need to know how to redefine the connection when transfer to XP as
that is the companies forward path and there are manyy Excel queries setup
for many users and would like not to re-write them for XP on an XP. Tested
just short scripting on XP to the database and works fine when developed on
the XP PC. Any further guideance would be greatly appreciated. FIII

"microsoft.public.excel.worksheet.functio" wrote:

Hi. Is possible that the change from 2000 to XP is the reason. So suggestion,
redefine the connection with the file running under XP. Whether you don't
know how to do this, let me know what is the whole scenario. Perhaps is
pulling from Access? Best of luck.

"flowry" wrote:

Excel query worked when on Windows 2000, but when load on to Windows XP get
the following message. [MICROSOFT][ODBC DRIVER MANAGER] DATA SOURCE NAME NOT
FOUND AND NO DEFAULT DRIVER SPECIFIED. Unable to find issue. Anyone have
any ideas upon how to correct?

FIII