 FRM-40514: Operation requires a database connection [message #109538] |
Fri, 25 February 2005 10:37  |
csmall
Messages: 2
Registered: February 2005
|
Junior Member |
|
|
...but I AM connected!!!
Can someone slap some sense into me and point out
the obvious, please?
I have a straight Forms 9i form; one block , one table,
nothing fancy. I can compile and run it against my local 9i instance. However, whenever I attempt to execute a query, I
get "FRM-40514: Operation requires a database connection."
I am completely perplexed because I know that I'm connected!!!
Could it be something with the funky ON-LOGON trigger? If I
omit it from my form, then I get "ORA-12154:TNS:could not resolve service name." ????? Duh, I just compiled the Form!!!
I've worked with Forms many times in the past and have never, ever had a problem like this. However, this is my maiden voyage into Forms 9i. Am I stepping on my own toes? Help!
Thanks,
Charles
|
|
|
|
 Re: FRM-40514: Operation requires a database connection [message #110010 is a reply to message #109538] |
Wed, 02 March 2005 14:26  |
csmall
Messages: 2
Registered: February 2005
|
Junior Member |
|
|
Uh...Never mind!...
Finally, after smacking myself several times
and a few glasses of merlot, I suddenly realized that
I have 2 Oracle Homes (one for the database and the other
for my Tools...) Then, I stumbled onto the solution that
,in my 9i case, 2 Homes required their own TNSNames files
(under their respective Network/admin directories).
However, I still can't explain why Forms 9i allowed me
to compile and run my Form with my database TNSNames, but
when it was time draw data from the database, Forms 9i
couldn't find my database until after I mirrored my
database TNSNames files for Tools. Probably something I
overlooked in the documentation. 
Cheers,
Charles
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
