I've been looking desperately for a solution to this error that keeps cropping up - it seems to be quite common with beginners. I am trying to connect to a remote host - the script I found in their FAQs is as follows:

DSN=DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.Mappath("filename.mdb")
OBJdbConnection.Open(DSN)


Since I got errors I have fiddled around with the code at present it looks like this:

Dim objConn,objRS,DSN
Set objConn = Server.CreateObject("ADODB.Connection")
Set objRS = Server.CreateObject("ADODB.Connection")

DSN = "DRIVER =(Microsoft Access Driver (*.mdb)};"
DSN = DSN & "DBQ=" & Server.Mappath("Emailing_List.mdb")
objConn.open

Can you think of any errors I might be making - could it be an error elsewhere in the code or would the only cause of error be found here? Or do you think it's likely to be a problem with the host?

Any pointers would be much appreciated!

Thanks,

Becky

You don't say what errors you are getting so all I can give you is some general pointers:
1. don't use that Microsoft Access driver in ASP, you should use the Jet OLEDB driver instead. See http://www.able-consulting.com/ADO_Conn.htm for examples.
2. make sure the relative path to your database is correct - your examples would only work if the database is in the same folder as the ASP page.

hth
Phil

Some hosting suppliers do not allow DSN-less connections, so it's always useful to know how to use them.

If I get this error message it usually means that the DSN is not correctly set up. This code works:

Set objDatabase = Server.CreateObject("ADODB.Connection")
objDatabase.Open "DSN=dbname"

where dbname is the System DSN name set up via ODBC Data Sources in Control Panel.

HTH
Pat

-------------------
System 3 2000 Limited
www.system3-2000.co.uk

Thanks Pat/Phil

Do I need to have the ODBC/DNS set-up on my system even if I'm trying to connect to a remote host?

If so could you tell me how to do it - I've looked in the control panel and could see nothing that looked obviously to do with ODBC connections. I'm using MS XP Home Edition.

Many thanks
:D

In XP its moved from Control Panel to Administrative Tools.

Choose Start > All Programs > Administrative Tools > Data Sources (ODBC)

Not sure about this but try...
From the start button
Start-->Run
then type in odbcad32.exe and click OK.