HTTP 500 - Internal server error ASP Error?

Question

<%

Set objConn = Server.CreateObject( "ADODB.Connection" )
objConn.Open "DSN=****;Uid=****;Pwd=****"
Set objRS = Server.CreateObject( "ADODB.Recordset" )
objRS.Open "SELECT * FROM passports WHERE sspnumber = 2075" objConn, 3, 1
If objRS.RecordCount > 0 Then
response.write "works"
Else
response.write "notthere"
End If

Set objRS = Nothing
objConn.Close
Set objConn = Nothing
%>

Can you tell me what could be causing this in my coding?

Answer 1

Break the code into parts.

Start with

Set objConn = Server.CreateObject( "ADODB.Connection" )
objConn.Open "DSN=****;Uid=****;Pwd=****"

If that works, add in

objRS.Open "SELECT * FROM passports WHERE sspnumber = 2075" objConn, 3, 1

If that works, add in

If objRS.RecordCount > 0 Then
response.write "works"
Else
response.write "notthere"
End If

If that works, add in

Set objRS = Nothing

If that works, add in

objConn.Close
Set objConn = Nothing

It will fail at one of those points. Report back which of those points it fails.

Answer 2

Try this

<%
Set objConn = Server.CreateObject( "ADODB.Connection" )
objConn.Open "DSN=****;Uid=****;Pwd=****"
Set objRS = objConn.Execute("SELECT * FROM passports WHERE sspnumber = 2075")
If Not objRS.EOF Then
Response.write "works"
Else
Response.write "notthere"
End If

objRS.Close
Set objRS = Nothing
objConn.Close
Set objConn = Nothing
%>


It could also be that your DSN isn't set up correctly...

However, without telling me the exact error, there's no way of being sure exactly what the problem is. If you don't see the full error, you're probably using Internet Explorer (try using a better browser like Firefox). If you must use Internet Explorer; turn off the "friendly error messages" option. If you have full logging enabled in IIS, you should be able to find the full error in your web server log files.

Answer 3

You forgot to put a comma before "objConn, 3, 1"

Your statement should be :
objRS.Open "SELECT * FROM passports WHERE sspnumber = 2075", objConn, 3, 1

Answer 4

Some of the common website errors you encounter when you are surfing the internet.
More details with the solution is available at http://errors.in/website.html