Or, as covered before, spring for a copy of the developer edition and get an Enterprise Edition installation for a fraction of the commercial retail price. How do you get SQL Server? Download it from MSDN and sign up for a 180-day trial. What do you need for a test environment? Obviously Oracle database, and although several ODBC data sources are covered in the guide (Sybase et al), the external RDBMS here is SQL Server. Of interest for us in this article is the Database Gateway Installation and Configuration Guide for Microsoft Windows guide, given that most users are using Windows to learn Oracle. The documentation for database gateways includes seven guides, covering various flavors of UNIX, plus Windows. The product title for Oracle 11 gR2 on Windows (32-bit), as an example, is “ Oracle Database Gateways 11 g Release 2 (11.2.0.1.0) for Microsoft Windows (32-bit)” and is found under the download section for Databases at OTN. The key part of this connection architecture is based on ODBC.Ī new (since Oracle 11 gR1) piece of this setup involves downloading and installing DG4ODBC resources into an existing Oracle RDBMS installation. The new and improved method is named Database Gateways, and the name reference is commonly seen as DG4ODBC (or dg4odbc). Connecting Oracle Database to external data sources was formerly handled using OHS, or Oracle Heterogeneous Services. Setting up a connection to Oracle Database from SQL Server is fairly easy, but the opposite is not so true. Steve Callan walks you through a complete example of how to access SQL Server from Oracle Database using, named Database Gateways (Oracle’s new and improved method).
0 kommentar(er)
