Excel error connecting to sqlserver using ADODB, but can thru Data menu

[Sam]

(I also posted this in the Excel programming group)

We have an excel sheet that connects and pulls data from SQL Server
2005. We want to format and change the data a little before filling
the sheet. This is why we use ADODB within the macros.

We are getting the following error when we try to connect to the
database:

Runtime Error '-2147220999(800401f9) Method 'Active Connection'
of object _Command failed

However we are able to pull data using the "Import External Data"
option from the Data Menu of excel.

Our customer is actually having this problem. For other customers the
ADODB connection works fine.

This particular customer is running Windows 2003. We have made sure
they have the latest MDAC.

Anyone have any ideas of what we can look for?

Thanks....