This file will run a series of tests to establish the cause of any problems.
Test1 Your database connection string
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\websites\c4support.com\LBE Resource Booker\lberesbook.mdb
Test2 Your mail server type
SMTP
Test3 Your SMTP server name (this may blank)
mail.c4support.com:25
Test4 Your scripting engine
SUCCESS: Your scripting engine is up to date
Test5 Attempting to connect to the database
SUCCESS: Created ADODB.Connection
Test6 Attempting to open connection object
FAIL: Unable to open connection
Error number -2147467259 'C:\websites\c4support.com\LBE Resource Booker\lberesbook.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.
Test7 Attempting to create recordset object
SUCCESS: Created ADODB.Recordset
Test8 Attempting to open recordset object
FAIL: Unable to open Recordset
Error number 3709 The connection cannot be used to perform this operation. It is either closed or invalid in this context.
Test9 This file will run a test to create a jmail object.
SUCCESS: Created jmail object.Test10 Attempting to create custom object
FAIL: Unable to create custom object, you need to register lbebook01.dll with regsvr32.
Test11 Attempting to log in
FAILED: You must supply a Resource Type.
You must supply a Location
You must supply a user id