Orace 64bit not working with Windows 64bit

I have a virtual machine installed MS Windows Server 2008 R2 EE 64bit on it. I just installed successfully Oracle 11g R2 64bit client on it. I made a service from net manager and tested it which was successful. I also verified my oracle installation from command promt using SQLPLUS command and it confirmed me about the correct Oracle installation.

I installed Toad 10 versions 10.6.1 & 10.1.8 (one by one) and tried to connect the database, it shows dll errors mostily OCI.DLL not initilized. I tried to get it resolved with different ways but remained unsuccessful, although it is fine with Oracle 11g Client 32bit.

Please suggest the possilbe solution!
Netsol-NOSAsked:
Who is Participating?
 
QlemoConnect With a Mentor Batchelor, Developer and EE Topic AdvisorCommented:
You are certain you installed the 32bit client in addition? Toad needs the 32bit client. Your SqlPlus you tested with is most likely the 64bit version.
You won't use the 64bit client usually, as there are only a few applications (servers) which require it.
0
 
Netsol-NOSAuthor Commented:
Yes I installed Oracle Client 32 bit first, uninstalled it and then install x64 Client to make it able to work. but it did not work although i was being said that, it is the tact to run it.

Kindly guide what should be the sequence to install both clients so the only x64 Client could work. if the only installation of Oracle x64 client is not able to work straight away.

Thanks
0
 
QlemoConnect With a Mentor Batchelor, Developer and EE Topic AdvisorCommented:
Quote: "Note: Toad supports 64-bit for Windows 2003 / XP / Vista / 2008 / Win7 with a 32-bit Oracle Client." - and that is with the current release 11. You need the 32bit client. Why did you want to install the 64bit client? You only need it if you use 64bit software on that machine.
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
Netsol-NOSAuthor Commented:
ok thank you,

Can you please confirm one more think, on the same environment, I mean on windows server 2008 EE R2 x64, if I install EA Server 6.3.1 Advanced Edition? is this compatible with Oracle Client R2 x64

0
 
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
That's Sybase, isn't it? It is that simple - if you have 32bit Software, use 32bit drivers, if you have 64bit Software (and I suppose EA Server is 64bit), use 64bit drivers. If you need both at the same time, you need to have a tricky setup, clearly defining the correct paths and Oracle Homes for each 64bit and 32bit drivers. If you are able to do so, just use one type of Oracle drivers, everything else will get very confusing, though it can work, with some fiddeling.
0
 
Netsol-NOSAuthor Commented:
Thank you for providing me the information
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.