http error

[outercircle]

hi
I am trying to install some banner ad software

on installing, i continue to get a http 500 error

is there any common things that i may be doing wrong

Do i have to setup any thing special on the host account (using windows)

Const DB_CONNECTION = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\Banner\Database\UltimateBannerASP.mdb;User Id=;Password=;"

or would i use

Source=\\

It also comes with access 97 and 2000 database, can i use 2000
plus it says to:
** NOTE: The anonymous IIS user must have WRITE permission to this file.

how do i ensure this when using a windows hosting plan

thanks

steven

[Brangwyn]

First of all make sure you turn off "show friendly http errors" in your browser. This can be found in your internet options -> advanced tab.

Once you do that you will get the full error message displayed in your browser. My guess is you do have the path wrong in the connection string which can easily be fixed.

Vortech has all folders with write permissions for IUSR_<machinename> enabled by default to it probably won't be that.

Post back once you have the full error message and I'll try and help out.

[outercircle]

hi
where do i find the internet options -> advance tab

[outercircle]

Hi
sorry thought you meant options in control panel, not ie6
lol - how silly do i feel

anyway

here is the error

Microsoft JET Database Engine error '80040e4d'

Cannot start your application. The workgroup information file is missing or opened exclusively by another user.

/banner/Include/Constants_inc.asp, line 27

i would have prefer to use the sql connection, however i have no expereince with sql

here is the install insturctions for your reference


The steps to install Ultimate Banner ASP are as follows:

Web Server Setup

a) Setting up the files. Unzip the files to a directory on the web server. If necessary, create a virtual directory to point to the application’s root directory. Note: this document assumes that it will be installed in a directory called "UltimateBannerASP" but you may change it.

The directory structure for the application is:

UltimateBannerASP – Contains .asp files that display banners and process banner clicks, and all files for administration section

Include – Contains all include files (_inc.asp extension)

Stylesheet – Contains stylesheets (CSS) for administration section.

Images – Contains all images

Help – Contains all help files

Database – Contains the MS Access database and all SQL scripts

The SQL scripts are not needed on the server, and can be removed after installing the application. Similarly, the Access databases in the "Database" directory can be removed if you are either using SQL Server or have moved the Access database to another location.

b) Default Document. The home page of the application is called index.asp. Your IIS web server should already be configured to use this page as one of the defaults. If not, either configure your web server to search for "index.asp" as a default page, or rename the home page to a file name that is used in the default file list for your web server. If changing the name of the file, you will have to edit the application's references to index.asp to the new file name.

c) Setting permissions. You will have to set "write" permissions on the folder that will contain your banners, so that you can upload banners through the Administration section. This folder is located at "UltimateBannerASP/Banners" by default

Database Setup

At this point, you must decide whether to use SQL Server or MS Access. If using MS Access, complete step 2a. If using SQL Server, complete steps 2b – 2f.

MS Access


a) The database, which has been fully populated with a username, is located in the "Database" directory. This folder contains two copies of the Access database. The version named UltimateSurveyASP.mdb is in Access 2000 format, and the version named UltimateSurveyASP-97.mdb is in Access 1997 format. Our recommendation is to use the version of the database in Access 2000 format, but both versions should work fine. ** NOTE: The anonymous IIS user must have WRITE permission to this file.

SQL Server


b) At this point, you may want to optionally create a new database for the application. If you decide not to create a new database and to use an existing database instead, note that all table names have the prefix "usd_" so that they can easily be distinguished from other tables in the database.

c) Load the tables into the database. The script for the tables is located in the file, "UltimateBannerTables.sql," which is located in the "Database" directory. The best way to load the tables is to open Microsoft Query Analyzer, open this file from Query Analyzer, and execute.

d) Create a user in the database for the UltimateBannerASP application. Grant this user full access to all of the tables.

e) Load the required data into the database. The script for the data is located in the file, "UltimateBannerData.sql," which is located in the "Database" directory. The best way to load the meta-data is to open Microsoft Query Analyzer, open this file from Query Analyzer, and execute.




Database Connection Setup

The application uses a DSN-less connection. The connection string is located in the file, "Connection_inc.asp" in the Include directory. This file contains two versions of the constant DB_CONNECTION. One of the versions is for connecting to a SQL Server database, and the other is for using a MS Access database. Above each constant are detailed comments for how to configure the connection string for your database. At this point, comment out the constant that you will not be using, and set up the connection string, as shown.

In the same file, "Connection_inc.asp," there is a constant called DATABASE_TYPE. Depending on whether you are using SQL Server or MS Access, the value for this constant must be updated to either "SQLServer" or "MSAccess", as appropriate. These values are noted in the comment above the constant.

[Brangwyn]

Is the database password protected ? if so do you have the correct logon name and password defined in your connection string /

[Brangwyn]

It also comes with access 97 and 2000 database, can i use 2000

Yes you can use the 2000 database, I would reccomend using it actually.

[outercircle]

what would u think the correct path is

is it

ata Source=\ultimateBannerASP\Database\UltimateBannerA SP.mdb;User Id=;Password=;"

when i use this one above, i get this error

Microsoft JET Database Engine error '80004005'

'C:\ultimateBannerASP\Database\UltimateBannerASP.m db' 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.

/ultimateBannerASP/Include/Constants_inc.asp, line 27


so i guess it is i just have to get the path right

for the path source can i use http://domainname.com/ultimatebannerasp/etc


thanks

[outercircle]

Hi
just reading instructions, require the
absolute path to the database path

any ideas.

thanks heaps for your help

steven

[Brangwyn]

Just run the following script from the same place you put the database in

<% Response.Write "Your Path is: " & Request.ServerVariables("PATH_TRANSLATED") %>

[outercircle]

thanks

how do i run this script

do i just paste in the the url

ie

www.domainame.com/database/<% Response.Write "Your Path is: " & Request.ServerVariables("PATH_TRANSLATED") %>

thanks

[outercircle]

hi
i made a page called page.htm with the script in it and uploaded to the same place as the database

on loading the page, it only shows a blank page (no errors)

thanks

[Brangwyn]

you must call the page .asp not .htm

[Silverbug]

The easyest way to achive this is to use the following code

strPath = "\Banner\Database\UltimateBannerASP.mdb"
'this is your reletive path to the file from the root of your website.

then in the connection string

Const DB_CONNECTION = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.mappath(strPath) & ";User Id=;Password=;"

the server.mappath will fill in the path details for you for that file. And ensure that you get the right path to the file.

Hope that helps.

[outercircle]

HI
Thanks i did work out that i had to use a asp page
Thanks for your help, got it working. it was that just needed to correct path.

thanks again for all your help

steven

[Brangwyn]

Glad to hear you got it working outercircle