I am currently working on a project with Oracle9i Forms at the front end and Microsoft SQL Server at the back end. Could you please recommend the necessary steps to connect an Oracle Forms 9i application with a SQL Server database?

    Requires Free Membership to View

I can't think of an easy way off of the top of my head. There's the Oracle Transparent Gateway. But that is certainly not an easy approach. There are also a few tools available using Oracle's Migration Workbench. You may also be able to connect using a JDBC driver. Check out Microsoft's JDBC driver for SQL Server. You can also find a list of JDBC drivers at DevX.com.


Do you have comments on this Ask the Expert Q&A;? Let us know.

This was first published in September 2005

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.