If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
ODBC Links via Excel XP
A couple of months ago I designed an Excel file which
links directly to two data tables within an accounting system via an ODBC link. In MS Query the two data tables are linked and are filtered before being sent to MS Excel. This process worked well and still works very will on the original computer The user has recently purchased a new computer. When I tried to re-establish the ODBC link I encountered a problem. The data from the two data tables is coming across to MS Query OK but when it is being sent to MS Excel the connection fails. The software house that supports the ODBC link have tested this process thoroughly and are confident that the problem lies with the machine rather than the ODBC link. Has anyone any ideas how I may attempt to remedy this problem or can identify where the possible problem may lie?? I would greatly appreciate your help on this matter. Regards, CiaraG |
#2
|
|||
|
|||
ODBC Links via Excel XP
CiaraG
What do you mean by "connection fails." If you're getting an error message, post what it says. If not, just explain what's happening. Also, mention the accounting package. -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "CiaraG" wrote in message ... A couple of months ago I designed an Excel file which links directly to two data tables within an accounting system via an ODBC link. In MS Query the two data tables are linked and are filtered before being sent to MS Excel. This process worked well and still works very will on the original computer The user has recently purchased a new computer. When I tried to re-establish the ODBC link I encountered a problem. The data from the two data tables is coming across to MS Query OK but when it is being sent to MS Excel the connection fails. The software house that supports the ODBC link have tested this process thoroughly and are confident that the problem lies with the machine rather than the ODBC link. Has anyone any ideas how I may attempt to remedy this problem or can identify where the possible problem may lie?? I would greatly appreciate your help on this matter. Regards, CiaraG |
#3
|
|||
|
|||
ODBC Links via Excel XP
The exact error message that is posted says,
[TOD] [ODBC] [UNKNOWN] Network Connection lost (Recv): ErrorNo:10004. The sofware company who supports the software package - Insitu (bespoke hire management system) have already clarified that the ODBC driver is working correct. Any ideas? Regards, Ciara -----Original Message----- CiaraG What do you mean by "connection fails." If you're getting an error message, post what it says. If not, just explain what's happening. Also, mention the accounting package. -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "CiaraG" wrote in message ... A couple of months ago I designed an Excel file which links directly to two data tables within an accounting system via an ODBC link. In MS Query the two data tables are linked and are filtered before being sent to MS Excel. This process worked well and still works very will on the original computer The user has recently purchased a new computer. When I tried to re-establish the ODBC link I encountered a problem. The data from the two data tables is coming across to MS Query OK but when it is being sent to MS Excel the connection fails. The software house that supports the ODBC link have tested this process thoroughly and are confident that the problem lies with the machine rather than the ODBC link. Has anyone any ideas how I may attempt to remedy this problem or can identify where the possible problem may lie?? I would greatly appreciate your help on this matter. Regards, CiaraG . |
Thread Tools | |
Display Modes | |
|
|