MapXtreme2004 连接oracle spatial的问题(已解决)

在国内一直没有找到解决办法,也过e-mail问过两个人,但没有回复。最后,为了系统的的设计,到了不得不解决的时候。所以给MapInfo写了e_mail:

原文如下:

Dear sir:

First, let me introduce myself to you. I am a Chinese college student from Beijing. My English is not very well, but I have tried my best to make this letter to be more understandable.

I have downloaded the MapXtreme2004 v6.2 from your website www.mapinfo.com. I think it is the best GIS component for dotnet. I love it very much and I have explored many features of it.

But I came across a relatively difficult QUESTION. I can use it to connect to Oracle Spatial at Windows Application in Winform. But I can not use it to connect to Oracle Spatial at the asp.net web application.

The main SOURCE CODE is listed here:

MIConnection Connection=new MIConnection();

Connection.Open();

string connectionInfo = "SRVR=orcl_gissrv;UID=system;PWD=gis";

string tableName = "school";

TableInfoServer tis=new TableInfoServer( tableName,connectionInfo,"select * from "+tableName,MapInfo.Data.ServerToolkit.Oci);

MapInfo.Data.Table table=Connection.Catalog.OpenTable(tis);

MapControl1.Map.Load(new MapInfo.Mapping.MapTableLoader(table));

Connection.Close();

First I want to say that the Connection String is right. I have used the same code in the WinForm Application and it works perfectly. But I can not use it in the asp.net Web Application. The debug information is like this:

Unable to open table.: Data access driver requested is not available: ORAINET.

说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。

I do not know the reason why it can not works well. Can you give me a detailed instruction? My E-Mail: ***@sohu.com.

I eagerly expect the reply from you.

Yours

Sincerely.



 MapInfo的技术支持马上回复,虽然没有直接回答解决办法,但给了途径:试用版有问题,直接在forun上提问。回复如下:

Hello *** 

I am pleased that you like the product and thank you for the clear explanation of the problem.  General coding queries with the evaluation software need to be raised on the MapXtreme forum, so I would recommend that you post you question there.  Registration to the forum can be done via the following URL:


http://www.mapinfo.com/registration/discussions/index.jsp

I hope that is of assistance.

Regards ,

我去了一看,关于mxt2004的资料还真多(以前下载过全部的faq,也全部看了,但看到这里有这么多信息,还是吃了一惊)。就search了一下:oracle,乖乖,312条!可真把我乐坏了。这坚定了我mxt2004+oracle+.net的信心)在国内,一条都没有。(我天天在网上找oracle+mxt2004的资料,一条信息都没有找到过)。我一条一条啃,终于找到了解决方案。原文太长,贴上url:

http://www.mapinfo.com/registration/discussions/thread.jsp?forum=88&thread=5911&message=21999&q=6f7261636c65#21999

如果有什么mxt2004+oracle spatial的问题,欢迎与我交流。

原文地址:https://www.cnblogs.com/xiexiaokui/p/263459.html