vfp數據庫的asp連接
找個例子試試:
Driver =" Driver = { Microsoft Visual FoxPro Driver };"
source type =" source type = DBF;"
DBPath =" SourceDB =" & Server。MapPath(Directory)
dbconnstring = Driver & source type & DBPath
Set conn = Server。CreateObject("ADODB。connection")
conn . Open dbconnstring
設置conn =服務器。Createobject("ADODB。connection")
conn . Open" DSN = Carlos;UID = saPWD =;Database = pubs"
'...
set conn = nothing
% >
其實數據庫的連接語句就是上麪的2、3句話。它用於打開在odbc控制麪板中注冊的數據庫。
如果,您無權在web服務器上設置dsn,那麽您可以使用下麪的方法。
set conn = server . createobject(" adodb . connection")
conn . connectionstring =" Driver = { Microsoft Visual FoxPro Driver };服務器=卡洛斯;UID = saPWD =;database = pubs"
conn . open
'......
set conn=nothing
% >
0條評論