Toad not running under Win7? Error: "OCI version not supported"

I installed (successfully ?) Toad 9.6.1xpert on Win7 Home and wanted to
connect
to an Oracle XE Express Database.

After start of Toad and trying to connect to SYSTEM account I got an error
popup:

“OCI version -2.1975789543.1304804.1352.1304868 is not supported”

Hmm, what does that mean?

Is Toad not running under Win7 (Home) ?

Are there some drivers missing ?

How do I install a newer version of OCI ?

Ben


View this message in context: http://old.nabble.com/Toad-not-running-under-Win7--Error%3A-"OCI-version-not-supported"-tp27977023p27977023.html
Sent from the TOAD mailing list archive at Nabble.com.

Toad runs just fine and is officially supported for Win7.

Weird error messages like this usually indicate you’re running a 64 bit
version of the Oracle client. Can you confirm you’re using a 32bit Oracle
client?

If you have XE running on your local machine, you should have everything you
need to connect out of the box, unless you installed 64 bit Oracle. If
you’re running 64 bit Oracle, go to Oracle’s download page and grab
a 32 bit version of an Oracle client, try to grab a 10g copy, since that’s
the version of XE.

You can have more than one client installed on a machine with no problems.

If look at Toad’s Help > Support Bundle, it will tell you which version
of the client you have installed.

GASP Toad is not 64-bit!!!?

Doug

On 3/21/2010 7:19 PM, Jeff Smith wrote:

Toad runs just fine and is officially supported for Win7.

Weird error messages like this usually indicate you’re running a 64
bit version of the Oracle client. Can you confirm you’re using a 32bit
Oracle client?

If you have XE running on your local machine, you should have everything you
need to connect out of the box, unless you installed 64 bit Oracle. If
you’re running 64 bit Oracle, go to Oracle’s download page and
grab a 32 bit version of an Oracle client, try to grab a 10g copy, since
that’s the version of XE.

You can have more than one client installed on a machine with no problems.

If look at Toad’s Help > Support Bundle, it will tell you which
version of the client you have installed.

Morning Jeff,

You can have more than one client installed on a machine
with no problems.

If I might expand a little.

You can have more than one version of Oracle INSTALLED with no problems.
What you cannot do, without asking for trouble, is have more than one
version on the %PATH% at the same time.

Some versions may live happily together on %PATH% but most, in my
opinion, do not.

On Unix (assorted flavours) we have the lovely 'oraenv' which allows us
to swap and change ORACLE_HOMES almost willy nilly as it makes sure that
we don't have a mix-and-match of Oracle versions lying around on $PATH
at the same time. I've seen a mix of 9206 and 9208 causing troubles in
the past - because some numpty hard coded a 9206 setting in .profile,
and when we changed to a 9208 database, it fell over.

On Windows under 9i we used to have the Oracle Home Selector which was a
nice utility to do a Windows version of oraenv. Unfortunately (for us
here) it didn't remove Oracle 7 client (don't ask!) when it swapped 9i
versions over because it doesn't recognise anything below 8i or above
9i.

I have a vague remembrance that with 10g, there is a similar utility -
but it's part of the 10g installer, and not a separate utility in it's
own right. (I don't have a 10g client installed at the moment - other
than XE - so I can't check.)

Don't have multiple versions of Oracle client on %PATH% (or $PATH) at
the same time.

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

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

Morning Doug,

GASP Toad is not 64-bit!!!?
Better not be! It won't run on my 32 bit Windoze box! :wink:

At the moment, Toad is indeed still only 32 bit. But, who knows what
the future might bring. (Once every Toad user in the world is running a
64 bit Windows I suppose.)

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

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

Not to make any excuse – but the only limit of significance of toad being
32-bit is that when in the schema browser or editor and the data grid and you
have toad fetch all rows for the results/table (not always a smart thing to do)
and thus all those rows must fit within 32-bit memory limit of 3.2 GB. Your
network admin will probably scream at you long before as you pull that much data
back. Yes – it would be nice to offer 64-bit. But for now there is no real
issue – other than you have to install 32-bit client. This is clearly
spelled out in the release notes, on the product’s web page – data
sheet doc, and on www.asktoad.com FAQ.

Only with older versions of toad or in some cases newer versions when you
install more than the base product (e.g. sql optimizer in expert bundle). I use
toad on 64-bit windows 7 and have zero issues. But I’m using just the base
or standard product and I have installed a 32-bit oracle instant client (i.e.
just a few files and PATH set to that unzip location).

Yes, that is a known Oracle problem, not Toad.
image001.jpeg