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

.

Relevant Pages

  • Re: Vista - Msquery MsExcel and SQL data works in XP but not in VISTA
    ... i have an excel workbook that opens an msquery to a SQL database in ... unfortunately the CEO has Vista and it ... I would say the Excel.exe is not running with Run As Administrator to give it the needed privileges on Vista during a privileged escalation process. ...
    (microsoft.public.windows.vista.security)
  • PivotTable (No actions defined)
    ... I have defined Actions on my OLAP Server and when I try to access these ... actions from my Excel workbook on Vista the actions are not shown and it ... go to the specified URL. ...
    (microsoft.public.excel.misc)