Web Wiz Mailing Help

[EmmaGale]

I would like to set up a subscription based mailing list on my site. Its for a charity that we have set up in response to the Tsunami disaster. We will be holding future events and want to be able to email subscribers with this news.

The index page is displaying the box properly, but when I go to subscribe i get the following message:

Microsoft JET Database Engine error '80004005'

'e:\kunden\homepages\45\********\*****\db\mailing_ list.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

/mailing_list/common.asp, line 178

I think this is something to do with setting up the vritual or physical path but whichever I use it doesnt seem to work:

Virtual: Server.MapPath("/db/mailing_list.mdb")

Physical: "http://www.***.websitehome.co.uk/db/mailing_list.mdb"

I am also getting the same error when I try and connect to the admin page.

Any help will be greatly appreciated.
With best wishes
Emma Gale

[paulhiles]

Hi Emma,

Two quick questions... any chance of a URL? Are you sure you're able to run ASP scripts?

One way to check the path to the database is:
1) Save the following snippet as 'GetDBPath.asp'

<%
'use this file to get the the full path to the database
Response.Write Server.MapPath("mailing_list.mdb")
%>

2) Upload to the same "db" directory as your mailing list database and run the file.

Let me know how you get on, yeah?

Paul

[EmmaGale]

Hi Paul,

The URL is www.weysia.co.uk

I have the database in a different path though for security. Not that its secure now eh :)

http://www.s114085044.websitehome.co.../GetDBPath.asp

For some reason when I run the script above, it is telling me:

You have attempted to execute a CGI, ISAPI, or other executable program from a directory that does not allow programs to be executed.

I know I can run ASP scripts becuase I am running Snitz forums in the same site!

Thanks for your reply Paul,
Emma

[paulhiles]

Could be the permissions on the database folder need to be changed. You need to be able to have read/write access for most databases.

If the server can run ASP scripts, then the permissions seem to be the likely culprit. Have you modified the "common.asp" file to point to your database location?

Paul

[EmmaGale]

As far as I know the permissions to that particular file have already been set. I am running my database on the Snitz forum from the same folder. The database works fine for that.

I think it is to do with the path. I have obvoiusly commented one of these out within the common.asp file but these are the current settings:

Virtual: Server.MapPath("/db/mailing_list.mdb")

Physical: "http://www.s114085044websitehome.co.uk/db/mailing_list.mdb"

The virtual one is the same path that I am using in the asp file for the snitz forum whcih again works fine.
cheers emma

[paulhiles]

There needs to be a period (full stop) in the "Physical" location above.

http://www.s114085044.websitehome.co.uk/db/mailing_list.mdb

I'm sure you're right, and it has to be a path issue, but it's got me stumped at the moment.
Trial and error, see if it makes any difference removing the start slash.. just try anything! :o)

Paul

[EmmaGale]

Yep that was an error!

I have tried and errored - all morning :)

Still can't get it working

If anyone has any ideas I would be really grateful.

Many thanks
em