ProductCart E-Commerce Solutions Homepage
Forum Home Forum Home > ProductCart > Using ProductCart
  New Posts New Posts RSS Feed - Setting up PC, connecting to Database
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Setting up PC, connecting to Database

 Post Reply Post Reply
Author
Message
BlackReefDesigns View Drop Down
Newbie
Newbie


Joined: 28-May-2008
Location: San Diego, CA
Status: Offline
Points: 8
Post Options Post Options   Thanks (0) Thanks(0)   Quote BlackReefDesigns Quote  Post ReplyReply Direct Link To This Post Topic: Setting up PC, connecting to Database
    Posted: 22-March-2010 at 5:05pm
Hello,

I am following the Wiki to setup the ProductCart software on my server.  I have already ran the script and now I am at the 'connecting to database' part:

Quote

Connecting to the Database

You can connect to your SQL database using a DSN or DSN-less connection. We recommend using a DSN-less connection. Make sure that the user used in the connection string has been setup for SQL authentication, not Windows authentication.

DSN-Less connection to a MS SQL database

"Provider=sqloledb;Data Source=SERVER-IP,1433;Initial Catalog=DB-NAME;User Id=USER;Password=PWD;

“SERVER-IP” is the server’s IP address
“DB-NAME” is the name of the database

“USER” and “PWD” are the user name and password that grant access to it"


Just to confirm - I need to update the string in the storeconstants.asp file with this, correct?  I don't see any mention of the storeconstants file in this wiki document, so I just want to make sure before I move forward.

In the past I have always had EI install the software on the server just to save some time, but now I am doing it on my own.

Any help would be appreciated,

Thanks,
Joe S.
BlackReef.net
Back to Top
whizzinpc View Drop Down
Newbie
Newbie
Avatar

Joined: 17-January-2006
Location: California
Status: Offline
Points: 20
Post Options Post Options   Thanks (0) Thanks(0)   Quote whizzinpc Quote  Post ReplyReply Direct Link To This Post Posted: 22-March-2010 at 5:57pm
Just put your db string in the textbox and continue. It will automatically update the storeconstants file.
Back to Top
BlackReefDesigns View Drop Down
Newbie
Newbie


Joined: 28-May-2008
Location: San Diego, CA
Status: Offline
Points: 8
Post Options Post Options   Thanks (0) Thanks(0)   Quote BlackReefDesigns Quote  Post ReplyReply Direct Link To This Post Posted: 22-March-2010 at 6:00pm
Which text box are you referring to?
Joe S.
BlackReef.net
Back to Top
whizzinpc View Drop Down
Newbie
Newbie
Avatar

Joined: 17-January-2006
Location: California
Status: Offline
Points: 20
Post Options Post Options   Thanks (0) Thanks(0)   Quote whizzinpc Quote  Post ReplyReply Direct Link To This Post Posted: 22-March-2010 at 6:12pm
If your using the Wizard. It's on step2.asp.
here is a screenshot. you just put it in the white textbox.


If not then you can just update the storeconstants file with your db string.
Back to Top
BlackReefDesigns View Drop Down
Newbie
Newbie


Joined: 28-May-2008
Location: San Diego, CA
Status: Offline
Points: 8
Post Options Post Options   Thanks (0) Thanks(0)   Quote BlackReefDesigns Quote  Post ReplyReply Direct Link To This Post Posted: 22-March-2010 at 6:18pm
Oh I see, thank you.  No I was not using the wizard (I haven't tried to activate yet) I am just referencing the Wiki document.

Thanks for the help!  Ill get it taken care of


BTW - the animated .Gif in your avatar is frickin' hilarious.  I think we've all felt like that at some point lol


Edited by BlackReefDesigns - 22-March-2010 at 6:23pm
Joe S.
BlackReef.net
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.063 seconds.