When toad starts I get the following:
ORA-00942: table or view does not exist
ORA-06512: at line 207
IS there some script that runs on statup and if so what is it and where can I find it?
From the main menu, choose Database -> Spool SQL -> Spool to Screen. Then try to make your connection again. That will show you every query that Toad executes.