AE连接SQLServer数据库

一些名词解释：

?Dbclient????????????? ?即DBMS类型，包括SQLServer 、Oracle10g 、Oracle11g 、PostgreSQL 、Informix 、DB2 、DB2ZOS

?Serverinstance? 对应下图的服务器名称

?Database??????????? 具体数据库

?authentication_mode? 身份验证方式，包括DBMS（有效用户名验证）和OSA（操作系统身份验证），默认为DBMS

?user ?????????????????? 用户名

?password??????????? 密码??

注：用户名和密码只在DBMS验证模式下才需要

AE连接到sql数据库有两种方式。

一．???????用IWorkspaceFactory或IWorkspaceFactory2的 Open 方法

?

Type factoryType=Type.GetTypeFromProgID("esriDataSourcesGDB.SqlWorkspaceFactory");

IWorkspaceFactory workspaceFactory =(IWorkspaceFactory)Activator.CreateInstance (factoryType);

IPropertySet connectionProps = new PropertySetClass();

connectionProps.SetProperty("dbclient","Oracle11g");

connectionProps.SetProperty("serverinstance","MyServer");

connectionProps.SetProperty("authentication_mode","DBMS");

connectionProps.SetProperty("user","MyLogin");

connectionProps.SetProperty("password","MyPassword");

IWorkspaceworkspace = workspaceFactory.Open(connectionProps,0);

?

二．????????????用IWorkspaceFactory2.OpenFromString方法

?

Type factoryType =Type.GetTypeFromProgID("esriDataSourcesGDB.SqlWorkspaceFactory");
IWorkspaceFactory2workspaceFactory2=(IWorkspaceFactory2) Activator.CreateInstance(factoryType);
String[] connectionProps = 
{
    "dbclient=SQLServer","serverinstance=MyMachineSqlExpress","database=MyDatabase","authentication_mode=OSA"
};
String connString = String.Join(";",connectionProps);
IWorkspace workspace = workspaceFactory2.OpenFromString(connString,0);

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!