| Title: | DEC ODBC Driver |
| Notice: | DEC ODBC Driver V2.0 Now Available |
| Moderator: | SQLSRV::MAVRIS |
| Created: | Tue Dec 29 1992 |
| Last Modified: | Fri Jun 06 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 1357 |
| Total number of notes: | 4864 |
Windows NT 4.0 Workstation ODBC 3.0 Oracle RDB ODBC driver 2.10.1100 SQL/Services V6.0 RDB V4.2-1 Using either Access 97 or Visual InterDev 1.0, I am always prompted for a password for the RDB ODBC data source the first time I run the application. According to the on-line help for Access, the password is supposed to be saved after the first login, and I presume that I shouldn't have to re-enter it ever again, until the password is changed. With Visual InterDev, I can see that the password is in fact being saved in global.asa, however it too prompts for the password. How do I configure it such that the password is NEVER prompted for, unless the login fails? The reason I need this is that I want my web server application (which uses ADO) to be able to connect to a remote RDB data source - to do that it must be able to pass a pre-entered password to the RDB host machine without prompting. Thanks, Greg. p.s I have enabled "proxy access" in my RDBODBC.INI - that didn't help.
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 1348.1 | web server application works - I'm out of the pooh | ORAREP::TURRIS::16.172.240.185::sullivan | Wed May 28 1997 06:05 | 20 | |
Well, it looks like the problem, if it is a problem, is in the applications (Access & Visual InterDev) themselves - the web server connects to the RDB data source without any problems. I think the applications are forcing a password prompt the very first time the data source is accessed in a session, even though the password is stored in the applications. I am still interested to know whether I can prevent the prompting from Access (Visual InterDev isn't so important - as long as the application I *create* with VID works properly, I'm happy). Thanks, Greg. p.s Just by the way, the web server where the aforementioned application is running (properly) is NT 4.0 Server on Alpha, which also has the same version of ODBC and the Oracle RDB ODBC driver. | |||||
| 1348.2 | ORAREP::TURRIS::16.172.240.185::sullivan | Wed May 28 1997 06:07 | 5 | ||
BTW, I can't tell you how pleasantly surprised I was to find that an Alpha NT version of the RDB ODBC driver was available - thanks! :) Greg. | |||||