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

  • Thread starter Thread starter ian.tiesdell
  • Start date Start date
I

ian.tiesdell

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
 
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
Click to expand...


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.

1) set the exe to run with Run As Administrator
2) turn UAC off
3) use the Super Administrator account on Vista to give the Admin full
rights, like it would have on XP when a Admin\user is running an
application on XP, look it up use Google.
 
[email protected] said:
Hi
Click to expand...
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)
Click to expand...
i get the following errors
Click to expand...
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
Click to expand...
it does exist and is error free because i tried the worksheet before
during and after tryng it on Vista
Click to expand...
Any ideas  / pointers would be much appreciated
Click to expand...

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.

1) set the exe to run with Run As Administrator
2) turn UAC off
3) use the Super Administrator account on Vista to give the Admin full
rights, like it would have on XP when a Admin\user is running an
application on XP, look it up use Google.- Hide quoted text -

- Show quoted text -
Click to expand...

Many thanks for your speedy reply - i'll have a look at this (its the
only Vista desktop in the building but it is the CEO's)
 
Back
Top