🚀 go-pugleaf

"Clayton Arends" <nospam_claytonarends@hotmail.com> wrote:
>I'm not as versed in ADO as with the rest of the VCL but I know enough to be 
>dangerous.

:). I thought I was good, but then I've never had any problems until trying our apps in Vista.

>> We lock/freeze when we run the app in debugger, with UAC turned off
>> completely or turned on - deson't seem to matter.
>
>If you lock when you run the app then try running BCB6 as administrator. 
>This is what I have to do when I debug administrative applications.

Same problem with BCB6 run as administrator and BCB6 run with UAC turned off.

>> It's an MS SQL app using ADO to connect with it.
>
>To eliminate the UAC and administrative privileges have you tried connecting 
>via a plain Jet connection yet?  If even that doesn't work then I'm afraid 

?  Not sure what you mean by this.  Other apps built against -*roughly*- the same library but using Visual Studio & .NET using -*roughly*- the same ADO Connection (Almost verbatum the above string + "MultipleResultSets=true") string work fine in Vista.

>I'd be out of ideas since that's about as general a connection as one can 
>create using ADO.  The only step at that point would be to make sure you 
>have all of the correct drivers installed.
>
>If the Jet connection succeeds then we can move to the next step?  Have you 
>added a Vista manifest resource to your application yet?  If not, here is 
>the resource that I use which tells Vista to run the application with 
>administrative privileges:
>
><?xml version="1.0" encoding="UTF-8" standalone="yes"?>
><assembly xmlns="urn:schemas-microsoft-com:asm.v1" manifestVersion="1.0">
>  <trustInfo xmlns="urn:schemas-microsoft-com:asm.v3">
>    <security>
>      <requestedPrivileges>
>        <requestedExecutionLevel level="requireAdministrator" />
>      </requestedPrivileges>
>    </security>
>  </trustInfo>
></assembly>
>
>If you need a RES file for that let me know and I'll email it (or put in 
>.attachments).

You can e-mail it to the e-mail above or post it to .attachments and I'll try to get it from there.  Or point me to what I'd need to know to turn the above XML into an .RES that I can include with/in my BCB6 app...

>>  Provider=SQLOLEDB.1;Integrated Security=SSPI;Data Source=MyServer;
>>  Initial Catalog=MyDB;
>
>Do you have a SQLServer database that doesn't require integrated security? 

:). No we considered that 'evil' and opted to control completely access using the Active Directory on our Domain.

>Try using a standard username and password logon and see if that can get in. 
>That's the way we have our SQLServer connections set up here (we haven't gotten too fancy with security settings yet).
>

Thanks for your help.  We'll re-try a few of these things to see if we get further and keep you posted.  I'd really like info on how to add the admin XML via RES to our BCB6 apps, or an .RES that we can include in our applications.

George