Automating Oracle Login

[kashew]

Does anyone know how to code an automatic login to Oracle i.e. username and password from Access?

 

[smedvid]

I would think you could create a connect string that fires on the login or main menu page. But, there may be an issue with timeout on Oracle if a user sits idle for x minutes. But, use caution when hard-coding passwords! It is not a good idea and I always try to avoid it.

Set tdfLinked = _
dbsCurrent.CreateTableDef("AuthorsTable&quot
tdfLinked.Connect = _
"ODBC;DATABASE=pubs;UID=sa;PWD=;DSN=Publishers"
Steve Medvid
"IT Consultant & Web Master"

http://users.erols.com/medvid/

 

[GEBuckeye]

Just curious...if there is not a security issue...why don't you set it up through the registry setting for the oracle's 'System DSN'? Regedit, HKEY_LOCAL_MACHINE, SOFTWARE, ODBC, ODBC.INI add the string value 'Password' (case sensitive) and edit it for the 'password'. If security is an issue I apologize or if the application is used by many others it may not be practical.