Operations of ASP on FoxPro free table (DBF file)

 
I. Question proposal
In a recent project, I encountered an ASP operation problem on the FoxPro database table (*. DBF. In reality, many applications use the DBF table and how to use the data in the network environment makes many friends unable to do anything.
I also checked a lot of information and did not find a detailed description of the solution. After testing, we have initially solved this problem and shared it with you.
This article attempts to solve the following problems:
1. ASP joins the free table generated by FoxPro (*. dbf file)
2. Save multiple types of data and graphic files to the dbf table at the same time.
(The sample program can be obtained from http://www.netop.cc/downloads/dbf.rar)
II. Environment
Windows2000 + IIS5.0 + IE6.0 (SP1)
The DBF file is a free table generated by Microsoft Visual FoxPro 6.0 (non-dbc database)
III. Solution
1. Connection
The ODBC Driver of the DBF file is named Microsoft Visual FoxPro Driver. In ASP, it is connected to it through the Connection object. Note that the directory where DBF is located is considered as the database name during Connection. The specific connection code is as follows:
     
DIM conn, connstr, db
Db = "data"
Set conn = Server. CreateObject ("ADODB. Connection ")
Connstr = "Driver = {Microsoft Visual FoxPro Driver}; SourceType = DBF ;"&_
"SourceDB =" & Server. MapPath (db) & "; Exclusive = No"
Conn. Open connstr
In the above code, data is the relative path (relative to the file where the code is located) of my DBF file, and is converted to an absolute path through Server. MapPath (db.
The http://www.connectionstrings.com provides many types of database table file connection strings, where for the DBF file, the given connection strings are:
"Driver = {Microsoft dBASE Driver (*. dbf)}; DriverID = 277; Dbq = c: mydbpath ;"
The connection string I used was not successfully connected and I did not perform further tests. If you are interested, try the above strings.