k****h
发帖数: 27 | 1 I am using IIS 5.0 on windows 2000 to connect with access database.
It works if use the following code in the asp file
<% con= "Provider=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=g:\pvd.mdb">
<% set dbMain = server.createobject("ADODB.Connection")
dbMain.open con
Set rsProducts = Server.CreateObject("ADODB.Recordset")
sSQL = "SELECT * FROM products WHERE beginspecial <= #" & date() & _
"#" & " AND endspecial >= #" & date() & "#"
rsProducts.open sSQL, dbMain, adopenstatic, adlockpessimistic |
|
