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