Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

ADO problem with ASP Windows Vista

Hi
I'm trying some examples from w3schools: ASP, ADO, ACCESS with Windows Vista.
The problem is this: When I run the code (pasted below), the connection method Open generates an error HTTP 500. It never worked, nor if I used ODBC.
Using Visual Basic with the same code (without "Server." and so on), always worked.
My code:



<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
'The next statement causes the error
conn.Open(Server.Mappath("/db/northwind.mdb"))
'set rs = Server.CreateObject("ADODB.recordset")
'rs.Open "Select * from Customers", conn

'do until rs.EOF
' for each x in rs.Fields
' Response.Write(x.name)
' Response.Write(" = ")
' Response.Write(x.value & "<br />")
' next
' Response.Write("
")
' rs.MoveNext
'loop

'rs.close
'conn.close
%>



Sign In or Register to comment.