Thank you for your response, however I do not have control over the server. I have Virtual hosting account from Go-daddy and no control on the settings.
So i found one of the treads here in this forum stating to try just a record set which reads data from the Access database. I did that ( code below ) and still the same problem?
This is very strange because I have another hosting account Identical to this one and loaded an e commerce shopping on that account and that one works right out of the box with no problem.
The connection string I use is this: sDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/access_db101/**********************.mdb").
The connection string for the one I have problem with is: MM_Con_STRING = sDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/access_db101/************.mdb") with a dim declaration of Dim MM_Con_String
Here is the Recordset code I used: Note I connect within Dreamweaver fine when I test the connection, however; I get the 500 server error when I load this page in the browser.
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<!--#include file="Connections/Con_Con.asp" -->
<%
Dim Recordset1
Dim Recordset1_cmd
Dim Recordset1_numRows
Set Recordset1_cmd = Server.CreateObject ("ADODB.Command")
Recordset1_cmd.ActiveConnection = MM_email_Con_STRING
Recordset1_cmd.CommandText = "SELECT * FROM Mail"
Recordset1_cmd.Prepared = true
Set Recordset1 = Recordset1_cmd.Execute
Recordset1_numRows = 0
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
</head>
<body>
<p><%=(Recordset1.Fields.Item("Email").Value)%>
</p>
<p><%=(Recordset1.Fields.Item("DateTime").Value)%></p>
<p><%=(Recordset1.Fields.Item("FirstName").Value)%>
<%=(Recordset1.Fields.Item("LastName").Value)%></p>
<p>
<%=(Recordset1.Fields.Item("PasswordEnc").Value)%></p>
</body>
</html>
<%
Recordset1.Close()
Set Recordset1 = Nothing
%>
