QUESTION POSED ON: 14 September 2005 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.
Search and Browse the Expert Answer Center Search and browse more than 25,000 question and
answer pairs from more than 250 TechTarget industry experts.
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.
