User Tools

Site Tools


oracle:dsnwithnopasswordasking

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
oracle:dsnwithnopasswordasking [2011/10/03 16:59]
rlunaro
oracle:dsnwithnopasswordasking [2014/12/24 10:42] (current)
Line 1: Line 1:
 +====== Configure an ODBC Data Source with no password request ======
 +
 +===== Intro =====
 +
 +When working with access, or whatever application,​ it's an annoying thing that everytime we open an Oracle linked table it request the password of the connection. ​
 +
 +Moreover, if you try to make any sort of application (macro, visual basic, etc.), because this password is requested interactively,​ stops the application of working until a correct password is provided by the user. 
 +
 +I've discovered two ways to circunvent this issue.
 +
 +===== First: use the oracle driver and provide the user and password in the user field =====
 +
 +Ok, you have to go to ye old Data Source Administrator and begin to create a new Data Source by clicking the button "​Add":​
 +
 +{{:​oracle:​a.png?​nolink|}}
 +
 +Select the Oracle driver (you can download it from the [[http://​www.oracle.com|Oracle website]]:
 +
 +{{:​oracle:​b.png?​nolink|}}
 +
 +And, in the configuration of the data source, in the user ID field, provide '​user/​password'​ separated with a slash (see image), like when connecting with ye old ''​sqlplus'':​
 +
 +{{:​oracle:​c.png?​nolink|}}
 +
 +And that's all: you will never have to provide a password when using this datasource. Easy, uh??
 +
 +===== Second: edit the registry and provide the password in the appropiate field =====
 +
 +All the datasource information is saved in the following registry folder:
 +
 +<​code>​
 +
 +HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI
 +
 +</​code>​
 +
 +But alas!!! there is a ''​password''​ or ''​pwd''​ field among the contens.... suspecting, isn't it??? I've never test it, but it deserves a try, and to this point is my saying: from this point you have to explore yourself. ​
 +
 +
 +
 +
 +
 +
 +
  
oracle/dsnwithnopasswordasking.txt ยท Last modified: 2014/12/24 10:42 (external edit)