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

Posted: 09-21-2008, 09:03 PM
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

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


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

Paul Montgumdrop
Guest
Posts: n/a
 
Re: Vista - Msquery MsExcel and SQL data works in XP but not in VISTA
Posted: 09-21-2008, 09:24 PM
ian.tiesdell@hotmail.co.uk wrote:
> 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

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.
ian.tiesdell@hotmail.co.uk
Guest
Posts: n/a
 
Re: Vista - Msquery MsExcel and SQL data works in XP but not in VISTA
Posted: 09-22-2008, 03:30 AM
On Sep 22, 9:24*am, Paul Montgumdrop <P...@Montgumdrop.com> wrote:
> ian.tiesd...@hotmail.co.uk wrote:
> > 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
>
> 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 -
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)
 
LinkBack Thread Tools Display Modes
 


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


Similar Threads
Thread Thread Starter Forum Replies Last Post
VPN works with XP / not VISTA audin Windows Vista Networking & Sharing 6 04-19-2008 04:27 PM
Nothing works with Vista?!?!? Pheonix 1233412412 Windows Vista Hardware & Devices 5 07-10-2007 08:24 PM
Vista Ulitimate 64 ~ Media Center works with Hauppauge HVR 1600, or Vista has 4MB memory . Not both. Robert Windows Vista Hardware & Devices 0 04-14-2007 08:29 PM
Migrating data from vista RC2 to Vista Home Premium Mike Windows Vista File Management 1 02-13-2007 01:33 AM
using msquery\office 10.x need to see sql views not tables Steve Mac Office Excel 2 09-27-2004 01:40 PM