You have no oracle clients installed

Morning Kiran,

I have the following configurations and I am facing the "You
have no Oracle Clients ?Installed" and the "You do not have
any Oracle Homes installed" Error:

Windows 7 Professional 64 Bit
Oracle 10g Client
Toad Version 9.6.1.1

Please guide me.

Ok, I'm assuming that you have installed a 64 bit Oracle client. Toad is
developed in Delphi, and at the moment, Delphi only produces 32 bit
applications. I'm sure that soon there will be a 64 bit offering.

This means that Toad cannot link to 64 bit Oracle Clients, so you need
to install a 32 bit Oracle client for now. This can be Instant Client,
if you don't wish to install a full 32 bit client.

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

Okay, Thanks. Any idea when Delphi/Toad will be out with the 64 Bit?

Okay, Thanks. Any idea when Delphi/Toad will be out with the 64 Bit?

Hi Kiran,

well, Embarcadero have been talking about 64 bit Delphi for some time,
but they have a more recent web page at
http://www.embarcadero.com/products/delphi/64-bit but no dates as yet.

However, it’s not as simple as that. The developers at Quest have to
then get used to running and using the new system - with all the
changes, plus the source for Toad may well require changes (Automatic or
manual) to comply with the requirements of the new environment.

Then Toad will be compiled under 64 bit, and testing will begin.

Cheers,
Norm. [TeamT]

Norman Dunbar
Contract Senior Oracle DBA
Capgemini Database Team (EA)
Internal : 7 28 2051
External : 0113 231 2051

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

And we have to wait for third party components Toad uses to implement 64-bit and
bring it to market.

Question: Other than simply wanting a 64-bit client, what reason is there for
needing a 64-bit Toad? The only obvious benefit is a larger memory space. But
does anyone really want to cache GB’s of data on their PC within a data
grid? That basically violates and/or invalidates relational accuracy as the
database cannot see and maintain those values. Plus your network admin will be
stopping by if you keep pulling down massive amounts of data. So other than I
run 64-bit windows and would like 64-bit client – there really is no
reason or issue preventing people from getting their work done J

Being able to build huge export files, like spreadsheets and CSVs, plus having
better performance in the ER Diagrams and Code Road Maps…might help?

If I was a betting man I’d say it’s a 75% chance within the next two years.

Norm and Bert gave good replies. The appeal of 64-bit, beyond the client demand
(which isn’t an issue since there are 32 bit clients freely available anyway) is
a bit dubious. I think people just want to feel like they’re keeping up to date
or they’re attracted to the number 64 since it’s twice the amount of 32, or they
think it will run twice as fast or something. We’ll be fortunate if it’s as fast
as the current version, that’s not a given. The footprint will definitely be
larger. So I find the groundswell of the 64-bit push a little unfortunate
because I think it’s based mostly on perception. But some time after Delphi gets
there we’ll be getting there.

same is true of multi-threaded vs singleton

your entire stack of libraries (dlls) have to be ALL (in this case)
64bit-compliant for a 64bit client to work

does bore-land still support delphi?
Martin


England and America… are two countries separated by a common language…George
Bernard Shaw

Borland dumped all dev tools to Code Gear which was eventually eaten by
Embarcadero. Now Borland has been eaten by MicroFocus.

To date most 64-bit apps are lucky if they are as fast as their 32-bit
predecessors. And I’m being generous in saying that nicely. Plus 64-bit
apps like office 2010 have lots of known caveats their 32-bit ancestors do not.
So to say faster or better because twice the bits is just plain wrong. As for
building huge export files or spreadsheets does not require the oracle client or
toad to be 64-bit. If you have 64-bit Excel then toad can build bigger
spreadsheets – but that has nothing to do with toad or sql*net.

Don’t get me wrong I love 64-bit Windows and Linux. I’ve been doing
64-bit since the first day WinXP 64 was available. The only legit issue was back
then did the installers and apps handle the parens in the file names. The only
real benefit is that a 64-bit OS can host lots more open apps without swapping
or paging. As for the apps, 99.9% really offer little improvement in 32 vs 64
bits. Maybe multimedia apps and such since the items they work with are so big
in nature.

So don’t get caught up in the hype. Find legit reasons for needing 64-bit
before demanding it J

Hmmm – so dot net or move to Mac/Linux – maybe that’s been a
good thing in disguise J

Running out of memory building larger files surely has something to do with
larger addressable spaces? Never said it would be faster…

NTFS with default block size allows files to about 32.5 GB – and Toad can
create files that big on export and save as. We do not keep it all in memory
unless you’re an idot and turn on the option to put all that’s
dumped into the grid (i.e. memory). So again , find a real reason and not just
the hype.

You most clearly said: plus having better performance in the ER Diagrams and
Code Road Maps…might help

I did, didn’t I? I was thinking about the file thing before…sorry about
that.

Hi Bert,

Hmmm - so dot net or move to Mac/Linux - maybe that's been a
good thing in disguise J
Nah, wxWidgets or QT. :slight_smile:
C++ sorts the men from the boys!

Cheers,
Norm.

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

I use wxwidgets – so it’s funny you mentioned it. I’m not
really a programmer so I’m sure my tool selection is not ideal. But it
works for me J

And yes, I’m a C programmer from eons ago when I actually wrote real life
code for a living. Thank God that he moved me on to things I actually can do
worth a darn J

Hi Bert,

I use wxwidgets - so it's funny you mentioned it.
I used to be Delphi, up until about version 5. I still have a Personal
Delphi 7 somewhere on my backup CDs. I used QT for a while, very nice,
very cross platform as well. WxWidgets is something I'm getting to like.
I haven't done anything "brilliant" with it yet, but one day, who knows!

I'm not really a programmer so I'm sure my tool selection is not
ideal. But it works for me J
Then that's all you need. I'm not really a DBA!

And yes, I'm a C programmer from eons ago when I actually
wrote real life code for a living. Thank God that he moved
me on to things I actually can do worth a darn J
:slight_smile:

Cheers,
Norm.

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

Norm!

C++ sorts the men from the boys!

And Assembly sorts the men from the real men.

Self-taught 6502 and VAX MACRO, trained in BAL. Haven't used any of them in
15 years... :slight_smile:

Rich -- [TeamT]

Disclaimer: Oprahless and lovin' it.

Hi Rich,

And Assembly sorts the men from the real men.
I know, I teach 68000 assembly! :wink:

Self-taught 6502 and VAX MACRO, trained in BAL. Haven't used
any of them in 15 years... :slight_smile:
I'm Z80 and 68000 myself. Never could figure out x86 etc. I have the
books, I don't have the brain!

Disclaimer: Oprahless and lovin' it.
I've been Oprahless all my life. And all the others. Daytime TV, just
say "no!".

Cheers,
Norm.

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