Bug: Typing an Oracle tnsname in the Instance field of the Database Connection dialog box changes to pre-10.1 syntax after saving connection
【相关信息】
Article ID: 40576
Bug Id: NIM085231
Software:
ArcGIS for Desktop Advanced 10.1, 10.2, 10.2.1, 10.2.2, 10.3
ArcGIS for Desktop Standard 10.1, 10.2, 10.2.1, 10.2.2, 10.3
ArcGIS for Desktop Basic 10.1, 10.2, 10.2.1, 10.2.2, 10.3
Platforms: N/A
【BUG描述】
When making a direct connection from ArcGIS 10.1 to an Oracle database or geodatabase using the tnsname, pre-10.1 syntax is appended to the tnsname after clicking OK on the Database Connection dialog box.
For example, if the tnsname of the Oracle database is myora, type myora in the Instance text box of the Database Connection dialog box. After clicking OK and the Database Connection properties dialog box re-opens, the text in the Instance text box has changed to 'sde:oracle11g:myora'.
Unfortunately, this leads people to believe that they should type the old syntax in the Instance text box. However, if sde:oracle11g:<tnsname> is typed, 'sde:oracle' gets appended to it.
For example, if sde:oracle11g:myora is typed in the Instance text box, ArcGIS tries to connect to 'sde:oracle$sde:oracle11g:myora'.
【BUG原因】
At 10.1, the Database Connection dialog box is simplified, so that the instance parameter only requires minimal information such as the tnsname or Oracle Easy Connect string for the database.
To allow upgraded systems to continue using older Spatial Database Connection files (*.sde), ArcGIS passes the older syntax when making a direct connection to Oracle.
Article ID: 40576
Bug Id: NIM085231
Software:
ArcGIS for Desktop Advanced 10.1, 10.2, 10.2.1, 10.2.2, 10.3
ArcGIS for Desktop Standard 10.1, 10.2, 10.2.1, 10.2.2, 10.3
ArcGIS for Desktop Basic 10.1, 10.2, 10.2.1, 10.2.2, 10.3
Platforms: N/A
【BUG描述】
When making a direct connection from ArcGIS 10.1 to an Oracle database or geodatabase using the tnsname, pre-10.1 syntax is appended to the tnsname after clicking OK on the Database Connection dialog box.
For example, if the tnsname of the Oracle database is myora, type myora in the Instance text box of the Database Connection dialog box. After clicking OK and the Database Connection properties dialog box re-opens, the text in the Instance text box has changed to 'sde:oracle11g:myora'.
Unfortunately, this leads people to believe that they should type the old syntax in the Instance text box. However, if sde:oracle11g:<tnsname> is typed, 'sde:oracle' gets appended to it.
For example, if sde:oracle11g:myora is typed in the Instance text box, ArcGIS tries to connect to 'sde:oracle$sde:oracle11g:myora'.
【BUG原因】
At 10.1, the Database Connection dialog box is simplified, so that the instance parameter only requires minimal information such as the tnsname or Oracle Easy Connect string for the database.
To allow upgraded systems to continue using older Spatial Database Connection files (*.sde), ArcGIS passes the older syntax when making a direct connection to Oracle.
1 个回复
易智瑞技术支持
赞同来自:
When connecting to Oracle databases or enterprise geodatabases in Oracle using ArcGIS for Desktop version 10.1 remember the following:
【创建及修改时间】
Created: 9/27/2012
Last Modified: 11/17/2014
【原文链接】
http://support.esri.com/en/kno ... 40576
要回复问题请先登录或注册