ProductCart E-Commerce Solutions Homepage
Forum Home Forum Home > ProductCart > Customizing ProductCart
  New Posts New Posts RSS Feed - DB Connection Error...
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

DB Connection Error...
 Post Reply Post Reply
Author
Message
  Topic Search Topic Search  Topic Options Topic Options
Eric View Drop Down
Newbie
Newbie


Joined: 19-October-2009
Status: Offline
Points: 0 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Eric Quote  Post ReplyReply Direct Link To This Post Topic: DB Connection Error...
    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?
Back to Top
Greg Dinger View Drop Down
Certified ProductCart Developers
Certified ProductCart Developers
Avatar

Joined: 23-September-2006
Location: United States
Status: Offline
Points: 238 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Greg Dinger Quote  Post ReplyReply Direct Link To This Post 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.
 
Back to Top
Eric View Drop Down
Newbie
Newbie


Joined: 19-October-2009
Status: Offline
Points: 0 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Eric Quote  Post ReplyReply Direct Link To This Post 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!
Back to Top
Eric View Drop Down
Newbie
Newbie


Joined: 19-October-2009
Status: Offline
Points: 0 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Eric Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
Greg Dinger View Drop Down
Certified ProductCart Developers
Certified ProductCart Developers
Avatar

Joined: 23-September-2006
Location: United States
Status: Offline
Points: 238 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Greg Dinger Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
Eric View Drop Down
Newbie
Newbie


Joined: 19-October-2009
Status: Offline
Points: 0 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Eric Quote  Post ReplyReply Direct Link To This Post 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!
Back to Top
Eric View Drop Down
Newbie
Newbie


Joined: 19-October-2009
Status: Offline
Points: 0 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Eric Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
Guests View Drop Down
Guest
Guest
Post Options Post Options   Thanks (0) Thanks(0)   Quote Guests Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
Greg Dinger View Drop Down
Certified ProductCart Developers
Certified ProductCart Developers
Avatar

Joined: 23-September-2006
Location: United States
Status: Offline
Points: 238 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Greg Dinger Quote  Post ReplyReply Direct Link To This Post Posted: 19-October-2009 at 6:05pm
I think he's already past that Sean.  He said he got it all to work.
Back to Top
Guests View Drop Down
Guest
Guest
Post Options Post Options   Thanks (0) Thanks(0)   Quote Guests Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.04
Copyright ©2001-2021 Web Wiz Ltd.

This page was generated in 0.047 seconds.