DDevelopment & Design

Accessing Microsoft SQL Server from Oracle

Once we had a need of accessing a table on an Microsoft SQL Server database from an Oracle database. Thus we had to install Oracle Transparent Server on the computer hosting SQL Server. Oracle Transparent Services is a kind of adapter for non-Oracle servers and allows access to it through database link. During the instalation of Oracle Transparent Server you have to choose modules dedicated to particular databases. The modules can translate calls to some functions and allows to call a T-SQL stored procedure from Oracle.

Oracle Transparent Server can be downloaded from 

http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/10201winsoft.html  Description of its solution can be found here: http://oracle-apps-dba.blogspot.com/2008/04/oracle-transparent-gateways-general.html Instalation instructions are here… : http://oracle-apps-dba.blogspot.com/2008/04/oracle-transparent-gateway-for-ms-sql_16.html and here: http://forums.oracle.com/forums/thread.jspa?messageID=2720049&#2720049 However, most of the configurations files were located in the directory network\admin and not in tg4msql\admin as described I found that access to the data is slow – the simplest queries last for 4 seconds. However, increasing the efficiency is another topic.

— Previous article

<!--:en-->Solving package dependency problem using synonyms<!--:-->

Next article —

<!--:en-->Subtle feature of CONNECT BY<!--:-->

You May Also Like
DDevelopment & Design

Context menu or Action buttons ?

Recently I was drawn into one of those UI "religious" disputes that has no easy answers and usually both sides are right. One of our web developers was trying out new web tech (with pretty rich widget library) and started to question himself about some basic usability decisions. The low level problem in this case is usually brought to "which widget should I use ?". I'm not fond of bringing the usability problems to questions: Should I use Tabs over Menu ? Or should I use Context menu instead of buttons panel ? But sometimes if time is crucial factor and other usability levels are by default not addressed at all - better developer that asks those basic questions than developer that do not question himself at all.