error message

I am trying to add data to a database and I am getting this message:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

/booking.asp, line 35

hese are the lines it refers to:

et Conn=Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER=Microsoft Access Driver (*.mdb) ;DBQ=" & Server.MapPath("HeenaA.mdb")

Please what have I done wrong

Just a clarification - is the DB "heenaA.mdb" in the same directory as that of the file????

yes it is

I think perphaps ur ODBBC drivers are corrupted u can download and install them again from microsoft's site.

Alternatively u can try this :

Code:

---

Conn.Open "Provider=Microsoft.jet.oledb.4.0;Data source=" & Server.MapPath("HeenaA.mdb")

---

Hope this helps

thanks I'll try that