locked
Connection String Issue in Vista as a Non-User RRS feed

  • Question

  • My companies primary product uses MDBs to store test as well as user data. With the release of Vista we redesigned our application using the UAC guidelines provided by Microsoft, writing all data to %ALLAPPDATA% instead pf program files.
    Everything works fine with one major exception, even a hard coded Connection String is redirecting the MDB to [user]\appdata\VirtualStore ... when logged in as a Non-Admin. So basically Admins MDB will be
    %ALLAPPDATA%  in the created folder and Non-Admins [user]\appdata\VirtualStore.

    This is a big deal for us as most of the software is used in a classroom enviorment when students cannot have ADMIN priveledges. I have read in a forum that OLEDB is always redirected (Virtualized) as a NON-ADMIN, I pray this isn't true. I have even created a manifest file with the asInvoker flag with the same results. Everything works fine but the DB in the connection string is always redirected to
    [user]\appdata\VirtualStore. . .
     
    Our new release deadline is Next week.
    I have been a .NET developer for years and am frankly out of ideas.


    stephen@examforce.com

    Thanks in Advance
    Stephen
    Sunday, September 21, 2008 11:56 PM

All replies

  •  

    <table width="425" border="0" cellspacing="0" cellpadding="0"><tr><td><object width="425" height="344"><param name="movie" value="http://www.youtube.com/v/u3UBtRF1xsA&hl=en&fs=1"></param><param name="allowFullScreen" value="true"></param><embed src="http://www.youtube.com/v/u3UBtRF1xsA&hl=en&fs=1" type="application/x-shockwave-flash" allowfullscreen="true" width="425" height="344"></embed></object></td></tr><tr ><td ><a href='http://www.fan2band.com/dl/epitaph/motioncitysound/170653_2156_43_3003'><img src='http://www.fan2band.com/di/epitaph/motioncitysound/170653_2156_43_3003.PNG'  border="0"/> </a></td></tr></table>
    Thursday, October 23, 2008 12:12 AM
  • <!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:1; mso-generic-font-family:roman; mso-font-format:other; mso-font-pitch:variable; mso-font-signature:0 0 0 0 0 0;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-1610611985 1073750139 0 0 159 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin-top:0cm; margin-right:0cm; margin-bottom:10.0pt; margin-left:0cm; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi; mso-fareast-language:EN-US;} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi; mso-fareast-language:EN-US;} .MsoPapDefault {mso-style-type:export-only; margin-bottom:10.0pt; line-height:115%;} @page Section1 {size:612.0pt 792.0pt; margin:70.85pt 70.85pt 70.85pt 70.85pt; mso-header-margin:35.4pt; mso-footer-margin:35.4pt; mso-paper-source:0;} div.Section1 {page:Section1;} -->

    Hi Stephen

    I know you posted for like a year ago, but I have a similar problem regarding MDB's and connection strings. I would like to have my MDB's stored in the Program Files\appname directory, but Vista and Windows 7 frak things up.

    How did you solve your problem? Did you route your connection string to the given VirtualStore folder? Or did you rewrite your code to enable writable MDB's in the given Program Files folder?

    Hope you or someone else answer my question :-)


    Regards,


    Greendaale

    Friday, October 23, 2009 7:59 AM
  • Hello Stephen:

    How is the situation on your side?
    Is this thread solved or NOT?

    We are about to reach year 2010 now, and it's been like 2 years back.
    I think that you have managed to find a good solution to solve a
    problem like this one.

    I hope you can give me a detailed status on this thread (issue)!

    Have a nice day...

    BTW, your problem explaination and your way of posting a question is
    good, congratulations Stephen.

    Best regards,
    Fisnik
    Coder24.com
    Monday, October 26, 2009 6:25 PM
  • Hi Stephen:

    How is the situation on your side?
    Is this thread solved or NOT?

    Please tell me!

    Have a nice day...

    Best regards,
    Fisnik
    Coder24.com
    Friday, November 13, 2009 7:33 PM
  • Hi again:

    How is the situation on your side?
    Is this thread solved?

    Please tell me!

    Have a nice day...

    Best regards,
    Fisnik
    Coder24.com
    Sunday, December 27, 2009 10:25 AM
  • Hi

    We solved the problem by changing directory name our app installed to. Then the VirtualStore directory will be remade and everything worked for us. Another tip is to delete the given virtualstore directory during install of your program.

    Regards,

    greendaale
    • Proposed as answer by greendaale Tuesday, December 29, 2009 10:04 AM
    Tuesday, December 29, 2009 9:30 AM
  • Please mark something as answer so we can close this thread,
    since the problem is solved.
    Coder24.com
    Tuesday, December 29, 2009 10:01 AM
  • PLEASE MARK SOMETHING AS ANSWER SO WE CAN CLOSE THIS THREAD,
    SINCE THE PROBLEM IS SOLVED.


    Coder24.com
    Saturday, January 2, 2010 2:13 PM
  • PLEASE MARK SOMETHING AS ANSWER SO WE CAN CLOSE THIS THREAD,
    SINCE THE PROBLEM IS SOLVED.

    Coder24.com
    Saturday, January 2, 2010 2:13 PM