i could onli connect to the database using the sql8.0 screen.
the data block wizard can't access the database at all.
tried using the net assistant to test the connection, but fail.
btw, wats sid? does this have to be the same name as the database
Printable View
i could onli connect to the database using the sql8.0 screen.
the data block wizard can't access the database at all.
tried using the net assistant to test the connection, but fail.
btw, wats sid? does this have to be the same name as the database
Hi,
SID need not be same as the database name. SID is System ID for that DB.
The problem is in your tnsnames.ora file. There is one for each ORACLE_HOME . SQL*PLUS is in a different ORACLE_HOME than developer. Append the contents of the tnsnames.ora from the SQL*PLUS home (ORACLE_HOME/network/admin) to the tnsnames.ora file in the developer home (ORACLE_HOME/net80/admin).
upz
Quote:
Originally posted by kmesser
The problem is in your tnsnames.ora file. There is one for each ORACLE_HOME . SQL*PLUS is in a different ORACLE_HOME than developer. Append the contents of the tnsnames.ora from the SQL*PLUS home (ORACLE_HOME/network/admin) to the tnsnames.ora file in the developer home (ORACLE_HOME/net80/admin).
tried it, but still can't work. can onli connect the database under the file menu but not the data block wizard
hi there
heres a simple solution to your problem
A) uninstall dev 2000 and oracle from your windows
b) now install dev2000 first followed by oracle
your problem would be solved :-)
i install dev first then oracle... same resultQuote:
Originally posted by hrishy
hi there
heres a simple solution to your problem
A) uninstall dev 2000 and oracle from your windows
b) now install dev2000 first followed by oracle
your problem would be solved :-)
tell me more about your operating environment what version of oracle r u runing ? are you using windows 98 by the way.
also do tell me about the version of forms and oracle you are curently running
Quote:
Originally posted by kcy
i install dev first then oracle... same resultQuote:
Originally posted by hrishy
hi there
heres a simple solution to your problem
A) uninstall dev 2000 and oracle from your windows
b) now install dev2000 first followed by oracle
your problem would be solved :-)
no. using win nt, oracle8i lite and developer 2000 R2