Hi,
I'm new at this and need some help. Trying to build a simple DB for my daughter's club. Created an account with Godaddy.
Here is my problem: Everything works until I hit the final "Submit" and the following shows on my screen:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
General error: Invalid file dsn ''
/Fencing/exoadd.asp, line 15

Here is my code:
<%
Dim adoCon
Dim sql
Dim connectstr, sDSNDir
Dim dsn_name
dsn_name = "access_fencing.dsn"
sDSNDir = Server.MapPath("_dsn")
connectstr = "filedsn=" & sDSNDir & "/" & dsn_name
Set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.Open connectstr

Have a DSN file named access_fencing.dsn
DB name is fencing.mdb in a folder named access_db
The rest of my files are in folder named Fencing

What am I doing wrong?

Thank you in advance.

is the file in a folder called "_dsn" within the site folders?

the slash should be the opposite way

connectstr = "filedsn=" & sDSNDir & "\" & dsn_name

as this is a physical path.

I don't have a folder called _dsn. Here is the structure:
Folder - Root
Folder - access_db containing file "fencing.mdb"
Folder - Fencing containing files: "exo_confirm.asp", "exoadd.asp" and "exoform.htm"

Tried with the slash in the oposite way and got the same error message.

I don't have a folder called _dsn

this code;

sDSNDir = Server.MapPath("_dsn")
connectstr = "filedsn=" & sDSNDir & "/" & dsn_name

is telling the server to find a folder called "_dsn" and look for the DSN file in it.

Dean,

I attempted another way based on your posts.

Back up your existing file. Use the below code instead of what you provided on the first post.

<%
Dim adoCon 
Dim sql
Dim connectstr, sDSNDir
connectstr="Driver={Microsoft Access Driver(*.mdb)};DBQ=" & Server.MapPath("/access_db/fencing.mdb")
Set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.Open connectstr
%>

Hope this helps . Good Luck!