• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 701
  • Last Modified:

Dreamweaver cs4 classic asp dsn sql 2008 http 500 error

Just starting out with classic asp (need to support an old website) Getting a HTTP 500 error when I add a recordset to the webpage. Works fine with an equivilent MS Access database.

Sql DSN passes test connection and passes test/shows recordset, but the very fact the recordset is attached to the page throws the error even before trying to place a field. The driver for the sql 2008R2 system dsn is sql client (have tried sql server, same problem)

Can anyone point me in the right direction, may thanks
0
downehouse
Asked:
downehouse
  • 3
  • 3
1 Solution
 
Carl TawnSystems and Integration DeveloperCommented:
Start by turning off "Show Friendly Http Errors" in your browser. That way you will be able to see the actual error message rather than the generic 500 message.
0
 
downehouseAuthor Commented:
Thanks, good point, but had already done this, what I had not done was to change IIS 7.5 'Send Errosrs to Browser' setting to true.  Having done this the error is with the DSN on line Recordset1_cmd.ActiveConnection. However the DSN checks out OK when tested at the created stage.

I have the following code:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<!--#include file="Connections/Merlin.asp" -->
<%
Dim Recordset1
Dim Recordset1_cmd
Dim Recordset1_numRows

Set Recordset1_cmd = Server.CreateObject ("ADODB.Command")
Recordset1_cmd.ActiveConnection = MM_Merlin_STRING (**** error on this line)Recordset1_cmd.CommandText = "SELECT BulletinID, BulletinDate, BulletinBody, PostedBy FROM dbo.BULLETIN"
Recordset1_cmd.Prepared = true

Set Recordset1 = Recordset1_cmd.Execute
Recordset1_numRows = 0
%>

The include file code is as follows..
<%
' FileName="Connection_odbc_conn_dsn.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_Merlin_STRING
MM_Merlin_STRING = "dsn=Merlin;"
%>

Any help appreciated (Runing Dreamwearver CS4 on Win 7, with SQL server 2008 R2)
0
 
Carl TawnSystems and Integration DeveloperCommented:
What is the error?
0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
downehouseAuthor Commented:
Sorry..

error '80040e4d'

/avalon/index_tmp.asp, line 9
0
 
Carl TawnSystems and Integration DeveloperCommented:
Have you tried with a DSN-less connection?
0
 
downehouseAuthor Commented:
Have now, it works, shame DSN would not play ball.  Thanks for the quick responses.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now