ADO problem with ASP Windows Vista

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")
'The next statement causes the error
'set rs = Server.CreateObject("ADODB.recordset")
'rs.Open "Select * from Customers", conn

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


Sign In or Register to comment.

Howdy, Stranger!

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