I downloaded Web Wiz News, installed it and it runs 'on the fly'.
Web Wiz Mailing does not, while - as far as I can see - the connection/configuration file 'common.asp' is basically identical... Here follows a copy:
'Initialise the strAccessDB variable with the name and the path to the Access Database
strAccessDB = "mailing_list.mdb"
'Create a connection odject
Set adoCon = Server.CreateObject("ADODB.Connection")
'------------- If you are having problems with the script then try using a diffrent driver or DSN by editing the lines below --------------
'Database connection info and driver (if this driver does not work then comment it out and use one of the alternative drivers)
'strCon = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=e:\admin.eurolarge.com\site\mailing\mailing_list\mailing_list.mdb;"
'Alternative drivers
'strCon = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=E:\admin.eurolarge.com\site\mailing\mailing_list\mailing_list.mdb" 'This one is for Access 2000
'If you wish to use DSN then comment out the driver above and uncomment the line below (DSN is slower than the above drivers)
'strCon = "DSN=mailing" 'Place the DSN name after the DSN=
I tried about all different options for the connection, all resulted in 500 internal server error (after uncommenting one of them, and yes, I have made a DSN connection named 'mailing'.
Any idea how to find a solution?
The server is a Win2K server of my own.