Re: hard code the database path in connection string

From: MikeB (m.byerleyATVerizonDottieNettie)
Date: 02/16/05 

Date: Wed, 16 Feb 2005 12:58:52 -0500

"Veign" <NOSPAMinveign@veign.com> wrote in message
news:Oj7cFwEFFHA.1296@TK2MSFTNGP10.phx.gbl...
> Options: Make it a setting that the user can change or Use a DSN where the
> DSN name would be in code and the DSN setup would control the access to the
> database.

I believe the most trouble free would be DSN-Less and the path in an INI
file....

> --
> Chris Hanscom - Microsoft MVP (VB)
> Veign's Resource Center
> http://www.veign.com/vrc_main.asp
> --
>
> "Newbee Adam" <NewbeeAdam@discussions.microsoft.com> wrote in message
> news:225C6091-8E34-4B7E-82AE-EADBD63C96B3@microsoft.com...
> > my front end vb6 app will be distributed to users in a corpoarate office.
> the
> > front end will connect to an access 2000 db on shared common company
> drive.
> >
> > How do I make it so by default it points to for example drive
> > G:\Common\GroupLookUp.mdb
> >
> > but if some knuckle head down the road deletes or moves the database or
> > names their mapped drive L: for example, how can I make an error not come
> up
> > but yet a drive dialog box comes up and asks them where to find the
> database.
> >
> > I already have the code for this it is in the error handler code, but I do
> > not want this
> > file/drive dialog box to come up everytime. How can I save the path info
> > once the user changes it. With my limited experience, I can only think to
> > savethe path string in a .dat ot txt. file and replace the path variable
> > everytime. opening, writing, closing the file every time.
> >
> > Am I taking the wrong approach. Is there a much simpler solution or am I
> or
> > the right track.
> > thanks!!
> > --
> > Adam S
>
>

Relevant Pages

  • Re: opening an Access 2000 DB using ODBC...
    ... > app directly as opposed to referenceing the DSN of say an ODBC driver and ... Database connectivity has been a changing ... DSN files allows your app to not have to know much about 'how' ...
    (microsoft.public.vb.database)
  • Re: Word could not reestalish a DDE connection to ACCESS DB
    ... Because it is asking for DDE connection and I can't seem to figure out why ... I have create a DSN (a user DSN in adminstrative tools - data ... DSN) adding the access database - IQE and tried in word to access this ... source but it still comes up with it cannot find the datasource and ...
    (microsoft.public.word.mailmerge.fields)
  • Re: MySQL on Win 98
    ... Hitting the Verify Connection button in VFP produced a C5 crash. ... With a "System" DSN configured the same way (except for the Data ... Incorrect database name". ...
    (microsoft.public.fox.programmer.exchange)
  • RE: DBD::DB2 question need an example
    ... list database directory ... LI0124E Invalid argument value. ... can you run the following commands from the DB2 CLP ... means that DB2 is not liking something about your $dsn. ...
    (perl.dbi.users)
  • RE: Run-time error 3011 using Foxpro ODBC
    ... it is enough to just mention the DSN. ... -The constant acTable is ignored unless the database source type is MS ... Dim strConnect As String ... DoCmd.TransferDatabase acImport, "ODBC Database", strConnect,, ...
    (microsoft.public.data.odbc)