＝＝＝急！Asp。Net里面读取DBF文件和Excel文件的连接串到底怎么写？＝＝＝＝＝＝
是用odbc声明connection的
查过一些资料了，象
"Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=c:\mydbpath;"
"Driver={Microsoft dBASE VFP Driver (*.dbf)};UID=;SourceDB=" + SourceDB +";SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;"
上面这些都不行。着急啊。
请高手指点，谢谢
问题点数：50、回复次数：9Top
1 楼starry11（桃之夭夭）回复于 2005-06-02 10:58:55 得分 0
上面的连接串报告的错误分别是：
{"ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed\r\nERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr).\r\nERROR [01S00] [Microsoft][ODBC Visual FoxPro Driver]DriverID\r\nERROR [01S00] [Microsoft][ODBC Visual FoxPro Driver]SourceType" }
{"ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Fox Error 1\r\nERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed\r\nERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr)." }
Top
2 楼starry11（桃之夭夭）回复于 2005-06-03 08:34:49 得分 0
5555 没有人知道？Top
3 楼hchxxzx（NET？摸到一点门槛）回复于 2005-06-03 08:49:43 得分 10
string OLEDBConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\aa2.xls Extended Properties=Excel 8.0;";
Top
4 楼king4th0（壮壮）回复于 2005-06-03 08:58:41 得分 10
oledb的比较统一,差不多,楼上正解Top
5 楼renyu732（Sysinfo）回复于 2005-06-03 09:07:39 得分 10
string strConn;
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=C:\\Inetpub\\wwwroot\\contacts.xls;"+
"Extended Properties=Excel 8.0;";
OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [sheet1$]", strConn);Top
6 楼xiedan79（Sam Xie）回复于 2005-06-03 09:41:18 得分 10
自己按 .NET 的步骤做个 connection，然后把 conectionstring copy 一下不就可以了么Top
7 楼ye_zi（行到水穷处·坐看云起时）回复于 2005-06-03 10:02:39 得分 10
string strConn;
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=C:\\Inetpub\\wwwroot\\contacts.xls;"+
"Extended Properties=Excel 8.0;";
OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [sheet1$]", strConn);
应该可以吧Top
8 楼starry11（桃之夭夭）回复于 2005-06-03 11:26:50 得分 0
谢谢大家的热心帮忙 ^_^
不过，注意，我是用ODBC 哦Top
9 楼starry11（桃之夭夭）回复于 2005-06-03 15:16:41 得分 0
excel的这样写就可以了：
"Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=" + SourceDB + ";DefaultDir=d:\\File;"
可是，这样来操作excel文件的话，怎么样才能获取到excel文件里面的表格名呢？
Top
