ODBC Connection / Non Oracle Data Connection [message #199063] |
Thu, 19 October 2006 23:54 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
annu-agi1
Messages: 17 Registered: August 2006 Location: Pakistan
|
Junior Member |
![annu-agi](/forum/theme/orafaq/images/yahoo.png)
|
|
I m getting this message when i connect to sql plus ... to foxpro database via ODBC connection .. it is working fine and looks almost O.K. Now can any body tell me how to rectify these errors.
SQL> connect aa/aa@ODBC:vfpd1;
ORA-00022: invalid session id; access denied
ORA-00022: invalid session id; access denied
ORA-00022: invalid session id; access denied
Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
Server not available or version too low for this feature
ORA-00022: invalid session id; access denied
Connected.
and also one can tell me how can i call any non-oracle data connection in reports and forms .. while we are already connected to one default geniune oracle connection .. my scareo is to just to populate some list items with this non-oracle data connection and use it in my oracle application .. can any one tell me how can i do this
|
|
|
|