CODEWITHSUNDEEP
windowsoracle-databaseoracle11godbc
yegomosc
yegomosc

Reputation: 85

How to update Oracle ODBC driver in Windows and all existing ODBC sources

I would like to update Oracle ODBC driver on Windows 2008 R2 64bit Machine from version 11.2.0.1 to 11.2.0.4. I downloaded from http://www.oracle.com/technetwork/topics/winx64soft-089540.html: (version 11.2.0.4)

Then unzipped two files, merged them into one folder and then from CMD line with administrative privileges run script:

odbc_install

Then I was able to see the driver on the list in ODBC driver in 'Microsoft ODBC Administrator'.

The problem is that I would like that all exsting configured System DSN which use 11.2.0.1 Oracle driver should be updated with 11.2.0.4 version.

Could you please advise me what steps I should take to achieve it.

Best regards Daniel

Upvotes: 0

Views: 6655

Answers (1)

Wernfried Domscheit
Wernfried Domscheit

Reputation: 59557

You can do it directly in your Registry. ODBC Drivers are located at:

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\{Oracle Home Name}\Driver    
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\{Oracle Home Name}\Driver

Check and update following values:

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\{Your DNS Entry}\Driver    
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\{Your DNS Entry}\Driver    
HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\{Your DNS Entry}\Driver

Upvotes: 1

Related Questions