Mapx 属性数据文件用oledb方式访问的问题

来源:互联网 发布:时间旅行者的妻子 知乎 编辑:程序博客网 时间:2024/04/30 14:19
mapx(mapinfo )的属性数据文件 .dat 文件,其结构是dbase 格式。
希望在程序中使用oledb方式进行直接访问,想不到不行。提示
ole/db   provider   returned   message:   microsoft   jet   数据库引擎找不到对象
但是如果把其扩展名改为.dbf ,就可以了。
这是怎么回事?

下面这两个帖子给出答案:
http://www.rentacoder.com/RentACoder/misc/BidRequests/ShowBidRequest.asp?lngBidRequestId=743901

http://www.msdner.com/dev-archive/25/12-45-251854.shtm

http://groups.google.com/group/microsoft.public.dotnet.framework.adonet/browse_frm/thread/be4b945515f298a/38cb5e6b0628afa5?lnk=st&q=dbase+file+extension&rnum=8#38cb5e6b0628afa5
-------------------------------------------------------------------------------------------------------------------------------------
其中:一个mvp
¤ Hey all, Was wondering if there is another parameter to pass along with the
¤ rest of the connection string to have Jet look for a dBase connection using
¤ something other than .dbf?
¤
¤ Here's my conn string for reference...
¤
¤ "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & cDataPath & ";Extended
¤ Properties=dBASE IV;"
¤
¤ We just happen to use the extension .DAT for all of our database files.
¤

I don't believe the driver will recognize the file with a different extension. There was a
workaround in DAO, by including the file and extension separated by #, but I don't believe that
works with Jet OLEDB and the ISAM driver. Haven't tried it using ODBC.

Paul ~~~ pclem...@ameritech.net
Microsoft MVP (Visual Basic)

--------------------------------------------------------------------------------------------------------------------------------------

其中还有人说把oledb 的Provider 换成 vfp 的,试了一下,还是不行,换为另外一个错误,说什么“重复字段名”

还有一个。问题与我一样,也是mapx 的dat 文件。
http://www.xtremevbtalk.com/archive/index.php/t-244908.html
有人提出要用txt driver .
原创粉丝点击