Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
odbc error on Excel query into database
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
odbc error on Excel query into database
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update database from ODBC query (or another method) | Excel Worksheet Functions | |||
Update database from ODBC query | Excel Discussion (Misc queries) | |||
I have Error 1919 Error Configuring ODBC dataSource Database | Excel Discussion (Misc queries) | |||
ODBC database query | Excel Discussion (Misc queries) | |||
Multiple ODBC Database lik in one MSQUERY query | Excel Discussion (Misc queries) |