Home » Open Source » MySQL » OCA 6.0.5.3x required to connect mysql through froms6i
OCA 6.0.5.3x required to connect mysql through froms6i [message #242215] Fri, 01 June 2007 02:01 Go to next message
janu
Messages: 4
Registered: January 2007
Junior Member
Hi All,

I am trying to connect MYSQL database through developer2000/6i.

I am using Oracle D2K Forms 6i, OCA for ODBC 6.0.5.29.0, MySQL ODBC driver 3.51.

I am able to connect to mysql database using sql*plus but it gives the following errors and we cannot query from the tables.

SQL> conn teamone/11iteam@ODBC:myodbc
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 loade
You may need to run PUPBLD.SQL as SYSTEM
Server not available or version too low for this fea
ORA-00022: invalid session id; access denied
Connected.
SQL> select * from temp;
SQL*Plus internal error state 2090, context 18:0:0
Unsafe to proceed
SQL> 


The OCA version is 6.0.5.29 but i hope the problem can be solved by OCA version 6.0.0.5.3x

Kindly tell from where can i get(link) latest OCA version 6.0.5.3x or 6.0.5.35.0

and also steps to connect to mysql database through forms6i, so that i can cross check my steps.

Thanks in advance
janu
Re: OCA 6.0.5.3x required to connect mysql through froms6i [message #242440 is a reply to message #242215] Sat, 02 June 2007 02:41 Go to previous message
qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN
Senior Member
my dear i feel that you waste your time from oracle site i also face same problem. Then i install forms 6 and reports 6 with complete option and then i create odbc connection and connect successfully and design some forms and reports successfully

kind regards

Rana Faheem iftikhar
qanita786@yahoo.com
Previous Topic: oracle dump to Mysql database.
Next Topic: how to connect from owb to mysql databases
Goto Forum:
  


Current Time: Fri Mar 29 08:22:54 CDT 2024