-
When I test this code in InterDev for an .asp page I get this error:
An exception of type "Microsoft Database Engine : Unspecified Error' was not handled.
then it singles out this line of code
Any ideas what's wrong?
Code:
.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\ryyyya\yyyy.org\Emailer\Emails.mdb;Persist Security Info=False"
here is code before it
Code:
Dim Dconn, sSQL, sSQL2, cmDC, SQL, SQL2, Recordset
Set Dconn = Server.CreateObject("ADODB.connection")
Dconn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\ryyyya\yyyy.org\Emailer\Emails.mdb;Persist Security Info=False"
-
There is nothing wrong with your code just put a
Code:
Response.Expires = 0
at the top of your program and it should work:)
-
-
When I run the debug in INterDev, this new code does bypass the original problem area but now breaks in another line farther down in the code and gives me the same error as before!
Here is the line it breaks on:
Code:
For count = 0 to 5
if MyEmail(count) <> "" then
sSQL2 = "INSERT into Recipient(Email, SenderID)VALUES('" & MyEmail(count) & "'," & Recordset.fields("AID") & ")"
Dconn.Execute sSQL2
'Response.Write "sSQL2 = " & sSQL2 & "<BR>"
end if
Next
This is where I am trying to insert the emails into the DB. Maybe it is breaking because the emails exist already and it doesn't like it. It's ok with me if the emails already exist so that is not an issue.