Re: Connection to SQL Server on Vista

First, my VB6 app is able to connect to a database on Vista, but I use a
connection string without "UID=", and I specify the server with
"SERVER=MyComputer", even if is the local machine.

If the database requires administrator privileges, then you must run the app
by right clicking and selecting "Run as administrator". If you are already
logged in as Administrator, the app will run with the correct privileges.
Otherwise you will be prompted for administrator privileges. On Vista it
does not matter that you are logged in as administrator. What you describe
seems to indicate that what your vb6 app is attempting to do requires
administrator privileges.

--
Richard Mueller
Microsoft MVP Scripting and ADSI
Hilltop Lab - http://www.rlmueller.net
--

"vovan" <v@xxxxx> wrote in message
news:%23yAmkphYIHA.5160@xxxxxxxxxxxxxxxxxxxxxxx
After I turned UAC off everything started to work.
Is there any way to work with UAC ON?

Thank you
vovan

"vovan" <v@xxxxx> wrote in message
news:e%23jRhPhYIHA.4476@xxxxxxxxxxxxxxxxxxxxxxx
I have VB6 application which connects to SQL Server 2000 (installed on the
developer machine) database.
I use this code to connect:
strConnectionString = "DRIVER=SQL
Server;SERVER=(local);UID=;DATABASE=Coordinator;Trusted_Connection=Yes"
objConn.Properties("Extended Properties") = strConnectionString
objConn.Open

Everything works fine on Windows XP
I installed everything I need on my laptop with Vista Business and tried
to run my application.
I'm getting an error saying 'Login failed for user
'NameOfMyLaptop\MyName'

I installed everything I need on the same laptop but I replaced Vista
with XP. Everything works.

So, the only difference I see it's OS.

Any suggestion please

Thank you

vovan






.

Relevant Pages

  • CWinApp::RegisterShellFileTypes() broken in Vista
    ... Actually, it seems that CWinApp::RegisterShellFileTypeswas always broken if the application did not have administrator privileges, but this will be far more common in Windows Vista, because the default account type does not give administrator privileges to ordinary programs. ... But for writing, the value is always written to the HKLM hive unless the HKCU key is present, in which case it is written there. ... So if the keys are not present in HKCU, CWinApp::RegisterShellFileTypeswill attempt to write to HKLM, which a standard user cannot do. ...
    (microsoft.public.vc.mfc)
  • Re: Totally odd
    ... I fired up a VB6 app, referenced Microsoft Speech Object Library and it runs perfectly. ... you could try Vista 32 bit in a VPC and install dragon dictate or whatever the customer has on their PC. ... The funny thing is even though your code doesn't work on Vista without installing the speech SDK, Vista actually includes a voice synthesizer already. ...
    (microsoft.public.vb.general.discussion)
  • Re: error #0X80245003
    ... Hating Vista wrote: ... If you are running Vista, you have to enable your Administrator privileges ... I have Windows Vista Ultimate. ...
    (microsoft.public.windowsupdate)
  • Re: Failed nidaq adaptor registration
    ... Are you on Windows XP or Vista? ... do you have Administrator privileges? ... have a admin log in and do the registration. ...
    (comp.soft-sys.matlab)
  • Re: Hi
    ... Every VB6 app I have tried works fine on Vista. ... However, virtually all setup ... programs fail unless they are Vista aware. ...
    (microsoft.public.vb.general.discussion)
Loading