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!


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.