
	Home > Ask the SQL Server Experts > Kevin Kline - Monitoring/Administration Questions & Answers > Connecting a Oracle9i Forms application to SQL Server

Ask The SQL Server Expert: Questions & Answers

EMAIL THIS

Connecting a Oracle9i Forms application to SQL Server

EXPERT RESPONSE FROM: Kevin Kline

		Pose a Question

		Other SQL Server Categories

		Meet all SQL Server Experts
		Become an Expert for this site

Expert advice on database administration

Digg This! StumbleUpon Del.icio.us

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?

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	Kevin Kline - Monitoring/Administration
	Publisher residing on a different domain
	SQL Mail troubleshooting
	Installing SQL Server client tools on Windows XP Pro
	Incorrect drive letter assignments
	Installing SQL Server 2000 Enterprise Edition on Windows XP
	Identifier field in Microsoft's SQL Server
	Getting scheduled DTS packages to run
	Performance problems after installing Windows Service Pack 4
	Improve performance by spreading data
	Difficulties transferring stored procedures and triggers

SQL Server Interoperability

Utilize SSAS for data predictions and classification using Excel

How to create a SQL Server linked server to DB2

Export SQL Server data to an Excel file using SSIS and Visual Studio

Performance tuning for SQL Server 2005 and Exchange running on SBS

Custom VB.Net scripting in SQL Server Integration Services

Can SQL Server 2000 work on Windows 2003 platform?

Query to search text in old DTS packages in SQL Server?

Handle slowly changing dimensions with SSIS 2005 wizard

Run DTS packages within SQL Server Integration Services

SQL Server Integration Services how-to

RELATED GLOSSARY TERMS

Terms from Whatis.com − the technology online dictionary

CORBA (SearchSQLServer.com)

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

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.

Browse our Expert Advice
Operating Systems IT Management Networking Database	Security Servers and Storage Applications and Development Career Center

SQL Solutions - SQL Database Design

SEARCH

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.


TechTarget Corporate Web Site \| Media Kits \| Site Map All Rights Reserved, Copyright 2005 - 2009, TechTarget \| Read our Privacy Policy