SalesCart PRO1.0, Setup and Common Problems
This FAQ is being updated on a regular basis, come back
and check for new issues, and tips.
Note: sometimes error message
wording may not be 'exactly' the same as that listed below.
Common Problems
Cannot add (SalesCart) product
link in the "insert FrontPage Component" selection box, it doesn't exist!
HTTP Error 403 403.1 Forbidden:
Execute Access Forbidden. This error can be caused if you try to execute a CGI,
ISAPI, or
other executable program from a directory that does not allow programs to be executed.
Microsoft OLE DB Provider for ODB Drivers
error 80004005....operation must use an updatable query.
When I try to open my web at http://my-machine-name
I get the following error, "There is no server on port 80:".
I have plenty of disk space but
I get the following disk space error when I try and install the software:
"Not enough Disk Space" Dialog box: Not enough disk space
on the target while attempting to copy files.
To continue first free disk space on the target drive then click OK.
I'm trying to install Option
Pack 4.0 so that I can install SalesCart. However, Option Pack 4.0
keeps stoping half-way through the install complaining that it was unable to
write and initialize the Transaction server in the registry.
I'm trying to install
SalesCart. However,
the SalesCart install is complaining that Option Pack 4.0 (MTS).... is not
installed.
When I start building my
SalesCart Pro web and finish the wizard, I get the following error: Runtime
Error 75
I am getting:Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
I get this error: Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] '(unknown)' 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
Q. I get this error when I click on the order confirmation page.
Microsoft VBScript runtime error '800a004c'
Path not found
/cgi-bin/merc-conf.asp, line 28
Line 28 is: Set a = fs.OpenTextFile(myheader)
When I add an item to an order and select a quantity greater than one, it is
not
calculating the total quantity when its figuring out the shipping.
-
I upgraded from a previous version of SalesCart and now have
SalesCart Pro installed but it appears that parts of SalesCart still show up.
When I click on the confirm button, I get this error: Microsoft VBScript runtime error
'800a01ad'
ActiveX component can't create object: 'CDONTS.NewMail'
/colorfinishesoftexas/cgi-bin/merc-conf.asp,
line 35
-
I get this error after clicking on the Add button
to add a product:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file
already in use or you do not have permission to view its contents.
/cgi-bin/shop1.asp, line 129
Provider error
'80004005'
Unspecified error
/gifts/cgi-bin/GetOrder.inc, line 30
Microsoft OLE DB Provider for ODBC Drivers error
'80004005'[Microsoft][ODBC Microsoft Access Driver]
Could not use '(unknown)'; file already in use.
/gifts/cgi-bin/GetOrder.inc, line 30
When I try to install
SalesCart/SalesCart Pro, I get this error message
Active Server Pages (ASP) Not Found and it is required to run SalesCart!
Simple Option Text Field produces
no output in checkout process or in the shop.mdb database.
20. Runtime
Error 75 during creation of new SalesCart Web using WINDOWS
2000
21. When adding item to cart
receiving:Microsoft VBScript runtime error '800a000d' Type mismatch:
"session" /cgi-bin/shop1.asp, line 129 or line 135 22.
Will SalesCart work with different localized and international
versions of FrontPage 2000? 23.
WINDOWS
2000 Receiving the following error after clicking the 'Add Items' icon:
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
Technical Information (for support personnel)
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x2b0 Thread 0x41c DBC 0x1f79e04 Jet'.
/salescart/cgi-bin/shop1.asp, line 137
24. I get this error when I
click on a product link.
Microsoft OLE DB Provider for
ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access
Driver] '(unknown)' 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.
/cgi-bin/shop1.asp, line 129
Answers
I can't add (SalesCart)
product link in the "insert FrontPage Component" selection box, it doesn't
exist!
Answer: This is a "feature" of
FrontPage and the purpose appears to be to protect you from installing software from
someone you don't know which turns out to be a virus or something worse.
To make the
component show up, follow these directions.
Directions:
First, open FrontPage
Explorer on the Windows95 (client) machine where SalesCart is installed.
Select
Open Web, then type http://127.0.0.1 in the field marked "Web Server".
After typing in http://127.0.0.1, press the Enter Key. In
FrontPage Explorer, click on Tools, then on web settings and view the FrontPage Web
settings. Click on the configuration tab and view the Web Name.
If the
field is not "grayed" out or contains a name, repeat the above procedure because
you don't have the root web opened.
Once you have confirmed that the web name is grayed out, select
Tools and Recalculate Hyperlinks from the FrontPage Explorer menu. Edit one of the pages and select the component from the Insert menu.
The
first time it will warn you that you are installing foreign software, click OK on the box
and continue.
There are two possible causes of this problem. They both have
to do with the permission settings of the WEB site. The first has to do with your Front
Page permissions. The second is the permission settings for the IUSR_servername account
set at your WEB hosting company.
To set the Front Page permissions, open Front Page Explorer and
open the SalesCart web site you are working on, do the following;
In FrontPage explorer select 'Folders' view. Expand the list
under the folder 'http://127.0.0.1/test' by pressing the '+'.
The following folders need to have their permissions set:
'cgi-bin'; 'mall'; and 'fpdb'.
To change the permissions of the folders, right click on the
folder and select properties. You will see the following, (mall directory used for
example):
All three boxes (only two boxes will appear on some WEB
sites) should be checked. This allows programs and scripts to be run and files to be
browsed.
The 'fpdb' directory should have the 'Allow files to be
browsed' box unchecked. This prevents users from seeing your orders database,
'shop.mdb'.
Apply the changes to each directory.
If the above settings are correct and you still get an
error, you will need to contact your web hosting provider; To have your web
hosting company change the permissions of your IUSR_servername account; Call you web
hosting company and ask to have the permissions for the IUSR_servername account changed to
'CHANGE' for the 'cgi-bin'; 'mall'; and 'fpdb' (or 'orderdb') directories of your web.
The key here is the "operation must use an updatable query".
The error is stating that an update is not being allowed. This is a permission issue. The
answer is the same for the; HTTP Error 403 403.1 Forbidden:
Execute Access Forbidden. This error can be caused if you try to execute a CGI, ISAPI, or
other executable program from a directory that does not allow programs to be executed.
.
This is due to your Microsoft Personal Web Server either being off, or not installed
properly. If you have PWS installed select the PWS properties from control panel or the
taskbar and make sure it's running. If the PWS is installed and running, and you still get
the error contact Microsoft Technical Support
. If the PWS was not previously installed, see the downloads section of this support site.
"Not enough Disk Space" Dialog box:
Not enough disk
space on the target while attempting to copy files.
To continue first free disk space on the target drive then click OK.
The error means that you do not have FrontPage installed or do not have
the correct version of FrontPage installed for the particular software
version you have downloaded. The program believes theres not enough
space because you are trying to install the software to a place where the
software your suppose to have resides but doesn't.
Solution: Install the correct version of FrontPage2000 before installing the software.
This is a bug in PWS. Microsoft documents this on their web site at http://support.microsoft.com/support/kb/articles/Q246/0/81.ASP?LNG=ENG&SA=ALLKB&FR=0
Solution#1:
The error is an error with Option Pack 4.0 and with Windows98.
There is a second version of Option Pack 4.0 from Microsoft that corrects
this problem. The specific problem has to do with the
MTSSETUP.DLL file.
Oddly enough the 'new' dll file has the same version # as the 'old' one
but the file sizes are different. The URL where to download this file is
listed below. If PWS4 is working, we suggest you DO NOT bother with this
patch.
Click here to get the updated patch/file.
Place this file in the same folder that has the setup.exe file for PWS4. If
your running it off the CD you'll have to copy the contents of the folder
onto your HD.
Detailed Instructions to patch
Microsoft Option Pack 4.0 CD Install
- Create a temporary directory on your c:\ drive.
Open File Manager by clicking on Start, then programs then Windows
Explorer. Click on C:\ and then File, New, Folder, type in the new
name of the folder as fixpws.
- Insert your windows98 CD into the drive of your
computer. Highlight the CD drive "x" for the CD, open the
add-ons folder and then double click on PWS. Select Edit and then
Select all from the Menu and then Edit and Copy
from the menu and then go to the C:\fixpws folder and select Edit and
then Paste from the Menu.
- Highlight the C:\fixpws
folder and on the right side of Windows Explorer select the mtssetup.dll
file and press the delete button.
- Download the mtssetup.dll file from the link shown
above (http://www.salescart.com/support/files/mtssetup.dll and copy it to the
C:\fixpws
folder and overwrite the existing file if you did not delete it.
- Now click on Start and Run and type C:\fixpws\setup.exe
and select OK.
Solution#2:
You can also simply repair the registry.
We recommend Solution #1,
but this method is quicker. Simply click below, download the file,
then double click on the file and install the registry patch.
PWS Transaction Server Registry Patch
There are two possible causes for this problem:
- You really don't have Option Pack 4.0 installed.
- You have a "bad" installation of Option Pack 4.0 installed.
Troubleshoot this problem first by determining what version of PWS you
have installed. We really suggest that you read the manual for this
because it contains a lot of information on this subject.
Click on Start, then control panel, if you have an Icon labeled Personal
Web Server...you have the old incorrect version of the web server which is
really now obsolete. Refer to the manual. You can download a copy
of the manual even if you do not currently have the software by going
here.
If not, then click on Start then Find Files and search for the file pws.exe
in the Windows\system folder. If you have that file, then you problem is
that you have a "bad" installation of Option Pack 4.0. Refer
to FAQ #22. If you do not have that file, then you have not installed Option
Pack 4.0. Refer to the manual. You can download a copy of the
manual even if you do not currently have the software by going
here.
There is no default FrontPage temporary working directory.
Normally,
this is located in the default location and you can create a folder in the following location.
C:\Program Files\Microsoft FrontPage\temp
However, if you have uninstalled FrontPage and then subsequently
installed it to a different directory, you may have a damaged frontpg.ini
file. Do the following:
Use FindFile to locate your frontpg.ini file.
Its usually located
in c:\windows
When you open that file with Textpad, it should look something like the
following, yours probably won't
[FrontPage 3.0]
SMTPHost=mail.somebody.com
MailSender=no-one@anywhere.com
FrontPageRoot=C:\Program Files\Microsoft FrontPage
FrontPageLangID=0x0409
UILangAbbrev=enu
NoAbsoluteFileResults=1
NoServerFileResults=1
BotCacheDir=C:\Program Files\Microsoft FrontPage\BotCache
CheckedHostName=java
HostOverride=localhost
PWSRoot=C:\FrontPage Webs
Notice FrontPageRoot=C:\Program Files\Microsoft FrontPage (line 3 of
the ini file above).
Create a temp folder using windows explorer just below the FrontPageRoot
specified in the .ini file. If there is no FrontPageRoot, specify one
as shown above and create the default /temp folder.
Your ISP needs to give the
IUSR_machine name account Change (RWXD) permission to the /fpdb folder or the
folder where shop.mdb is located in on your web. Note: In some
cases, your ISP where IIS is incorrectly installed and the server is using the
Everyone account instead of the IUSR account, your ISP will need to give
Everyone Change (RWXD).
There are a number of different causes we have discovered for this.
The
most common problem is listed as #1.
Solution#1:
The path you have specified for the location of your database in
your web site is not correct. The most common mistake is that you have
used a URL instead of an absolute disk path. You will need to edit the
file global.asa in your web and change it for the absolute disk path to your
shop.mdb database. Contact your ISP to find out the path.
Before: Session("ConnectionString") = "Driver={Microsoft Access driver
(*.mdb)};dbq=http://www.jacksonholewyoming.com/fpdb/shop.mdb;"
to
After: Session("ConnectionString") = "Driver={Microsoft Access driver
(*.mdb)};dbq=c:\webshare\wwwroot\protest\fpdb\shop.mdb;"
Solution#2:
Your ISP has the incorrect version of MDAC (Microsoft
Data Access Components installed on the server or the version is
not correctly installed). Have your ISP do the following:
Go to Start, Programs, Control Panel, and then click on ODBC.
Select
Drivers and ensure that the ODBC version you have is 4.00.4200.00 or
greater. If not, go to http://www.microsoft.com/data
and download the latest version of MDAC and install it on your server. If
it the version is correct, then continue as follows:
There is a bug with the installation of MDAC where some of the ODBC files are
installed by default with "tight" security preventing the actual use
of the files. Make sure the files for these files are as follows.
a. Go to c:/program files/common files/System.
Right click on the
folder and select Properties, Security then Permissions. Ensure that
Everyone has RX permission, click on Replace Permissions on Subdirectory and
propagate those permissions down to all folders and files below.
b. Using Windows Explorer, go to c:/winnt/system32 and search for the
file MSJET40.dll and locate its creation date. Then click on the
"modified" tab at the top to sort all files in the pane to sort by
date. Choose all of the files with this same date (these files make up the
MDAC release), typically 6/2/99 or 6/3/99 using the Ctrl mouse click keys.
Select Properties, Security and then permissions and gave Everyone at least RX
permission to these files, click ok.
Solution #3:
In some cases of server installation where the file
and folder hieracy is not conventional to Microsofts default installation, the
global.asa file will not be global. Copy the global.asa file to the /mall
folder and the /cgi-bin folder.
Microsoft VBScript runtime error '800a004c'
Path not found
/cgi-bin/merc-conf.asp, line 28
Line 28 is: Set a = fs.OpenTextFile(myheader)
A. The path or file name for your email header file is not correct in
the global.asa file. Edit the global.asa file and change the path and
filename to the absolute path and filename for a ascii text file. Then
Reboot.
Before:
Session("mytext") =
"http://www.somethingwrong.com/wrongfile.txt"
to
After: Session("mytext") =
"D:\web\support-test\cgi-bin\email.txt"
Example: I order 5 Widgets costing $50 each. Shipping comes out as though
I made an order for $50, instead of an order for $250 (5 X $50).
Edit shop1.asp in HTML mode and add the last line as seen below.
Quantity = Request("Quantity")
part = SQLEncode(Request("part"))
price = SQLEncode(Request("price"))
description = SQLEncode(Request("description"))
units = SQLEncode(Request("units"))
size = SQLEncode(Request("size"))
weight = SQLEncode(Request("weight"))
taxed = SQLEncode(Request("taxed"))
upsell = SQLEncode(Request("upsell"))
weight = Quantity * weight
This is because in earlier versions of Microsoft FrontPage the
product replicated components in different directories both as cache as a part
of backward compatiability. The instructions below are manual uninstall
directions for SalesCart.
To manually uninstall and remove all component files of
SalesCart. Look for and delete the following folders. NOTE: You will need to
reinstall SalesCart PRO after following this procedure.
- Click on Start then Find and look for all files and folders on My
Computer named Shop. Delete them.
- Click on Start then Find and look for all files and folders on My
Computer named SalesCart.tem. Delete them.
Microsoft VBScript runtime error
'800a01ad'
ActiveX component can't create object: 'CDONTS.NewMail'
/colorfinishesoftexas/cgi-bin/merc-conf.asp,
line 35
The error indicates that the script cannot create a
CDONT's object. CDONTS is contained in the Option Pack 4.0 Microsoft SMTP
service. If you are getting this message on your local computer, you
should just ignore it because the functionality required to send mail form your
local computer is simply not available. If you have your site published to
your ISP and you are getting this error message, it is because the ISP has not
or has not "correctly" installed the Microsoft SMTP service which is a
part of the Microsoft Web service in Option Pack version 4.0. Please have
your ISP correctly install Option Pack 4.0 and set the permissions correctly for
this service to operate.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file
already in use or you do not have permission to view its contents.
Your ISP has the incorrect version of MDAC (Microsoft
Data Access Components installed on the server or the version is
not correctly installed). Have your ISP do the following:
Go to Start, Programs, Control Panel, and then click on ODBC.
Select
Drivers and ensure that the ODBC version you have is 4.00.4200.00 or
greater. If not, go to http://www.microsoft.com/data
and download the latest version of MDAC and install it on your server. If
it the version is correct, then continue as follows:
There is a bug with the installation of MDAC where some of the ODBC files are
installed by default with "tight" security preventing the actual use
of the files. Make sure the files for these files are as follows.
a. Go to c:/program files/common files/System.
Right click on the
folder and select Properties, Security then Permissions. Ensure that
Everyone has RX permission, click on Replace Permissions on Subdirectory and
propagate those permissions down to all folders and files below.
b. Using Windows Explorer, go to c:/winnt/system32 and search for the
file MSJET40.dll and locate its creation date. Then click on the
"modified" tab at the top to sort all files in the pane to sort by
date. Choose all of the files with this same date (these files make up the
MDAC release), typically 6/2/99 or 6/3/99 using the Ctrl mouse click keys.
Select Properties, Security and then permissions and gave Everyone at least RX
permission to these files, click ok.
Provider error
'80004005'
Unspecified error
/gifts/cgi-bin/GetOrder.inc, line 30
Same Problem as above Error
[Microsoft][ODBC Microsoft Access Driver]
Could not use '(unknown)'; file already in use. /gifts/cgi-bin/GetOrder.inc, line 30
Same Problem as above Error
Windows 2000 users, please skip Steps 1-2, and download patch.
Because SalesCart is a dynamic application where web pages are created on
the fly and depend on what the user selects, SalesCart requires ASP Active
Server Pages to Run. ASP is a part of the Option Pack 4.0 or a Part of
IIS4.0.
Step 1: Check to make sure you have ASP.
Click on Start, then
Find File/Folder. Look for the file asp.dll. If you don't find,
this file you need to download and install Option pack 4.0 or the lastest
version of the person web server.
Step 2: If you find ASP, you may download and install this patch
which will allow you to bypass the install checking for ASP and let you
install anyway.
Patch to bypass ASP checking.
Simple Option Text Field produces no
output in the checkout process or in the shop.mdb database.
You will need to replace your shop1.asp located in the
cgi-bin folder with a
revised version of the shop1.asp. A revised copy of the entire cgi-bin folder
can be downloaded by clicking on the link below and entering the SalesCart user
room. After unzipping the cgi-bin,
the shop1.asp can be imported to your site using FrontPage.
Go
to SalesCart user room to download
revised cgi-bin
Runtime Error 75 during creation of new
SalesCart Web using WINDOWS 2000.
Perform Find Files or Folders, search My Computer for the file "frontpg.ini".
This file should read:
[FrontPage 3.0]
FrontPageRoot=C:\Program Files\Microsoft Office
FrontPageLangID=0x0409
UILangAbbrev=enu
If it does not please copy and paste (above) to your frontpg.ini
Also, a temp folder must be created at: C:\Program Files\Microsoft
Office\temp
Back to Top
When adding item to cart receiving
error: Microsoft VBScript runtime error '800a000d' Type
mismatch: 'session' /cgi-bin/shop1.asp, line 129
Your ISP must enable Session State in IIS.
Back to Top
Will SalesCart
work with different localized and international versions of FrontPage 2000?
Yes.
SalesCart will work with any localized version of FrontPage.
The only issue is the installation which may not place the files in the
correct place because of the differences in installation routines. Follow this simple procedure to correct the installation of
SalesCart.
1. Click on Start>>Find>>Files or
Folders. Type empty.tem and click on Find Now.
Make a note of the location of this directory/folder, keep the window open.
We will refer to this as Find Window #1. This is where you need to
"relocate" the salescart.wiz or salescartpro.wiz folder.
2. Click on Start>>Find>>Files or
Folders. Type salescart.wiz for SalesCart 2.0 or salescartpro.wiz
for SalesCart PRO and click on Find Now. Once this
location is found, highlight the folder under Name and click Edit>>Cut
from the menu bar. Return to the Find Window #1. Right
click on the empty.tem folder and select Explore.
This will take you to the location where this folder is. Go up one level
to the parent folder and select it. Click Edit>>Paste.
This will move the New Web Wizard.
3. Close the explorer window and the two Find File
windows.
Next lets move the page templates:
1. Click on Start>>Find>>Files or
Folders. Type toc.tem and click on Find Now.
Make a note of the location of this directory/folder, keep the window open.
We will refer to this as Find Window #1. This is where you need to
"relocate" the [salescart]*.tem folders.
2. Click on Start>>Find>>Files or
Folders. Type [salescart]*.tem for SalesCart 2.0 and for
SalesCart PRO and click on Find Now. Once this
location is found, highlight both of the folders under Name and click Edit>>Cut
from the menu bar. Return to the Find Window #1. Right
click on the toc.tem folder and select Explore.
This will take you to the location where this folder is. Go up one
level to the parent folder and select it. Click Edit>>Paste.
This will move the New Web Templates.
Back to Top
Receiving the following error on
http://localhost after clicking the 'Add Items' icon:
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
Technical Information (for support personnel)
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x2b0 Thread 0x41c DBC 0x1f79e04 Jet'.
/salescart/cgi-bin/shop1.asp, line 137
Verify the path to the shop.mdb database is correct in the
global.asa file. It should be similar to:
C:\Inetpub\wwwroot\test\fpdb\shop.mdb
Copy global.asa to the <Root Web>. This location is the
same as http://localhost, and is usually located at c:\inetpub\wwwroot
Back to Top
I get this error when I click on
a product link.
Microsoft OLE DB Provider for
ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft
Access Driver] '(unknown)' 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. /cgi-bin/shop1.asp,
line 129
This error occurs when the
absolute file location specified for the shop.mdb in the global.asa is
wrong. Specifically, the location, folder name and file name specified for
the shop database is not correct. Contact your ISP and ask them for the
absolute path relative to the hard disk for the /fpdb/shop.mdb file. This
location will be something like: c:\inetpub\wwwroot\myweb\fpdb\shop.mdb.
Next edit your global.asa file with Notepad and change the line that defines the
ConnectionString and reads something as follows.
' Set your DSN or Database usernames and passwords here
Session("ConnectionString") = "Driver={Microsoft Access driver (*.mdb)};dbq=c:\inetpub\test\fpdb\shop.mdb;"
Change the characters c:\inetpub\test\fpdb\shop.mdb,
to the location specified by your ISP.
Back to Top
|
