Oracle数据库密码 [英] Oracle database password
问题描述
版本：MSAccess 2003 SP2
Explination：我有一个连接到oracle数据库的数据库。我已在ODBC源管理器中的系统DSN选项卡下设置ODBC连接。我第一次转到包含oracle表中字段的表单时，Oracle ODBC Driver Connect窗口出现，应该如此。输入密码并继续使用数据库后，该窗口将再次出现。如果我在注册表中输入密码Oracle ODBC Driver Connect，窗口永远不会出现。
系统DSN设置的属性：
数据源名称：PCMS_ORGLEADER_VW
TNS服务名称：COLPR1
用户ID：PCMS_COLWH_PTC
驱动程序：OraHome92中的Oracle（Oracle 9.2）
问题：如何传递给oracle数据库密码，无需在Oracle ODBC Driver Connect中手动输入密码。窗口或将密码放在注册表中？你用什么代码？我不希望用户记住密码，我不想修改使用该数据库的所有计算机上的注册表。
< blockquote class =post_quotes>
版本：MSAccess 2003 SP2
Explination：我有一个连接到oracle数据库的数据库。我已在ODBC源管理器中的系统DSN选项卡下设置ODBC连接。我第一次转到包含oracle表中字段的表单时，Oracle ODBC Driver Connect窗口出现，应该如此。输入密码并继续使用数据库后，该窗口将再次出现。如果我在注册表中输入密码Oracle ODBC Driver Connect，窗口永远不会出现。
系统DSN设置的属性：
数据源名称：PCMS_ORGLEADER_VW
TNS服务名称：COLPR1
用户ID：PCMS_COLWH_PTC
驱动程序：OraHome92中的Oracle（Oracle 9.2）
问题：如何传递给oracle数据库密码，无需在Oracle ODBC Driver Connect中手动输入密码。窗口或将密码放在注册表中？你用什么代码？我不希望用户记住密码，我不想修改使用此数据库的所有计算机上的注册表。
您可以在这里查看大多数参考资料的绝佳来源。
http://www.connectionstrings.com/?carrier=oracle
J
< blockquote>你有没有弄清楚要放入Access的语法来通过Oracle的密码窗口？
你看过Post＃2中的链接了吗？
Version: MSAccess 2003 SP2
Explination: I have a database that connects to an oracle database. I have setup an ODBC connection under the System DSN tab in the ODBC Source Administrator. The first time I go to a form that has fields from the oracle table, the "Oracle ODBC Driver Connect" window appears, as it should. Once I type in the password and continue with the database, that window never appears again. If I enter the password in the registry the "Oracle ODBC Driver Connect" window never appears.
Properties of System DSN setup:
Data Source Name: PCMS_ORGLEADER_VW
TNS Service Name: COLPR1
User ID: PCMS_COLWH_PTC
Driver: Oracle in OraHome92 (Oracle 9.2)
Question: How can you pass to the oracle database the password without manually typing it in the "Oracle ODBC Driver Connect" window or putting the password in the registry? What code do you use? I don''t want the user to remember a password and I don''t want to modify the registry on all the computers that use this database.
Version: MSAccess 2003 SP2
Explination: I have a database that connects to an oracle database. I have setup an ODBC connection under the System DSN tab in the ODBC Source Administrator. The first time I go to a form that has fields from the oracle table, the "Oracle ODBC Driver Connect" window appears, as it should. Once I type in the password and continue with the database, that window never appears again. If I enter the password in the registry the "Oracle ODBC Driver Connect" window never appears.
Properties of System DSN setup:
Data Source Name: PCMS_ORGLEADER_VW
TNS Service Name: COLPR1
User ID: PCMS_COLWH_PTC
Driver: Oracle in OraHome92 (Oracle 9.2)
Question: How can you pass to the oracle database the password without manually typing it in the "Oracle ODBC Driver Connect" window or putting the password in the registry? What code do you use? I don''t want the user to remember a password and I don''t want to modify the registry on all the computers that use this database.You might check here for an excellent source for most all references.
http://www.connectionstrings.com/?carrier=oracle
J
Did you ever figure out the syntax to put into Access to get past the password window for Oracle?
Did you check out the link in Post #2?
这篇关于Oracle数据库密码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
