God morning!
I 've just installed SQL Server 2005 on Windows 2003 Server 64 bit. One of my databases need to connect to seveal Oracle databases.
- I tried installing 64 bit Orcale 9 on this server. Got a strange message that the application (Oracle 64 bit) could not be installed on a 32 bit server! Strange!
- I installed Oracle 9 32 bit on the server, but I could not find ODBC driver in the Data sources! Neither the oledb under providers in MSS Manager Studio!
- Same result efter several desintall and installation. A college copied the .dll files och run a script to register the dll files. We could then se the Oracle driver in the Database sources, but we could not create any connection.
- We have even tried an 10G version of Oracle with the same result.
Is there anyone who succeeded installing Oracle on 64 bit Windows and could create odbc connection/linked server?
Regards
I am in the same situation. Have you been able to find a solution?Thanks,
Derek|||
Unfortunetly not :(
I have posted this issue on several forums including Oracles site. We are going to leave that database which demand linked servers to Oracle on the 32 bit server. I am going to install SQL Server 2005 on that server later. But I am still hoping for some solution to this delicate problem.
|||On 64 bit Windows you have seperate 32 bit and 64 bit ODBC worlds. There is no thunking between 32 and 64 bit components as there was between 16 and 32 bit. To work with 32 bit drivers you need to run the 32 bit ODBC administrator C:\WINDOWS\SysWOW64\odbcad32.exe|||
Oh!
Was it that simpel! Thanks for your answer. I could set up my odbc links, but I could't find Oracle oledb provider under linked servers.
Do you have a tip on that?
|||
Please note that there is no 64bit version of the Microsoft Oracle OLEDB provider but there is a 32bit version on the box that can be used by 32bit applications.
To use linked servers on 64bit, you might want to consider installing/using the Oracle supplied OLEDB provider if any.
Regards,
Uwa.
|||Hi!
I managed fixing thanks to tips from Ron (http://www.dbforums.com/showthread.php?p=6242791#post6242791) by downloading and installning "Oracle Database 10g Release 2 (10.2.0.1.0) for Microsoft Windows (x64)" from Oracle download page.
I could set up odbc links and linked servers in my x64 box.
Thanks, everyone who replied to my questions.
|||Maybe I did this wrong, but what I tried (on WindXP 64-bit) was...
1. Load Oracle 10.2.0.1.0 64-bit Enterprise in OraHome and create a sample database.
2. Load Oracle 10.2.0.1.0 32-bit Client in OraClient, with base install and Windows extensions (ODBC, OLE, etc.)
However, when I open C:\Windows\SysWOW64\odbcad32.exe (the 32 Bit ODBC administrator, I saw the Oracle driver for OraClient, but could not create a DSN for the sample OraDB in the 64-bit OraHome.
Can someone point me in the right direction?
Thanks.
- Will
|||When you say you couldn't set up a DSN, could you give a bit more detail about how you tried to do this and what happened (esp in terms of error messages). Thanks.
|||
Hi!
I hade a wrong version av Orcale installation at that time!
When I couldn't install the 64 version av Oracle. I got a meeage that said something like my Windows installation was not 64 bit!
Then I tried installong the 32 bit version. After that couldn't I see the odbc driver for Oracle in 64 bit odbc. At that time could I however fix my odbc source by running the 32 version av odbc! C:\Windows\SysWOW64\odbcad32.exe
But installing the 32 version av Orcale didn't help my fixing linked servers. There was no oledb driver avaible for 64 bit version of SQL server 2005!
I deinstalled Oracle 32 bit, downloaded x64 version av Oracle (after a tip from some one in the forum). The 64 bit version which I tried to install was for Itanium. I had AMD! I manage downloading X64 which is for AMD ("Oracle Database 10g Release 2 (10.2.0.1.0) for Microsoft Windows (x64)") from Oracle download page.
|||
Hi!
I hade a wrong version av Orcale installation at that time!
When I couldn't install the 64 version av Oracle. I got a meeage that said something like my Windows installation was not 64 bit!
Then I tried installong the 32 bit version. After that couldn't I see the odbc driver for Oracle in 64 bit odbc. At that time could I however fix my odbc source by running the 32 version av odbc! C:\Windows\SysWOW64\odbcad32.exe
But installing the 32 version av Orcale didn't help my fixing linked servers. There was no oledb driver avaible for 64 bit version of SQL server 2005!
I deinstalled Oracle 32 bit, downloaded x64 version av Oracle (after a tip from some one in the forum). The 64 bit version which I tried to install was for Itanium. I had AMD! I manage downloading X64 which is for AMD ("Oracle Database 10g Release 2 (10.2.0.1.0) for Microsoft Windows (x64)") from Oracle download page.
I did not install the Oracle database however. I ran the custom installation together with our Oracle expert. We insatalled ODBC, Oledb, ... After that I could find both drivers under the 64 bit version of ODBC and under linked servers in SQL Server 2005.
Try that!
Good luck!
|||This *IS* possible and have now done it with assist from Oracle tech support.
1. Install 64-bit 10.2.0.1 Database into OraDb_home.
2. Install 32-bit 10.2.0.1 Client (needs Windows ODBC extensions) into OraClient_home.
3. Apply patch 5500954 for 64-bit - this is a Critical Bug patch 8 for 64-bit.
4. Apply patch 5337014 for 32-bit - this is a patchset to upgrade the Client to 10.0.2.0.3.
5. Contrary to what Oracle note 334528.1 says (which is to patch the 64-bit Server), you must patch/upgrade the 32-bit client as well (otherwise, it still fails).
Also, DataDirect's Connect Ver 5.2 ODBC Oracle "wire-driver" (32-bit version) will work without installing the OraClient at all.
- Will
|||Hi!
Thanks for your reply. I wonder why I should "Install 32-bit 10.2.0.1 Client (needs Windows ODBC extensions) into OraClient_home."?
You need to install two Oracle homes and a database to access, like...
1. The 64-bit database into C:\Oracle\Database - and call the OracleHome instance OraDatabase.
2. The 32-bit client (a whole administrative install) into C:\Oracle\Client - and call the OracleHome instance OraClient.
3. The 64-bit Oracle database ORCL.
(Do NOT try to install into "C:\Program Files\Oracle"... or its "short" equivalent C:\Progra~1\Oracle as the OPatch utility will NOT parse either of these properly)
Take the sqlnet.ora, listener.ora, and tnsnames.ora files from C:\Oracle\Database\Network\Admin and copy them to C:\Oracle\Client\Network\Admin.
At a minimum, the following Services need to be operating from the database...
1. OracleOraDatabaseTNSListener
2. OracleServiceORCL
Lastly, the note above describing the use of the 32-bit 10.3.0.1 does NOT note that there has turned out to be a bug in the sqora32.dll ODBC driver (and two others). This can be fixed by patch 5699495 from MetaLink - metalink.oracle.com.
- Will
|||Dear Sir,
I have ASP v3 installed on Windows Server 2003 x64 which is connected to Oracle9i Database server. As you know ASP works under 32 bit Tech. So i need to install 32bit oracle client on the server to let ASP connect to Oracle. I tried to install oracle9i client but it didnot work ( the ODBC test connection works but the ASP cannot connect). I Also tried ODBC 32-bit Driver & ODAC all-in-one for 64bit & InstantClient .... all of the failed.
i would like to ask you about your steps, if it works well with ASP. Also i need to know from where i can download "32-bit 10.2.0.1 Client and 5337014 for 32-bit patch.
thank you in advance.
Alaa
No comments:
Post a Comment