This content has been marked as final. Show 8 replies
What you are asking is not possible. Oracle Forms was designed to specifically interact with the Oracle Database. You can access other database tables through an Oracle Database using Oracle Heterogeneous Services, but straight ODBC is no longer supported.
Hi1 person found this helpful
Check this link. http://halimdba.blogspot.com/2010/03/how-to-connect-from-oracle-to-mysql.html
Hope this works..
so the alternate is to install oracle express edition, create a db link to mysql to avoid licensing problem?
my client is insisting for free database.
or the alternate i have to learn java etc to develop such an application which could directly connect to mysql?
java is tuff man, i work around only in oracle developer suites.
thank you hilal, it is helpfull but not related to my question.
i need to avoid the oracle database from the middle.
I'm not quite sure if you avoid licensing problems when you provide a Forms 6i runtime. You should ask your Oracle Sales representative if you are still allowed to provide it for without licensing costs.
If you are not allowed to use an Oracle-database, i would use a different tool for application development. Maybe an Oracle XE-database in combination with an APEX-application is an alternative approach?
yes Andreas Weiden ,
and in the xe database, i will create a database link to my sql, and the end user must contain both the oracle xe database and mysql.
it means we need to learn another tool for development if we want to skip oracle database to be in touch with our applications.
i am thinking about asp.net using c#.
Thank you so so much.
If you use Oracle Database XE with the development tools Oracle APEX, both are free and have no other issue. You don't need of MYSql.
Is this not enough for you ?
But Oracle Database XE is a limitation of space right?
Ideally, connect to a database that has no storage constraint