ProductCart Shopping Cart Software Forums : DB Connection Error... https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 05:43:31 +0000 Mon, 19 Oct 2009 18:11:02 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=3119 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[DB Connection Error... : Greg Dinger wrote:I think he&#039;s...]]> https://forum.productcart.com/db-connection-error_topic3119_post11674.html#11674 Author: Guests
Subject: 3119
Posted: 19-October-2009 at 6:11pm

Originally posted by Greg Dinger 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.
]]> Mon, 19 Oct 2009 18:11:02 +0000 https://forum.productcart.com/db-connection-error_topic3119_post11674.html#11674 <![CDATA[DB Connection Error... : I think he&#039;s already past...]]> https://forum.productcart.com/db-connection-error_topic3119_post11673.html#11673 Author: Greg Dinger
Subject: 3119
Posted: 19-October-2009 at 6:05pm

I think he's already past that Sean.  He said he got it all to work.]]> Mon, 19 Oct 2009 18:05:23 +0000 https://forum.productcart.com/db-connection-error_topic3119_post11673.html#11673 <![CDATA[DB Connection Error... : Eric wrote:PS:I&#039;ve managed...]]> https://forum.productcart.com/db-connection-error_topic3119_post11672.html#11672 Author: Guests
Subject: 3119
Posted: 19-October-2009 at 6:00pm

Originally posted by Eric 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.
]]> Mon, 19 Oct 2009 18:00:58 +0000 https://forum.productcart.com/db-connection-error_topic3119_post11672.html#11672 <![CDATA[DB Connection Error... : Greg,I was able to get everything...]]> https://forum.productcart.com/db-connection-error_topic3119_post11671.html#11671 Author: Eric
Subject: 3119
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
]]> Mon, 19 Oct 2009 15:46:50 +0000 https://forum.productcart.com/db-connection-error_topic3119_post11671.html#11671 <![CDATA[DB Connection Error... : Greg,Thanks for that information....]]> https://forum.productcart.com/db-connection-error_topic3119_post11670.html#11670 Author: Eric
Subject: 3119
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!
]]> Mon, 19 Oct 2009 15:40:43 +0000 https://forum.productcart.com/db-connection-error_topic3119_post11670.html#11670 <![CDATA[DB Connection Error... : I&#039;m not sure there really...]]> https://forum.productcart.com/db-connection-error_topic3119_post11669.html#11669 Author: Greg Dinger
Subject: 3119
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.
]]> Mon, 19 Oct 2009 15:38:41 +0000 https://forum.productcart.com/db-connection-error_topic3119_post11669.html#11669 <![CDATA[DB Connection Error... : PS:I&#039;ve managed to get the...]]> https://forum.productcart.com/db-connection-error_topic3119_post11668.html#11668 Author: Eric
Subject: 3119
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
'Thisfile is part of ProductCart, an ecommerce application developed andsold by Early Impact LLC. ProductCart, its source code, the ProductCartname and logo are property of Early Impact, LLC. Copyright 2001-2006.All rights reserved. You are not allowed to use, alter, distributeand/or resell any parts of ProductCart's source code without thewritten consent of Early Impact. To contact Early Impact, please visitwww.earlyimpact.com.
]]> Mon, 19 Oct 2009 15:34:27 +0000 https://forum.productcart.com/db-connection-error_topic3119_post11668.html#11668 <![CDATA[DB Connection Error... : Hi Greg,It&#039;s an ASP page,...]]> https://forum.productcart.com/db-connection-error_topic3119_post11667.html#11667 Author: Eric
Subject: 3119
Posted: 19-October-2009 at 3:32pm

Hi Greg,

It'san ASP page, but without the various includes you mention. It wascreated as a JavaScript ASP page, and uses the default page info asfollows:

<%@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!]]> Mon, 19 Oct 2009 15:32:00 +0000 https://forum.productcart.com/db-connection-error_topic3119_post11667.html#11667 <![CDATA[DB Connection Error... : Is this a .HTML page or a .ASP...]]> https://forum.productcart.com/db-connection-error_topic3119_post11665.html#11665 Author: Greg Dinger
Subject: 3119
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.
 
]]> Mon, 19 Oct 2009 15:25:10 +0000 https://forum.productcart.com/db-connection-error_topic3119_post11665.html#11665 <![CDATA[DB Connection Error... : I&#039;m trying to add the &#039;Small...]]> https://forum.productcart.com/db-connection-error_topic3119_post11664.html#11664 Author: Eric
Subject: 3119
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?
]]> Mon, 19 Oct 2009 15:14:25 +0000 https://forum.productcart.com/db-connection-error_topic3119_post11664.html#11664