Include a database in deployment

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • mannik
    #1

    Include a database in deployment

    Hi

    I've made a simple winform with access to an Access database. I work on my machine but when I install the MSI on another machine it looks for the database the wrong place, what would be the workaround

    TI

    Tommy
    Tags: None
    • Dan Brussee
      #2
      Re: Include a database in deployment

      How do you locate the database in code?

      On Sat, 6 Mar 2004 10:51:06 -0800, mannik
      <anonymous@disc ussions.microso ft.com> wrote:
      [color=blue]
      >Hi
      >
      >I've made a simple winform with access to an Access database. I work on my machine but when I install the MSI on another machine it looks for the database the wrong place, what would be the workaround
      >
      >TIA
      >
      >Tommy[/color]

        Comment

        • Chris Vaughn
          #3
          Re: Include a database in deployment

          How are you specifying the connection string? The easiest method is to set
          the connection string in the app.config and have all the data access code
          look here for the connection string. You can then edit the config file to
          point the spot where the MSI puts the access file.

          "mannik" <anonymous@disc ussions.microso ft.com> wrote in message
          news:3BDBC615-D2BD-42B0-98FC-AFEC8EDEA990@mi crosoft.com...[color=blue]
          > Hi
          >
          > I've made a simple winform with access to an Access database. I work on my[/color]
          machine but when I install the MSI on another machine it looks for the
          database the wrong place, what would be the workaround[color=blue]
          >
          > TIA
          >
          > Tommy[/color]


            Comment

            • mannik
              #4
              Re: Include a database in deployment

              I made it with a DataForm wizard and it connects allright, my connection string looks as

              OLE DB:Global Partial Bulk Ops=2,Jet OLEDB:Regesrty path D\Documents and settings....... .. and here is my database. I'v pasted the database to the Solution explore. I don't understand why I don't see the code to my database when I dobbelclick on my form. Where should I look for it

              But I think I found a part of the problem, now I added following files (as I'm not sure which to add) to my installer:
              Primary outpu
              Content File
              Source file
              Localized file

              Now I get another error when I test on pc no.2 it claims that there are a disk or network error. On pc no. 1 it works but this is the pc where I made the projec

              I will be thankfull for all the help I can get

              Tommy



                Comment

                Previous template Next
                Working...