sfjohnston71
asked on
TOAD connection not working
I have installed Oracle 9.i and TOAD 7.6 Expert - yestrday it worked fine for me on a colleagues PC - but today when I have logged in as myself (and stupidly installed TOAD again) - now when I go to login to my database I geta message that is Blank and just has an "OK" button - when I click this button nothing happens.
Can anyone suggest what is happenning.
I have already tried uninstalling TOAD, deleting the Quest directory in the Program Files directory as well.
Short of uninstalling Oracle 9.i on my computer and re-installing - can anyone suggest why this has happenned. I cannot fin anythin n the TOAD release notes to help.
Thanks
Can anyone suggest what is happenning.
I have already tried uninstalling TOAD, deleting the Quest directory in the Program Files directory as well.
Short of uninstalling Oracle 9.i on my computer and re-installing - can anyone suggest why this has happenned. I cannot fin anythin n the TOAD release notes to help.
Thanks
try to do TNSPING in your DOS command window for the database you tried to connect.
ASKER
I should also mention that I can connect to SQL Plus using the id and pasword i have.
ASKER
seazodiac - at my cmd prompt I am typing c:\>tnsping <databasename>
it's telling me that the name is not recognised as an internal or external command, operable program or batch file
it's telling me that the name is not recognised as an internal or external command, operable program or batch file
but you are sure you can use SQLPLUS to connect to oracle...
if you are absolutely sure about that, then let's configure TOAD,
when you open up the TOAD, in the first popup window (not the main window) showing the connection screen.
On the right side of the window, it has a few checkbox say: use SQLNET to connect , Use net8 compatible to that effect.
check those two boxes. and try again
if you are absolutely sure about that, then let's configure TOAD,
when you open up the TOAD, in the first popup window (not the main window) showing the connection screen.
On the right side of the window, it has a few checkbox say: use SQLNET to connect , Use net8 compatible to that effect.
check those two boxes. and try again
ASKER
I checked the box Force SQL*Net (ignore Net 8) it gave me an error message
Initialization error
Could not locate OCI dll
When I click connect
Initialization error
Could not locate OCI dll
When I click connect
ASKER
When I try and check SQL*Net Compatible Net8 I get the message
Can't initialize OCI. Error -1
Can't initialize OCI. Error -1
ASKER
I can connect to SQL plus - just ran a simple query against a table and got back the desired result
ok, here is another thing to look at :
in the very same window you do the configuration above.
at the very bottom of the right side, there is SQLNET Help (it's blue link) you can click that, it will open up another window with a bunch of ORACLE_HOMES
make sure you have the right ORACLE_HOME there, the same ORACLE_HOME where your SQLPLUS executables are in..
in the very same window you do the configuration above.
at the very bottom of the right side, there is SQLNET Help (it's blue link) you can click that, it will open up another window with a bunch of ORACLE_HOMES
make sure you have the right ORACLE_HOME there, the same ORACLE_HOME where your SQLPLUS executables are in..
It's A button "SQL*NET HELP" on the bottom .
ASKER
I have a line saying that D:\oracle\ora92\BIN is not in the system path when I click on the connect using
my home directory is d:\oracle\ora92 - which is where my Oracle is installed and the SQL Plus folder is
I don't have a SQL NetHelp - I have a SQL Net Editor which does not mention Oracle Home
my home directory is d:\oracle\ora92 - which is where my Oracle is installed and the SQL Plus folder is
I don't have a SQL NetHelp - I have a SQL Net Editor which does not mention Oracle Home
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
OK - seazodiac - you can have the points. I uninstalled Oracle 9.i and TOAD out of shear frustration and now I can connect!!
But now I have issues with my access rights - aargghhhhhhhhhh
But now I have issues with my access rights - aargghhhhhhhhhh
ASKER