Q

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.
This was first published in September 2005

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close