 integrating query builder and forms 10g [message #125886] |
Wed, 29 June 2005 13:49  |
bsippy
Messages: 4
Registered: May 2005
|
Junior Member |
|
|
when I call HOST('C:\oracle6i\bin\OBE60.EXE OWNERLIST=USER,DEVELOP,PRIME USERID=user/pwd@connect_string'); from the form
I get the following error
OBE-15387: Login failed
----
ORA-12222: TNS:no such protocol adapter
But when I open query builder directly it is working......I am using forms 10g and have installed 6i in a completly different home......any help would be greatly appreciated.
|
|
|
|
|
|
|
|
| Re: integrating query builder and forms 10g [message #125919 is a reply to message #125895] |
Wed, 29 June 2005 22:51  |
bsippy
Messages: 4
Registered: May 2005
|
Junior Member |
|
|
I am trying to call 6i query builder from froms 10g.
The interesting fact here is it works from the command line, ie if i put
'C:\oracle6i\bin\OBE60.EXE OWNERLIST=USER,DEVELOP,PRIME USERID=user/pwd@connect_string' in the command line, it works perfectly.
Also the host works for other executables. Example if i put host('notepad.exe') it opens up notepad too
|
|
|
|
| Re: integrating query builder and forms 10g [message #125922 is a reply to message #125919] |
Wed, 29 June 2005 22:57 |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
Thought so, I expect that 10g will have super-defined some on the path statements when it was started. I believe that the host commands then run within this updated environment. You could try putting the 6i stuff in a 'bat' file and get that 'bat' file to show you the environment characteristics so that you can confirm this behaviour.
My rule of thumb is "don't mix environments" at run time.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
