Client unable to establish connection
 

Hi, I created a Excel macro to get the information from
SQL Server using ADO. It runs fine at my computer and
another computer which user has same access to the
database. But when other users run the macro they got the
error:
Run-time error '-2147467259(80004005):
[Microsoft][ODBC SQL Server Driver] Client unable to
establish connection
Please help.
Thanks
Ava