We are in process of upgrading to window 7 and found that our existing toad 9.7 does not make the connection.
Any help, advise, suggestion will be highly appreciated.
Thanks.
What happens when you try?
I am going to guess that you have a 64-bit Oracle client installed. Toad runs as
a 32-bit application and requires the 32-bit Oracle client to be installed.
Beside the 32 bits Oracle client, try to use a recent client. There are some
Oracle clients (10) which give problems when the application is installed in a
directory with parenthesis in the name : c:\program files (x86)
Update the client or don’t install toad to this directory.
Groetjes,
Wim
On Sun, Jan 23, 2011 at 19:32, Jeff Smith wrote:
What happens when you try?
I am going to guess that you have a 64-bit Oracle client installed. Toad
runs as a 32-bit application and requires the 32-bit Oracle client to be
installed.Thanks for the quick response. We installed the Oracle XE . We don’t have a dedicated Oracle Client installed.
Since Oracle XE has a client dll that Toad uses we thought it would go ok.
Please Advise.
Thanks.
Morning,
I use XE client on Windows 2000 here at work. No problems with that, but
as Wim points out, there are problems with there are ‘(’ and ‘)’ in the
path name and I think Windows 7 puts 32 bit stuff into a path with just
that problem. Go figure!
Cheers,
Norm. [TeamT]
Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.
We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.
If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk
Yes – Oracle XE is really nothing more than Oracle 10g R2 with some built
in governors (e.g. single CPU and 4 GB disk space). That said it should work
just like Oracle 10g as far as client needs. Do note that Oracle non-XE installs
with a path something like c:\oracle\product\version whereas XE creates an
entirely new path something like c:\app\oracle. But that difference should not
be a problem.
Now as Norm points out – Oracle 10g came out before Windows Vista/7 and
has some quirks with 64-bit directory naming. In fact the same problem occurred
under Win XP 64-bit – which I used to use. The parenthesis in the
directory names such as c:\program files (86) caused numerous client side
problems as the underlying Oracle OCI code had issues with it. In fact Oracle
10G is not even officially supported by Oracle for Windows 7 64-bit. You can
look up the current status and info on metalink.
The workaround (which often gets you past the hump) is simply to install both
Oracle client and Toad into somewhere that does NOT have a parenthesis in the
directory name. But as far as I know that does not change the fact that 10G is
not officially supported on some OS versions – this is simply a work
around suggested ….
when you upgraded it moved this:
C:\Program Files\Quest Software\Toad for Oracle 9.7
to this:
C:\Program Files (x86)\Quest Software\Toad for Oracle 9.7
Move it back.
(Or patch your Oracle client, it’s their bug and there’s a fix for it)
Hi Mark,
(Or patch your Oracle client, it's their bug and there's a
fix for it)
There's a patch for XE client? As far as I'm aware, there isn't as XE is
install once and that's yer lot!
Maybe the patch is for general 10g clinet, but the OP is on XE I'm
afraid. (So am I!)
Cheers,
Norm. [TeamT]
Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.
We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.
If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk
The fix is to move the folder
Thnaks Mark. (Anagram)
The fix is to move the folder
Cheers,
Norm. [TeamT]
Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.
We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.
If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk