开发环境MapXtreme2004+C#+Oracle Spatial
1.windows程序中连接oracle spatial方法
1
//连接数据库oracle spatial
2 MIConnection Connection=new MIConnection();
3 Connection.Open();
4 string connectionInfo = “SRVR=orcl_gissrv;UID=system;PWD=gis“;
5 ArrayList al = new ArrayList();
6 al.Add(“教学楼“);
7 al.Add(“宿舍楼“);
8 al.Add(“绿化设施“);
9 al.Add(“其他建筑“);
10
11 MapInfo.Data.Table [] tables=new MapInfo.Data.Table[al.Count];
12 TableInfoServer tis;
13 for(int i=0;i<al.Count;i++)
14
{
15
string tableName = (string)al[i];
16 tis=new TableInfoServer( tableName,connectionInfo,“select * from “+tableName,MapInfo.Data.ServerToolkit.Oci);
17 tables[i]=Connection.Catalog.OpenTable(tis);
18
}
19
20 MapControl1.Map.Load(new MapInfo.Mapping.MapTableLoader(tables));
21 Connection.Close();
//连接数据库oracle spatial2
MIConnection Connection=new MIConnection();3
Connection.Open();4
string connectionInfo = “SRVR=orcl_gissrv;UID=system;PWD=gis“;5
ArrayList al = new ArrayList();6
al.Add(“教学楼“);7
al.Add(“宿舍楼“);8
al.Add(“绿化设施“);9
al.Add(“其他建筑“);10
11
MapInfo.Data.Table [] tables=new MapInfo.Data.Table[al.Count];12
TableInfoServer tis;13
for(int i=0;i<al.Count;i++)14
{15
string tableName = (string)al[i];16
tis=new TableInfoServer( tableName,connectionInfo,“select * from “+tableName,MapInfo.Data.ServerToolkit.Oci);17
tables[i]=Connection.Catalog.OpenTable(tis);18
}19
20
MapControl1.Map.Load(new MapInfo.Mapping.MapTableLoader(tables));21
Connection.Close();2. 在asp.net 中，这种方法行不通：
Unable to open table.: Data access driver requested is not available: ORAINET.
说明: 执行当前 Web 请求期间，出现未处理的异常。请检查堆栈跟踪信息，以了解有关该错误以及代码中导致错误的出处的详细信息。
