Customizing ProductCart - DB Connection Error...

Print Page | Close Window

DB Connection Error...

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Customizing ProductCart
Forum Description: Exchange messages with other users that are customizing ProductCart.
URL: https://forum.productcart.com/forum_posts.asp?TID=3119
Printed Date: 23-July-2025 at 10:02am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: DB Connection Error...

Posted By: Eric
Subject: DB Connection Error...
Date Posted: 19-October-2009 at 3:14pm

I'm trying to add the 'Small Shopping Cart' resource to an existing HTML page, and am getting this error:

"Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

/[my site name]/[my renamed 'Product Cart folder']/pc/SmallShoppingCart.asp, line 88

Lines 87-88 in the SmallShoppingCart.asp file look like this:

Set conTempSC=Server.CreateObject("ADODB.Connection")
conTempSC.Open scDSN

====
I'm currently using a local test environment (SQL Express and the site are on the same box), and am using a local 'system' (the driver is 'SQL Server'--very generic) DSN connection to establish connectivity to the db.

Any ideas as to what I'm doing wrong?

Replies:

Posted By: Greg Dinger
Date Posted: 19-October-2009 at 3:25pm

Is this a .HTML page or a .ASP page.

If it is a .ASP page, you need other included files such as storeconstants.asp, opendb.asp, and probably others for this to work.

If this is a .HTML page it won't work.

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |

Posted By: Eric
Date Posted: 19-October-2009 at 3:32pm

Hi Greg,

It's an ASP page, but without the various includes you mention. It was created as a JavaScript ASP page, and uses the default page info as follows:

<%@LANGUAGE="JAVASCRIPT" CODEPAGE="65001"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

[etc]

====

Do you know where I might find documentation on what includes to put in?

Many thanks!

Posted By: Eric
Date Posted: 19-October-2009 at 3:34pm

PS:

I've managed to get the connection issue resolved (I think) and am seeing the 'SmallShoppingCart.asp' page now, but am not parsing it properly:

Microsoft JScript compilation (0x800A03EC)
Expected ';'

/[my site name]/[renamed Product Cart folder]/pc/SmallShoppingCart.asp, line 2, column 322
'This file is part of ProductCart, an ecommerce application developed and sold by Early Impact LLC. ProductCart, its source code, the ProductCart name and logo are property of Early Impact, LLC. Copyright 2001-2006. All rights reserved. You are not allowed to use, alter, distribute and/or resell any parts of ProductCart's source code without the written consent of Early Impact. To contact Early Impact, please visit www.earlyimpact.com.

Posted By: Greg Dinger
Date Posted: 19-October-2009 at 3:38pm

I'm not sure there really is documentation. The best starting point is to grab the includes from the top of viewprd.asp. Then there may be code which needs to be cloned over from that page in order, for example, to open the database connection. But that's the basic issue is that you need the database open and available for this to work.

If you are comfortable with ASP, this may get you close enough to get the job done. If not, you may want to hire a developer who can help get it done.

Good luck.

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |

Posted By: Eric
Date Posted: 19-October-2009 at 3:40pm

Greg,

Thanks for that information. It's a great starting point, and I'll see how I get on with it.

Many thanks again!

Posted By: Eric
Date Posted: 19-October-2009 at 3:46pm

Greg,

I was able to get everything working properly by adding the 'ViewPrd'-listed includes.

Thanks for the advice; you're a lifesaver!

Eric

Posted By: Guests
Date Posted: 19-October-2009 at 6:00pm

Eric wrote:

PS:

I've managed to get the connection issue resolved (I think) and am seeing the 'SmallShoppingCart.asp' page now, but am not parsing it properly:

Microsoft JScript compilation (0x800A03EC)
Expected ';'

/[my site name]/[renamed Product Cart folder]/pc/SmallShoppingCart.asp, line 2, column 322

Did you say this page was written JS ASP? Looks like you are missing an end line delimiter. In the JS syntax you have to end each line with the semi colon, unlike with VB Script.

Posted By: Greg Dinger
Date Posted: 19-October-2009 at 6:05pm

I think he's already past that Sean. He said he got it all to work.

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |

Posted By: Guests
Date Posted: 19-October-2009 at 6:11pm

Greg Dinger wrote:

I think he's already past that Sean. He said he got it all to work.

Seems I didn't have the latest on the thread for some reason when I posted.