problem with IIS->access# Database - 数据库
k*h
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
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
It works if use the following code in the asp file
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