Hosting Problem

I'm assuming the hosting company that you're with requires you to put the database in the db folder because that's how their control panel works? Did you create a DSN for the shopping cart? Can you post the error message?

Anyone? Any Ideas?

My hosting co can't find a problem and has recommended an open source solution.

Does anyone have any idea why my salescart web will not work?

Thanks

Will,

This is the problem;

My database is held at this address
D:\webspace\signsupports.co.uk\db\shop.mdb

Cgi-Bin, Mall and all other pages (including products) are held at this address
D:\webspace\signsupports.co.uk\wwwroot

I can't get the product pages and cgi-bin pages to talk to the shop database held outside the wwwroot.

In server controls I have created the database (then copied shop.mdb into it) I have also set up an OSDB connection called salescart2 pointing to this database.

Your previous post led to a page with this written;

"Extract path.asp and checkpost.asp to the cgi-bin folder in your current SalesCart website. Insert the following line as the second line in each of your product pages:

<!--#include file="../cgi-bin/path.asp" -->


The preceding path is for product pages that are contained in a folder off the root web. Modify the path to suit your situation. The zip includes an example product page for SalesCart PRO. Your product pages should also be named with a .asp extension.

There is an additional step for SalesCart STD. Open shop1.asp and include the following line before the checkpost entry:"

This refers to "product pages" outside the wwwroot- my product pages are INSIDE the wwwroot it's my database that is OUTSIDE the wwwroot.

In addition.

<%
Response.Expires = 0

'Contains virtual path to page
Session("path") = Request.ServerVariables(D:\webspace\signsupports.co.uk\db\sh op.mdb)

'Checks if page is called using https
If Request.ServerVariables("HTTPS") = "off" Then
     secure = "http://"
Else
     secure = "https://"
End If

'Checks if page contains a query string
If Request.ServerVariables("QUERY_STRING") <> "" Then
     queryStr = "?" & Request.ServerVariables("QUERY_STRING")
Else
     queryStr = ""
End If

Session("continue") = secure & Request.ServerVariables("SERVER_NAME") & Session("path") & queryStr
%>

The above code is that in the path.asp file refered to in the article.

Where is the path that need's to be changed? The path for my database is D:/webspace/signsupports.co.uk/db/shop.mdb.

If I enter this path I get this error message;

Microsoft VBScript compilation error '800a03ee'

Expected ')'

D:\WEBSPACE\SIGNSUPPORTS.CO.UK\WWWROOT\MALL\../cgi-bin/path. asp, line 5

Session("path") = Request.ServerVariables(D:\webspace\signsupports.co.uk\db\sh op.mdb)
-------------------------------------------^

So I am stuck again :(

I really do need some help here. I think it's a pretty simple problem but I want to get it sorted.

My ISP is pushing for me to drop salescart and go with OSCommerce- a free PHP solution. They have setup an SQL connection for me and I managed to setup an OSCommerce system on the same server in 10 minutes.

All that has changed from a standard salescart hosting is that the database has moved from FPDB folder to an external one called DB. Surely this is something salescart can cope with easily?

I need to get this sorted- please help

Andy