Print Page | Close Window

Connection String and MAILING

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=1862
Printed Date: 28 March 2026 at 5:59pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Connection String and MAILING
Posted By: plugnplay
Subject: Connection String and MAILING
Date Posted: 16 April 2003 at 5:15pm

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.

 




Replies:
Posted By: MorningZ
Date Posted: 17 April 2003 at 1:26pm
turn off http://www.morningz.com/sections/utils/showPage.aspx?PageID=32 - error 500 to have the asp engine tell you whats wrong....

better to let the web server do the research instead of guessing

-------------
Contribute to the working anarchy we fondly call the Internet



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net