Ponteprimo wrote:One fairly common idea is that a "odbc driver" is standalone, which is wrong.
I've to install ODBC drivers required by a Windows application ( Windesign ).
I've downloaded on Oracle website :No Instant Client odbc package downloaded yet, according to that list. Specially, Jdbc != Odbc.
- ODBC driver - Oracle 10.1.exe
- ODBC driver - Oracle 10.2.exe
- ODBC driver - Oracle 9.01.exe
- ODBC driver - Oracle 9.02.exe
But any of them contains install.exe or something like that !!!...That's correct! The Instant client installer is you, by directions you listed below. For the odbc package, you unzip and then run the odbc_install exe as elevated admin (from a cmd started with Run as administrator).
I've found a doc on the web : " ... copy unzipped files into a folder ( ex.: C:\Oracle\InstantClient ) and add Environment Variables TNS_ADMIN and PATH ) ... "
But while adding ODBC driver with Windows admin tools , only SQL Server is available !!!....On Win x64 you have two Odbc admin tools, one for "native" and one for 32-bit, WoW64. The latter one is found in systemroot\syswow64\odbcad32.exe (via this one you should have a longer list in Drivers tab, for Office apps, Foxpro etc.)
Note : I work on Windows 7 64 bits
Tridus wrote:*64-bit ODAC 11.2 Release 5 (18.104.22.168.20) for Windows x64* installed succesfully.
Try installing the second download on this page: http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html
That one has an installer and will set everything up for you.
[Microsoft][ODBC manager] Architecture uncompatibility between Driver and Application for the specified datasource (DSN)Read my response above. Install the 32-bit packages -- likely your application is 32-bit and needs a 32-bit DSN.
PS : I'm not english fluent ... and I did not undestand all responses. Sorry for that. I do my best.