Vista - Msquery MsExcel and SQL data works in XP but not in VISTA



Hi

i have an excel workbook that opens an msquery to a SQL database in
auto_open macro. This is made available via Sharepoint to our users,
the problem is running it on a Vista PC. Tt work fine with the many
XP pc's in the company, unfortunately the CEO has Vista and it
doesn't
work (the trusted location is set in Excel)


i get the following errors


connection failed
SQLState: '01000'
SQL Server Error:5
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
(Connect())
Connection failed
SQLState: '08001'
SQLServer Error 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not
exist
or access denied


it does exist and is error free because i tried the worksheet before
during and after tryng it on Vista


Any ideas / pointers would be much appreciated


Ian

.