Oracle form builder can't access database created

[kcy]

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

[Prasy]

Hi,

SID need not be same as the database name. SID is System ID for that DB.

[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).

[kcy]

upz

[kcy]

[QUOTE][i]Originally posted by kmesser [/i]
[B]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). [/B][/QUOTE]


tried it, but still can't work. can onli connect the database under the file menu but not the data block wizard

[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 :-)

[kcy]

[QUOTE][i]Originally posted by hrishy [/i]
[B]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 :-) [/B][/QUOTE]

i install dev first then oracle... same result

[hrishy]

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

[kcy]

[QUOTE][i]Originally posted by kcy [/i]
[B][QUOTE][i]Originally posted by hrishy [/i]
[B]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 :-) [/B][/QUOTE]

i install dev first then oracle... same result [/B][/QUOTE]



no. using win nt, oracle8i lite and developer 2000 R2