Data Connection WOES!

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:)

What DOES that code do?

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.