Re: Excel 2003 Automation error refreshing Database queries

On 1 Aug 2005 23:06:26 -0700, shaw.marsh_at_gmail.com wrote:

>Hi,
>
>We are experiencing "Automation Error: The object involved has
>disconnected from itsd client" errors when executing the following VBA
>code: "Selection.QueryTable.Refresh BackgroundQuery:=False"
>The error does not occur consistently and many spreadsheets have never
>exhibited the problem. A small group of spreadsheets often show the
>problem but not at consistent times or at the same query. The
>spreadsheets were originally written with Excel 97 using Windows 2000,
>MDAC 2.6 and Oracle version 8.1.7 and ran without any such errors, only
>showing this error since we upgraded to XP SP2 and Office 2003 SP1
>against Oracle 9.2.
>We have tried different versions of MDAC; on Windows 2000 server with
>Office 2003; with Merant ODBC drivers and had the same error.
>
>Any advice you may have is appreciated.

The obvious advice to enable ODBC tracing and/or sqlnet tracing applies. How to enable sqlnet tracing I have posted numerous times in comp.databases.oracle.server

--
Sybrand Bakker, Senior Oracle DBA