Hello

I usually use the following to connect to an online MS Access database from an online form, file.asp:

Code:
<%

Dim conn,rs,SQL,myMail,name,email,business,country,message

'Open MS Access database, store form field values

set conn=Server.CreateObject("ADODB.Connection")

conn.Open "driver={Microsoft Access Driver (*.mdb)};DBQ=C:\path hereFlashform.mdb;"

name = Request.Form("name_txt")
email = Request.Form("email_txt")
business = Request.Form("business_txt")
country = Request.Form("country_txt")
message = Request.Form("message_txt") 


SQL="INSERT INTO users (name, email, business, country, message) VALUES ('" & _
name & "', '" & email & "','" & business & "', '" & country & "', '" & message & "')"

conn.Execute(SQL)

conn.Close
Set conn=Nothing
However, my new hosting service has said I must create a ODBC DSN on the server - which I have now done (just the path).

Anyway, I'm not too sure what I am doing

What script should I use for ODBC, please in my file.asp?

Thanks.

Steve