How to solve TOAD Error “00.00.0000 00:00:00” is not a valid date and time

There is something weird about my TOAD when I tried to export query result from my TOAD application into Excel file. The error was something like this : “00.00.0000 00:00:00” is not a valid date and time.
I spent a lot of time searching for solution for this error. Luckily I was not so urgently need the data. I have time to google it and find the solution. It is so true when finally I found that it was actually related to Real Player installation in my machine. I do not know why this Real Player download and installation affected to my TOAD program, but this is really a bug which Real staff needed to be notify.
After searching over the net, you may wanted to try listed step I have provided as below.

  1. Simply open TOAD, go to Utilities > Task Scheduler (this is somehow will trigger the error pop-up again)
  2. From the task listed, locate for RealCreateProcessScheduledTask***** (it has a longer character than this)
  3. Delete this task 

If above step was not so succesfull, you may need the other way around. Actaully above step was not working for me. Below step truely works. You may need a command promt running to delete this task, because normal Task Scheduler will not give you the complete list of task when running on your machine.
My machine running Windows 7 Pro, and to accomplish this, I need a full administrator access to delete this task. How to do that?
Find command.exe from your WindowsSystem32 folder. Right Click and click “Run as Administrator”. When the command prompt has appear, do the following:

  1. Type ‘schtasks /query | more‘ and enter to list all current task
  2. Locate the RealCreateProcessScheduledTask***** and copy it over (make sure you copied all full task name of this. If you screen limit it, you can copy the full task name from the TOAD program)
  3. Excute this command ‘schtasks /delete /tn [ProblemTask]‘, which [ProblemTask] is referring to RealCreateProcessScheduledTask***** (full task name).
  4. You will see a prompt notification to confirm deletion, press Y and Enter.
  5. Now you can do export in TOAD with no more error.

Please leave a comment below if you want to add anything.

Problem open TOAD after install : You have no Oracle Client installed.

I encounter a problem with my TOAD for Oracle just now. It mentioned You have no Oracle Client installed .Wondering what is the problem and below was the screenshot of it.


You have no Oracle Client installed



The solution is very simple. And I also found the root cause of it.


Root cause: Toad do not support Oracle Client for 64 bit. As simple as that


Solution : Install Oracle Client 32 bit. You may install another copy of Oracle client, or you may remove the 64 bit which you previously installed.


To be particular, my machine was a Windows 64 bit platform, and I directly apply Resolution 2 as below.


Below are the statement from the Quest Software support site.
For more detail from the site: https://support.quest.com/Search/SolutionDetail.aspx?id=SOL39689
Cause
– There is no Oracle client installed on the machine or the client installed is 64-bit. Toad does not support a 64-bit Oracle client.
– Environment Variable Path is missing.

Solution for ‘You have no Oracle Client installed’ :

RESOLUTION 1:
Check to make sure there is an Oracle client installed on your machine. If there is not, you will need to install one. Please review solution SOL76452 for video demo and instructions on installing a 32-bit Oracle Instant Client. See additional information below for link to full 32-bit Oracle Client


RESOLUTION 2:
If there is an Oracle client installed on the machine, check to see if it is 64-bit. If it is, you will need to install a 32-bit Oracle client.


RESOLUTION 3:
1) Look for your OCI.DLL file in your computer and Copy the location path i.e. C:oracleproduct10.2.0client_1BIN
2) Right-Click your My Computer | Properties | Advanced Tab | Environment Variables button
3) Under ‘System Variables’ at lower half of screen, highlight ‘Path’ | click Edit
4) Under ‘Variable Value:’ | go to the very beginning of the existing entry | Paste the path you copied earlier
5) Add a semi-colon (;) | and then click OK, OK, OK.
6) Start Toad and re-test


RESOLUTION 4:
You installed an Oracle Client 10g version in a Windows 64-bit machine. There is an issue with the Oracle Client 10g version on a Windows 64-bit machines where 3rd party Oracle Tools like Toad for Oracle will not be able to see the client. Possible resolutions for this are:
– Install Toad in “C:Quest Software” folder instead of the default “C:Program Files (x86)” folder.
– Install and use Oracle Client 11g version instead. See the download link below for the client we recommend.


To download Oracle 11g Client software:
11g 64bit client
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html
11g 32bit Client
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win32soft-098987.html
You may need a Oracle Metalink account to download it.