SalesCart Standard / PRO / SQL - database connection problem (1 & 1 host)

Print Page | Close Window

database connection problem (1 & 1 host)

Printed From: SalesCart
Category: Legacy Products
Forum Name: SalesCart Standard / PRO / SQL
Forum Description: All questions pertaining to SalesCart Standard, PRO and SQL should be posted here.
URL: http://forum.salescart.com/forum/forum_posts.asp?TID=334
Printed Date: November/24/24 at 9:29am
Software Version: Web Wiz Forums 11.04 - http://www.webwizforums.com

Topic: database connection problem (1 & 1 host)

Posted By: progressive1
Subject: database connection problem (1 & 1 host)
Date Posted: April/09/05 at 7:48pm

I am uploading my site to 1 and 1, we have all the bugs, email etc figured out. The last problem is a big one. I can go through a purchace, after finishing, when I try to access my product page, I get the following error. Could not open data connection. Error:
Could not find installable ISAM.
The Invalid ConnectionString is defined as: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=e:\kunden\homepages\35\d119123791\fpdb\shop.mdb;

This was there fix, any ideas?

To make a connection to an access database, you will have to use an ADODB.Connection.

Within your asp script you would want to use this code:

<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\kunden\homepages\xx\dxxxxxxxxx\db\myDB.mdb;"
%>

Do I do this just to my product pages?

Replies:

Posted By: Techno Geek
Date Posted: April/11/05 at 8:39am

No, you would add this to either /global.asa (for FrontPage) or /cgi-bin/salescart.asa (for Dreamweaver).

-------------
Techno Geek
Customer Support Engineer
ComCity and SalesCart Technical Support