What's wrong with this simpel statement

Results 1 to 2 of 2

Thread: What's wrong with this simpel statement

  1. #1
    Join Date
    Dec 1969

    Default What's wrong with this simpel statement

    All,<BR><BR>The following code generates the error mentioned below (the code):<BR><BR><BR>Set conn= Server.CreateObject("Adodb.Connection")<BR>strconn ="driver={SQL Server};UID=123;PWD=xyz;DATABASE=db1;SERVER=server name"<BR>conn.Open strconn<BR><BR>Set rs = Server.CreateObject("Adodb.Recordset")<BR>strquery = "Select * from tablename"<BR><BR>Response.Write ("After")<BR>recordset.Open strquery, conn<BR><BR>Response.Write (rs.Recordcount)<BR><BR>set conn=Nothing<BR>set rs=Nothing<BR><BR><BR>ERROR<BR><BR>There is a problem with the page you are trying to reach and it cannot be displayed. <BR><BR>--------------------------------------------------------------------------------<BR><BR>Please try the following:<BR><BR>Click the Refresh button, or try again later.<BR><BR>HTTP 500.100 - Internal Server Error - ASP error<BR>Internet Information Services<BR><BR>--------------------------------------------------------------------------------<BR><BR><BR>Thanks in advance<BR><BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: What's wrong with this simpel statement

    Turn of &#039;Friendly HTTP errors&#039; in the browser or turn on &#039;Display detailed error messages&#039; in the IIS management console. Then you will get much more detailed error messages.<BR><BR>Also, try to connect to the server using OLEDB connections, they are better, for more info:<BR><BR>http://www.able-consulting.com/ADO_Conn.htm

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts