DBF?? /?? FoxPro????
??? ODBC????
???
???
??? standard:??
???
? "Driver={Microsoft?? dBASE?? Driver?? (*.dbf)};DriverID=277;Dbq=c:\mydbpath;"????
???
???
???
??? OLE?? DB,?? OleDbConnection?? (.NET)????
???
???
??? standard:??
???
? "Provider=Microsoft.Jet.OLEDB.4.0;Data?? Source=c:\folder;Extended?? Properties=dBASE?? IV;User?? ID=Admin;Password="????
???
???
???
??? Visual?? FoxPro????
??? OLE?? DB,?? OleDbConnection?? (.NET)????
???
???
??? Database?? container?? (.DBC):??
???
? "Provider=vfpoledb.1;Data?? Source=C:\MyDbFolder\MyDbContainer.dbc;Password=MyPassWord;Collating?? Sequence=machine"????
???
???
???
??? Free?? TABLE?? directory:??
???
? "Provider=vfpoledb.1;Data?? Source=C:\MyDataDirectory\;Password=MyPassWord;Collating?? Sequence=general"???
? Read?? more?? (Microsoft?? msdn)?? >>??
??? ODBC????
???
???
??? Database?? container?? (.DBC):??
???
? "Driver={Microsoft?? Visual?? FoxPro?? Driver};SourceType=DBC;SourceDB=c:\myvfpdb.dbc;Exclusive=No;Collate=Machine;"????
???
???
???
??? Free?? TABLE?? directory:??
???
? "Driver={Microsoft?? Visual?? FoxPro?? Driver};SourceType=DBF;SourceDB=c:\myvfpdbfolder;Exclusive=No;Collate=Machine;"????
? "Collate=Machine"?? is?? the?? default?? setting,?? for?? other?? settings?? check?? the?? list?? of?? supported?? collating?? sequences?? >>??
???
? Microsoft?? Visual?? Foxpro?? site:?? http://msdn.microsoft.com/vfoxpro
zys59dim?? conn,strConn??
? set?? conn?? =?? server.createObject("ADODB.connection")??
? conn.connectionString?? =?? "Provider=Microsoft.Jet.OLEDB.4.0;Data?? Source=d:\twotab;Extended?? Properties=dBASE?? IV;User?? ID=Admin;Password="???
? conn.open??
? 我用這段話把Connection對(duì)象建立起來了，沒有提示錯(cuò)誤。??
? 然后我寫了如下的話：??
? dim?? rs,strSQL??
? set?? rs?? =?? server.createObject("ADODB.recordSet")??
? strSQL?? =?? "select?? *?? from?? abcd"??
? rs.open?? strSQL,conn,1,3,1??
? abcd是我的vfp_test.dbc下的一個(gè)表，存為abcd.dbf，系統(tǒng)提示如下：??
???
? Microsoft?? JET?? Database?? Engine?? 錯(cuò)誤?? '80004005'????
? 外部表不是預(yù)期的格式。????
? /twoTAB/linkVFP.asp，行?? 10????
? 請(qǐng)問這是怎么回事？??
?
zys59大家?guī)兔Π。植粔蚩梢栽诩樱也耍抑保x謝了，幫忙頂也給分了
ybfqlyq試下這個(gè)連接。??
? set?? adocon=Server.Createobject("adodb.connection")??????
????? adocon.open"Driver={microsoft?? Visual?? Foxpro?? driver};sourcetype=DBC;sourceDB=*.dbc;Exclusive=No;"??????
???
???
? ------------------??
? http://www.ybfq.net/article/show.asp?id=2011
liuxiaoyi666www.connectionstrings.com
zys59<%??
? dim?? conn,strConn??
? set?? conn?? =?? server.createObject("ADODB.connection")??
? conn.connectionString?? =?? "Driver={Microsoft?? Visual?? FoxPro?? Driver};SourceType=DBC;SourceDB="&server.mapPath("database/vfp_test.dbc")&";Exclusive=No;"????
? conn.open??
???
? dim?? rs,strSQL??
? set?? rs?? =?? server.createObject("ADODB.recordSet")??
? strSQL?? =?? "select?? *?? from?? abcd"??
? rs.open?? strSQL,conn,1,3,1??
? %>??
? 我的數(shù)據(jù)庫(kù)結(jié)構(gòu)和上貼相同，語句如上，實(shí)現(xiàn)了對(duì)VFP數(shù)據(jù)庫(kù)的操作。??
? 在這之前我安裝了VFPODBC5.0和MDAC2.7，不知道是哪個(gè)管用了。有類似情況的可以試一下。
zys59abcd是我的vfp_test.dbc下的一個(gè)表，存為abcd.dbf
zys59謝謝大家?guī)椭m然還沒弄明白到底是什么起了作用，但好歹實(shí)現(xiàn)了對(duì)VFP的控制，高興！再次對(duì)大家表示感謝。

連接Foxpro數(shù)據(jù)庫(kù)