Problem solve Get help with specific problems with your technologies, process and projects.

Connecting a Oracle9i Forms application to SQL Server

There is no easy way to connect an Oracle9i Forms application to a SQL Server database – but Kevin Kline offers some approaches to take if you must make the two work together.

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?
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.

Dig Deeper on SQL Server Interoperability

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.