ADO problem with ASP Windows Vista - Programmers Heaven

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.