How do I stop dbdsn / dbelevate12 from displaying UAC warning?

[Breck_Carter]

How do I stop Windows 7 UAC from displaying this warning when 12.0.1.3298 dbdsn invokes dbelevate12?

Please don't say "turn off UAC altogether", nothing ELSE in SQL Anywhere is producing this symptom.

[VolkerBarth]

"upload image appears to be broken" - again a missing UAC priviledge:)?

[Breck_Carter]

...very funny 🙂

[VolkerBarth]

More fun than UAC, for sure.

[graeme_perrow]

You need to use the Markdown syntax for embedding an image rather than the img HTML tag. Markdown seems to strip it out.

[johnsmirnios · Accepted solution]

The elevation prompt should only be displayed when you are attempting to perform an operation that requires elevation (eg. creating a System DSN) but not for operations such as creating a user DSN. If you have a case where we are prompting for elevation when we don't need it, that's a bug. Otherwise, this is just how UAC works and it is essentially unavoidable -- you will need to complain to Microsoft.

In Windows 7, Microsoft made a change so that executables digitally signed by Microsoft that require elevation will not issue a prompt if the current user could just click "Yes" to the elevation prompt. To my knowledge, no such provision has been made for other vendors.

As noted, turning off UAC is one option. You can also configure a policy that will automatically say 'yes' to any elevation prompt. Generally, it is only used for automated testing.

-john.

[Breck_Carter · Accepted solution]

bingo... I highlighted the part of your answer that applies... change dbdsn -ws name to dbdsn -wu name.

[Former Member]

It's not very useful from the command line, but for batch files or shortcuts you can avoid the UAC prompt by using the Windows Task Scheduler. See this ZDNet article.