[wix-users] Deploying access database file with Wix

[Habib Salim]

How is your application connecting to the database?
What does your application.exe.config file say?


-----Original Message-----
From: wix-users [mailto:wix-users-bounces at lists.wixtoolset.org] On Behalf
Of Roopendra Gowlikar
Sent: Friday, August 18, 2017 8:52 AM
To: WiX Toolset Users Mailing List <wix-users at lists.wixtoolset.org>
Subject: Re: [wix-users] Deploying access database file with Wix

Yeah, I did copied accdb file to installation location("C:\Program Files
(x86)\MyApplication")
but after installation application is reading from "C:\Windows\System32"
which wrong. I copied file to system32 folder too, till it says
access.accdb file can find.

My application is windows application and accdb as database and app is
reading from application.exe.config.
Each install has its own database. Below is my wix code


<?define xyz_TargetDir=$(var.xyz.TargetDir)?>

    <Feature Id="ProductFeature" Title="xyz" Level="1">
      <ComponentGroupRef Id="ProductComponents" />
      <ComponentRef Id="ApplicationShortcut" />
      <ComponentRef Id="ApplicationShortcutDesktop" />
    </Feature>

  <Fragment>
    <Directory Id="TARGETDIR" Name="SourceDir">
      <Directory Id="ProgramFilesFolder">
        <Directory Id="INSTALLFOLDER" Name="xyz" />
      </Directory>
      <Directory Id="ProgramMenuFolder">
        <Directory Id="ApplicationProgramsFolder" Name="xyz"></Directory>
      </Directory>
      <Directory Id="DesktopFolder" Name="Desktop"></Directory>
    </Directory>
  </Fragment>

<Fragment>
<ComponentGroup Id="ProductComponents" Directory="INSTALLFOLDER">
      <Component Id="xyz.accdb" Guid="GUID">
        <File Id="xyz.accdb" Name="xyz.accdb"
Source="$(var.xyz_TargetDir)xyz.accdb" />
      </Component>
</ComponentGroup>
</Fragment>


On Fri, Aug 18, 2017 at 8:25 AM, Habib Salim <habib at hsalim.com> wrote:

> You can simply copy the mdb or accdb file just like other application 
> dependencies/dlls.
> How is your application referring to the access database?
> Application.exe.config?
> Are multiple users connecting to the one database or does each install 
> have its' own database?
>
>
> -----Original Message-----
> From: wix-users [mailto:wix-users-bounces at lists.wixtoolset.org] On 
> Behalf Of Roopendra Gowlikar
> Sent: Friday, August 18, 2017 8:17 AM
> To: WiX Toolset Users Mailing List <wix-users at lists.wixtoolset.org>
> Subject: [wix-users] Deploying access database file with Wix
>
> Hello,
>
> Does anyone know how to deploy access database file using wix.
> Any pointer would be greatly appreciated.
>
> Thanks
>
> ____________________________________________________________________
> WiX Toolset Users Mailing List provided by FireGiant 
> http://www.firegiant.com/
>
> ____________________________________________________________________
> WiX Toolset Users Mailing List provided by FireGiant 
> http://www.firegiant.com/
>

____________________________________________________________________
WiX Toolset Users Mailing List provided by FireGiant
http://www.firegiant.com/