Re: deployment and database location

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Ben (Ben_at_discussions.microsoft.com)
Date: 07/17/04 

Date: Sat, 17 Jul 2004 06:53:02 -0700

Ok
Here are the two strings I now use

Con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Replace(Application.StartupPath, "bin", "") & "Book.mdb"

This one below is the one to which there is a dataset attached and the code is copied from in the Windows Form Designer generated code area:

Me.odcBooks.ConnectionString = "Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database L" & _
        "ocking Mode=1;Data Source=""C:\Documents and Settings\My Name\My Documents\V" & _
        "isual Studio Projects\About My Books\Books.mdb"";Jet OLEDB:Engine Type=5;Pro" & _
        "vider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System database=;Jet OLEDB:SFP=False;p" & _
        "ersist security info=False;Extended Properties=;Mode=Share Deny None;Jet OLEDB:E" & _
        "ncrypt Database=False;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't Cop" & _
        "y Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;User ID" & _
        "=Admin;Jet OLEDB:Global Bulk Transactions=1"

"One Handed Man ( OHM - Terry Burns )" wrote:

> Post your connection strings and tell us where the databse is in reality (
> path \\servername\share\dbname )
>
>
>
> --
>
> OHM ( Terry Burns )
> . . . One-Handed-Man . . .
>
> Time flies when you don't know what you're doing
>
> "Ben" <Ben@discussions.microsoft.com> wrote in message
> news:08F6AD36-E9D8-487E-9338-0EA0971035EB@microsoft.com...
> > Hi all
> > I have made a vb.net windows app that works great in design. But after
> deploying the app on the same design computer (my own) the app can not find
> any of the two databases it needs to operate. I have tried setting their
> connection strings to application.startupath, but with no luck.
> > My question is, what is the correct way to code a connection string so
> that it will be seen by the app on any computer when deployed, especially
> when one of the databases has a dataset.
> > Right now I have a copy of both databases in the application folder and in
> the bin and debug folders for testing and they are still not found by the
> ..exe
>
>
>

Relevant Pages

  • Re: [Lit.] Buffer overruns
    ... plausible designs for handling character strings ... and arbitrary data buffers. ... strings have more space overhead than terminated ... existing design or be custom-tailored as you see ...
    (sci.crypt)
  • Exceptions
    ... determine if I will use either feature for a game-console application. ... strings to fulfill it's function regardless of whether the app is ... The best implementations of exception handling ...
    (comp.lang.cpp)
  • Re: Is the following little function UNICODE-safe? ...
    ... You will not be able to fit 500,000,000 4-byte strings into memory. ... extensions and assumes it can store three characters in a DWORD, ... pointer to a local variable, which is a fatal design error, as I already pointed out. ...
    (microsoft.public.vc.mfc)
  • Re: suhr bass
    ... None of those are serious "design" flaws. ... As for the strings and foam ... combined with the single coil pickups in strats and jazz basses mean ... bass guitar manufacturer, ...
    (alt.guitar.bass)
  • Re: another whammy/tremolo issue & headstocks
    ... the design of the headstock. ... This would seem to be a sleeker design for strings to move through. ... It's a straight path through the nut. ...
    (alt.guitar)