成语| 古诗大全| 扒知识| 扒知识繁体

当前位置:首页 > 数码科技

arcgis连接数据库失败

Q1:arcgis10.3挂接表格出现连接到数据库失败 常规功能故障 外部数据库驱动程序意外错误 怎解决

解决方法:
1.新建空白地图文档,给整个数据框定义上目标图层相同的地理坐标系。不要设置投影坐标系。由于导入的多为经纬度数据,给数据框设置单位为度(或者度分秒皆可)。
2.添加表数据。添加XY点数据(格式需为.xls)。
3.导出点数据,选择与数据框相同。
4.添加数据到目标数据图层,即可正常显示。

Q2:ARCGIS在连接sql数据库后,新建要素类时,错误:数据库中不存在空间类型,安装空间类型后才能创建要素类

安装sdeforsqlserver

WhenyouinstallSQLServerandArcSDEonseparateservers,therearethreethingstokeepinmind.

IfyouinstallSQLServeronadifferentcomputerthanArcSDE,ArcSDEactsasaclienttothedatabase.Tomakedirectconnectionstothedatabase,youmusthavetheSQLServerNativeClientinstalledontheArcSDEserver.TheSQLServerNativeClientyouinstallmustbeatleastthesamereleaseastheSQLServerdatabasetowhichyouareconnecting.Forexample,ifyouareconnectingtoaSQLServer2005database,installtheSQLServer2005or2008NativeClient.IfyouareconnectingtoSQLServer2008,installtheSQLServer2008NativeClient.YoucandownloadtheSQLServerNativeClientfromMicrosoftsWebsite.

2.BeawarethatifyouareusingWindows-Authenticatedusers(includingtheArcSDEadministrativeuser)toconnecttothedatabaseusinganArcSDEservice,youcannotinstallSQLServerandArcSDEonseparateservers.YouhavetwooptionsifyouwanttouseWindowsAuthentication:

InstallSQLServerandArcSDEonseparateserversbutonlyusedirectconnectionstoconnecttothegeodatabase.

InstallSQLServerandArcSDEonthesameserver.IfSQLServerandArcSDEareonthesameserver,itdoesnotmatterwhichtypeofconnectionyoumaketothegeodatabase.

3.IfyouwanttousetheST_Rasterstoragetype,whichcanonlybeusedinasingle-spatialdatabasemodelArcSDEgeodatabaseforMicrosoftSQLServer2008,youmustcopyspecificfilesfromSDEHOMEtotheSQLServercomputerbeforeinstallingorupgradingtheST_Rastertype.SeeInstallingtheST_RastertypeinaremoteSQLServerdatabaseforinstructions.

Q3:arcgis engin 如何与远程数据库连接

//先连接到工作空间
IWorkspaceFactory pWorkspaceFact = new SdeWorkspaceFactoryClass();
IPropertySet pPropertyset = new PropertySetClass();
pPropertyset.SetProperty ("Server", yourserver_name);
pPropertyset.SetProperty ("Instance",yourservice_name);
pPropertyset.SetProperty ("Database",youdatabase_name);
pPropertyset.SetProperty ("User",user_name);
pPropertyset.SetProperty ("password",password);
pPropertyset.SetProperty ("version","sde.DEFAULT");
IWorkspace pWorkspace = pWorkspaceFact.Open(pPropertyset,0);
//获取要素类
IFeatureWorkspace pFtworkspace = (IFeatureWorkspace)pForm1.pWorkspace;
IFeatureClass pFtClass = pFtworkspace.OpenFeatureClass(yourFeatureClassName);
//将要素类赋给图层
IFeatureLayer pFtlayer = new FeatureLayerClass();
pFtlayer.FeatureClass = pFtClass;
ILayer pLayer = (ILayer)pFtlayer;
//最后将图层加载进mapcontrol即可。

Q4:arcgis无法连接上数据库

你的数据库是安装在本机的,还是服务器上的?

Q5:在arcgis中创建企业级地理数据库失败,

是如何连接sql数据库吗,那就你可以去
看看ArcGIS中的ArcSDE这个软件,可以
和Oracle、sql server、DB2等数据库结合起来管理数据。
如果是建表的语言,那就是下面的例子 create table 表名 (id int, name char(10), age int )

WWW∴.bAzHIshI.coM

Q6:arcgis连接到数据库失败是什么原因?如何解决

有很多种原因1、数据库帐号密码错误、2、TCP/IP协议未启动3、数据库服务器关闭4、程序连接数据库用的文件或jar包丢失.....................你看一下到底是什么吧

猜你喜欢

更多