Universal database dsn format12/30/2023 The following procedure enables you to define a system DSN in the Microsoft Windows ODBC Data Source Administrator, version 3.5:įrom the Start menu, choose Settings > Control Panel and select ODBC. Sqlserver7 is the name of the system DSN defined in the Microsoft Windows ODBC Data Source Administrator. In order to connect to this SQL Server database through the gateway, the following line is required in the init sid. Where dsn_value is the name of the system DSN defined in the Microsoft Windows ODBC Data Source Administrator.Įxample: Setting Initialization Parameter ValuesĪssume that a system DSN has been defined in the Microsoft Windows ODBC Data Source Administrator. The HS_FDS_CONNECT_INFO initialization parameter specifies the information required for connecting to the non-Oracle system. Changes made to the initialization parameters only take effect in the next gateway session. Refer to Appendix C, "Initialization Parameters" for the complete list of initialization parameters that can be set. You can use the default values and omit the optional parameters, or you can specify the parameters with values tailored for your installation. Other initialization parameters have defaults or are optional. You must set the HS_FDS_CONNECT_INFO initialization parameter. A number of initialization parameters can be used to modify the gateway behavior. The SID is used as part of the file name for the initialization parameter file.Īfter the initialization file has been created, you must set the initialization parameter values. If you have only one ODBC source but want to access it sometimes with one set of gateway parameter settings, and other times with different gateway parameter settings, then you will need multiple gateway SIDs for the single ODBC source. If you want to access two ODBC sources, you need two gateway SIDs, one for each instance of the gateway. You need one gateway instance, and therefore one gateway SID, for each ODBC source you are accessing. The gateway system identifier (SID) is an alphanumeric character string that identifies a gateway instance. ora, where sid is the system identifier(SID) you want to use for the instance of the non-Oracle system to which the gateway connects. To create an initialization file for the ODBC gateway, copy the sample initialization file and rename it to init sid. The sample file is stored in the ORACLE_HOME \hs\admin directory. Oracle supplies a sample initialization file, initdg4odbc.ora. You must create an initialization file for your Oracle Database Gateway for ODBC.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |