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.

Please confirm you connection type. Is it System DSN or File DSN.

can we stick to the ONE thread for the same problem please.

http://www.webmaster-talk.com/asp-fo...ith-my-db.html