arcgis连接空间数据库

Arcgis空间数据库链接1. 使用ArcSDE服务连接空间数据库使用ArcSDE服务连接到空间数据库操作步骤如下：在ArcCatalog的目录树，展开DatabaseConnections文件夹.双击添加SpatialDatabaseConnection，打开“SpatialDatabaseConnectionProperties"对话框.在Server文本框中，输入服务器名称或者IP地址；在Service文本框，输入服务名或者端口号。如果想连接Oracle数据库中某用户方案的空间数据库，输入端口号和schema，并以冒号分隔，例如：5151:Geodata.如果数据存储在SQLServer,IBMDB2,Informix,orPostgreSQL关系型数据库中，在Database文本框中，输入预连接的数据库的名称。Oracle数据库跳过此步。如果使用数据库认证，输入数据库的用户名和密码。需要保存用户和密码，勾选“savetheusernameandpasswordwiththisconnectionfile”，否则不保存。如果使用操作系统认证，单击“Operatingsystemauthentication”按钮。数据库认证不可用。如使用Oracle某用户的Schema数据库或者使用SQLServer中的dbo-schema数据库，必须在属性对话框中更改“Connectiondetails”部分，从事务版本列表中选择空间数据库版本。Ifyoudonotwanttosavetheversionconnectioninformationyouprovidedinthelaststep,uncheckSavetheversionwiththeconnectionfile.如果不保存版本的连接信息，去掉“Savetheversionwiththeconnectionfile”前的勾选。单击“TestConnection”按钮，执行连接测试.测试成功，“TestConnection”按钮灰掉，否则，将无法从数据库中获取数据。单击OK按钮.输入数据库连接名称.13) 回车.2.直连Oracle空间数据库以下内容将介绍三种直连到Oracle空间数据库的方式：第一，使用数据库认证直连到Oracle空间数据库；第二，使用操作系统认证直连到Oracle空间数据库；第三，如何连接到某用户方案的空间数据库。使用数据库认证直连到Oracle空间数据库在ArcCatalog的目录树，展开DatabaseConnections文件夹.双击添加SpatialDatabaseConnection.Server，输入服务器名称或者IP地址；Service，根据Oracle客户端版本输入连接字符串。连接Oracle9i,输入："sde:oracle9i"；连接Oracle10g,输入："sde:oracle10g"；Oracle11g,输入："sde:oracle11g".UserName，输入用户名.Password，输入密码及Oracle网络服务名，格式：sde@oradb。单击OK按钮.输入数据库连接名称。回车。使用操作系统认证直连到Oracle空间数据库Double-clicktheDatabaseConnectionsfolderintheCatalogtree.Double-clickAddSpatialDatabaseConnection.IntheServertextbox,typethenameoftheserveronwhichtheOracledatabaseresides.Ifyou'reconnectingtoOracle9i,intheServicetextbox,type"sde:oracle9i:/;LOCAL=<SQL_Net_alias>".Ifyou'reconnectingtoOracle10g,type"sde:oracle10g:/;LOCAL=<SQL_Net_alias>".TheSQLNetaliaswassetwhenyourcomputerwasconfiguredtouseadirectconnection.Contactyoursystemadministratorifyoudonotknowwhatvaluetosubstitutehere.ClicktheOperatingsystemauthenticationbutton.Thedatabaseauthenticationinformationbecomesunavailable.ClickOK.Typeanewnameforthespatialdatabaseconnection.PressEnter.连接到指定用户的空间数据库1)Double-clicktheDatabaseConnectionsfolderintheCatalogtree.2)Double-clickAddSpatialDatabaseConnection.IntheServertextbox,typethenameoftheserveronwhichtheOracledatabaseresides.Ifyou'reconnectingtoOracle9i,intheServicetextbox,type"sde:oracle9i:/:<schema_name>".Ifyou'reconnectingtoOracle10g,type"sde:oracle10g:/:<schema_name>".TypeyourusernameintheUserNametextbox.Typeyourpassword,followedby@<oraclenetworkservicename>,inthePasswordtextbox.UncheckSaveusernameandpasswordifyoudon'twantyourlogininformationsavedwiththeconnection.Spatialdatabaseconnectionsaremadetothesde.DEFAULTversionbydefault.Youmustchangetoauser-schemaversion.ClickChangeintheConnectiondetailssection.WhentheConnectionDetailsdialogboxopens,choosetheversionoftheuser-schemageodatabasetowhichyouwanttoconnect.Thiscouldbe<schema>.DEFAULToranyotherversionofthatgeodatabase.Forexample,iftheschemathegeodatabaseisinistubor,andyouwanttoconnecttotheqa77version,choosetubor.qa77fromthetransactionalversionlist.ClickOKontheConnectionDetailsdialogboxtocloseit.ClickOK.Typeanewnameforthespatialdatabaseconnection.PressEnter.3.直连SQLServer空间数据库YoucanuseadirectconnectionforanArcSDEgeodatabasestoredinSQLServer.Whenreadingthesteps,notethatthereareslightdifferencesinhowyoumakethatdirectconnectionbasedonthetypeofArcSDEgeodatabase.1)Double-clicktheDatabaseConnectionsfolderintheCatalogtree.2)Double-clickAddSpatialDatabaseConnection.IntheServertextbox,typethenameoftheserveronwhichtheSQLServerdatabaseresides.ToconnecttoanArcSDEgeodatabaseonadefaultinstanceofSQLServer,typethefollowingintheServicetextbox:"sde:sqlserver:<nameorIPAddressoftheserver>".ToconnecttoanArcSDEgeodatabaseonanamedinstanceofSQLServer,typethefollowingintheServicetextbox:"sde:sqlserver:<nameorIPAddressoftheserver>\<instance_name>".IfconnectingtoanArcSDEgeodatabaseonSQLServerExpress,typethefollowingintheServicetextbox:"sde:sqlserver:<server_name>\<instance_name>IINOTE:YoucouldalsocreateaspatialdatabaseconnectiontoanArcSDEgeodatabaseonSQLServerExpressbyright-clickingthegeodatabaseundertheDatabaseServersnodeandclicking。TypethenameofthedatabasetowhichyouwanttoconnectintheDatabasetextbox.Ifusingdatabaseauthentication,typeyourusernameandpassword.NOTE:YoucannotusedatabaseauthenticationforaconnectiontoanArcSDEgeodatabaseonadatabaseserver(aninstanceofSQLServerExpress).UncheckSaveusernameandpasswordifyoudonotwantyourlogininformationsavedwiththeconnection.Ifusingoperatingsystemauthentication,clicktheOperatingsystemauthenticationbutton.Thedatabaseauthenticationinformationbecomesunavailable.IfyouareconnectingtoanArcSDEgeodatabasewithadboschema,you