vfp数据库的asp连接请教,在线等。

请问,如何用asp进行vfp数据库的连接。dsn和dns-less的方式各为如何?
---------------------------------------------------------------

还真没连接过,关注ing...
---------------------------------------------------------------

找到一个例子,你试试:
Driver = "Driver={Microsoft Visual FoxPro Driver};"
SourceType = "SourceType=DBF;"
DBPath = "SourceDB=" & Server.MapPath( Directory )
dbconnstring=Driver & SourceType & DBPath
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open dbconnstring
---------------------------------------------------------------

1   
2set conn =Server.Createobject("ADODB.Connection")   
3conn.Open"DSN=carlos;UID=sa;PWD=;Database=pubs"   
4'......   
5set conn=nothing   

实际上数据库的连接语句就是以上的2,3句.它是用来打开已经在odbc 的控制面版中注册的数据库的.
如果,你无权在web 服务器上建立dsn ,那可以使用下面的方法.

1   
2set conn =Server.Createobject("ADODB.Connection")   
3conn.connectionstring="DRIVER={Microsoft Visual Foxpro Driver};Server=carlos;UID=sa;PWD=;Database=pubs"   
4conn.open   
5'......   
6set conn=nothing   
Published At
Categories with Web编程
comments powered by Disqus