Re: ORACLE Connection String

While creating the DSN, do not give the password, then it would ask for a password every time your VB program accesses the database first time.
The connect string would be the name of the DSN.

Hope this helps!
Venu G.

"Douglas J. Steele" <djsteele_at_canada.com> wrote in message news:<u3CE6sg9CHA.3208_at_TK2MSFTNGP11.phx.gbl>...
> What's your definition of "hiding" the password?
>
> If you're worried about someone opening the .EXE in an editor and seeing the
> literal string, do something like assigning it to a variable in parts:
>
> strPassword = "my"
> strPassword = strPassword & "Pass"
> strPassword = strPassword & "word"
>
> rather than
>
> strPassword = "myPassword"
>
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
>
>
> "Yanick Hudon" <yannik_at_sympatico.ca> wrote in message
> news:fAgha.7107$FO3.943213_at_news20.bellglobal.com...
> > Hi all,
> >
> > Very interesting for the solution, but there's a mystery in what i
> > want to do.
> >
> > I want to do the samething, but hiding the password in the
> > connection string in VB.
> >
> > Is it possible?
> >
> > Thanks in advance!
> >
> > Tore Bostrup <newspost_at_bostrup.us> a écrit dans le message :
> > OaWyGYc9CHA.1612_at_TK2MSFTNGP11.phx.gbl...
> > > http://www.able-consulting.com/ado_conn.htm
> > >
> > > Tore.
> > >
> > > "Curt Emich" <cemich_at_comcast.net> wrote in message
> > > news:kfWdndTvqb-esBijXTWcrg_at_comcast.com...
> > > > What is the connection string to connect VB to ORACLE?
> > > >
> > > >
> > >
> > >
> >
> >
Received on Mon Mar 31 2003 - 18:01:49 CEST