In the Windows Task Manager, look for the DG4ODBC process. In a Command Prompt window, type dg4odbc -help. To do this, start the Windows Task Manager and choose the Processes tab. In ODBC Data Source Administrator on your DG4ODBC machine, configure a System DSN that connects to your SQL Server instance.įor instructions on configuring data sources, see the SQL Server ODBC driver documentation.Ħ4-bit Windows You need to check whether your version of DG4ODBC is 32-bit or 64-bit.Install and license the SQL Server ODBC driver on the Windows machine where DG4ODBC is installed.įor installation instructions, see the SQL Server ODBC driver documentation.Download the SQL Server ODBC driver for your Windows platform.For further information about DG4ODBC, refer to our DG4ODBC for Windows tutorials. The following instructions show you how to connect Oracle on Windows to SQL Server. The non-Oracle data is transparently integrated, and so Oracle client applications are not aware that the data is stored in a remote database from another vendor You can use Oracle's Database Gateway for ODBC (DG4ODBC) and the SQL Server ODBC Driver to connect Oracle to SQL Server.ĭG4ODBC comes as part of Oracle 11 g and later, at no additional cost, and is compatible with Oracle 10 g and later.ĭG4ODBC interacts with Heterogeneous Services (an Oracle database component) to allow Oracle client applications to access non-Oracle databases. Connecting Oracle to SQL Server from WindowsĬonnect Oracle applications on Windows to SQL Server.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |