- #MICROSOFT ODBC DRIVER 11 FOR SQL SERVER 64 BIT HOW TO#
- #MICROSOFT ODBC DRIVER 11 FOR SQL SERVER 64 BIT INSTALL#
- #MICROSOFT ODBC DRIVER 11 FOR SQL SERVER 64 BIT DRIVERS#
- #MICROSOFT ODBC DRIVER 11 FOR SQL SERVER 64 BIT WINDOWS#
Document the DSN details for the application connectivity.Select the desired application database from drop down list and click Next.Ĭlick on Finish and test the data source connectivity. For SQL authentication, specify the SQL login name and password.
Select the authentication mode as per the requirement. Specify the data source name, description and the SQL Server instance name. Select the SQL Server Native Client 10.0 from the list and click on the Finish button. Select the System DSN tab and click on the Add. Open C:\WINDOWS\SYSWOW64\odbc32.exe or type %systemdrive%\Windows\SysWoW64\Odbcad32.exe in the Run window.
#MICROSOFT ODBC DRIVER 11 FOR SQL SERVER 64 BIT WINDOWS#
On the 64-bit machine where the application is installed, open the Microsoft Windows ODBC Data Source Administrator using one of the methods shown below. īelow are the steps to create a 32-bit DSN on a 64-bit machine.
#MICROSOFT ODBC DRIVER 11 FOR SQL SERVER 64 BIT INSTALL#
You can install the SQL Server native client either from the SQL Server media or by downloading it from.
#MICROSOFT ODBC DRIVER 11 FOR SQL SERVER 64 BIT DRIVERS#
You cannot use 32-bit drivers with 64-bit DG4ODBC.Before creating the DSN make sure the SQL Server Native client component is installed on the machine. One other point, because you are running on Windows 64-bit then the ODBC driver referred to in the System DSN for the connection needs to be a 64-bit driver. If you still have problems then post the following files and information. create the database link in the RDBMS using this tnsnames.ora entry. create a tnsnames.ora entry in the 10.2 RDBMS directory $ORACLE_HOME/network/admin for the gateway configure the gateway as in note 1266572.1 with a listener running from the gateway ORACLE_HOME, in your case \apps\product\11.2.0\tg_1\ On Windows the non-Oracle database information is in the System DSN which is used for the HS_FDS_CONNECT_INFO parameter in the DG4ODBC init.ora file. Heike referred to using an odbc.ini file but this is only needed when configuring Dg4ODBC on Unix/Linux platforms. The only thing to be aware of is that the DG4ODBC listener should use a different port from the 10.2 listener. There should be no concerns over performance or other conflicts. You definitely need 2 separate listeners - one for the 10.2 RDBMS and one for the 11.2 Dg4ODBC.
#MICROSOFT ODBC DRIVER 11 FOR SQL SERVER 64 BIT HOW TO#
How to Setup DG4ODBC (Oracle Database Gateway for ODBC) on 64bit Windows Operating Systems (Doc ID 1266572.1) The following note describes the setup of Dg4ODBC on Windows 64-bit.
In most case I get ORA-28545 and ORA-02063 errors.Ĭan anyone help me resolve this problem? Do I need to send more information, e.g. I have followed several threads from this forum, trying different configurations but I cannot connect successfully with the DATABASE LINK. So my question is, how I can configure one (10.2) or both listeners (10.2 and 11.2) to use DG4ODBC to connect to a remote SQL Server from Oracle? Running unchanged since ArcSDE services use it and re-create them is a pain. As a restriction, I need the listener 10.2 to continue There are two listeners running (one of each installation, 10.2 and 11.2) which, I suppose, can cause conflicts or reduce performance. Oracle Home: E:\oracle\product\10.2.0\db_1\Īlso, there is running an ArcGIS/ArcSDE 10.0 over Oracle.ĭB: Microsoft SQL Server 2000 - (Intel X86) Gateway: Heterogeneous Agent Release 11.2.0.1.0 - 64bit Production Built with Oracle Database Gateway for ODBC I need to connect from Oracle to SQL Server through DB-LINK, and since my Oracle installation does not contain HSODBC, I installed DG4ODBC.ĭB: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production 1.7K Training / Learning / Certification.165.3K Java EE (Java Enterprise Edition).7.8K Oracle Database Express Edition (XE).3.7K Java and JavaScript in the Database.
0 kommentar(er)
