Re: Oracle 7.3 links in Access95 mdb with a VB front end - how to set ODBC user/password

Well you have to remember that if you linked these but didn't save the password then you are going to get this. you should really change this to an app that creates a workspace object(odbcdirect)
then creates a database objects. then uses a connect string to connect the tables. This way you could pass the username and password. all odbc compliant databases allow for passing of a username and password at this time.

Syd Kahn <klass_at_netrax.net> wrote in article <3339AD86.F33_at_netrax.net>...
> I think I have enough pieces glued together. A bunch of Oracle 7.3
> database links in an access MDB - did it that way for speed and a good
> place to store a bunch of queries. It all is being used from a VB front
> end.
>
> Now for the problem. Whenever I use the first table - the "Login on to
> Oracle" msgbox pops up for username and password. After clicking on OK
> the msgbox closes and turns the cursor from an hourglass to the default
> pointer. Nothing I do in VB can stop this - because I have no control
> until the odbc call finishes. Trouble is that call can take a minute or
> two - which the user interprets as a frozen program.
>
> I would like to set the Oracle user/password in VB to stop the oracle
> default login dialog - but don't know how to set the oracle password.
> There is no place to set it. If you set the dbengine.defaultPassword -
> it is for the Access MDB not oracle. I know that there is a connect
> string in the link stored in access, but I am leary of setting that
> property because if I do it wrong - it will hose the app.....
>
> Any Ideas??????
> Stuck In Gettysburg
> Syd
>
  Received on Thu Mar 27 1997 - 00:00:00 CET