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

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

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




.