Hello!
    I am learning ASP programming on my own. When I tried to connect MSSQL Server database IIS returned "HTTP 500 Internal Server Error". I replaced MSSQL with MS Access database the result was the same error. I have created a User DSN connection, IIS and MSSQL server is running perfectly. This Internal server error occurs only when I try to connect to database. Any one please give me the solution.

Arul Kumar.PA

__________________
Arul Kumar.PA

Please post the code used to build the connection.

HTTP 500 Internal Server Error is a generic error message. So it could be anything

kindly post the code!

Farzan Q.
BS(TeleCommunication)
Iqra University.

... and disable friendly error messages in Internet Explorer...

Here is the Source code:
------------------------

<%@ LANGUAGE="VBSCRIPT" %>
<%
    Dim Conn
    Dim SSS
    Dim SQL
    set Conn=Server.CreateObject("ADODB.Connection")
    set SSS=Server.CreateObject("ADODB.Recordset")

    Conn.Open "Test;UID=Administrator;PWD=india;"
    SQL = "select * from User_Details"

    SSS.Open SQL,Conn

    Do while Not SSS.EOF
        Response.write "<p>" & SSS("Name")
        Response.write "<p>" & SSS("EMail")
        Response.write "<p>" & SSS("Password")
        Response.write vbcrlf
        RS.MoveNext
    Loop

    SSS.Close
    Conn.Close
%>

** Kindly recommend me some websites to learn ASP and MSSQL Server **

Arul Kumar.PA

Did you disable the friendly error messages? And did you get a more detailed error description?

http://support.microsoft.com/default...;en-us;Q294807

Hai!

    :)Thanks for your replies. I disabled friendly error messages in internet explorer and got the following error.

ERROR MESSAGE:
   --------------

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

/SDB.asp, line 9


    As the error said Data source name not found I checked with my ODBC connections. All was fine. I recreated the DSN and finally did "Test Data Source" and result was as follows


AS RESULT OF TESTING:
---------------------

Microsoft SQL Server ODBC Driver Version 03.85.1022

Running connectivity tests...

Attempting connection
Connection established
Verifying option settings
Disconnecting from server

TESTS COMPLETED SUCCESSFULLY!

       The Data Source testing was successfull, the data source name that is given in the ASP file is the same as in ODBC, then what might be the problem. Is there any problem with the source code posted above. Any solutions please!

Arul Kumar.PA

IF I were you, I wouldn't have gone for a DSN based connection.

DSN, DSN-Less and OLEDB connection strings compared - adOpenStatic.com

Standard security connection string.
oConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
           "Dbq=c:\somepath\mydb.mdb;" & _
           "Uid=admin;" & _
           "Pwd="

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

Vijay: arulkumar is using MSSQL...;)

arulkumar: Check this site: http://www.connectionstrings.com/