Forum Home Forum Home > Legacy Products > SalesCart Standard / PRO / SQL
  New Posts New Posts RSS Feed - SQL Version - Confused?
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Forum LockedSQL Version - Confused?

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


Joined: March/25/04
Status: Offline
Points: 5
Post Options Post Options   Thanks (0) Thanks(0)   Quote dstoltz Quote  Post ReplyReply Direct Link To This Post Topic: SQL Version - Confused?
    Posted: March/25/04 at 2:27pm
Ok, I installed all the DWMX 2004 extensions, did the SC database...

Now in DW, I go through the "create" process, and it writes all the
files....

QUESTION#1: why does it put all the files into a folder on the root? In
other words, if my web is www.myserver.com, it puts everything in
www.myserver.com/webname

for example:
www.myserver.com/webname/cgi-bin
www.myserver.com/webname/mall
www.myserver.com/webname/SQL-Admin

etc....

I would think it should put all that on the root...? no?

Also, I've created the DSN on the web server to point to the SQL DB, but
when I am trying to run the demo, I go to homepage.asp, click on "click here
to start shopping", then I click on Product Page #1 and I get this:

Could not open data connection. Error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'(null)'. Reason: Not associated with a trusted SQL Server connection.
The Invalid ConnectionString is defined as: DSN=SalesCartDSN; UID=; PWD=;

For the life of me I can't find where to fix this...



Please help!

Thanks!

Dave
Back to Top
Techno Geek View Drop Down
Admin Group
Admin Group
Avatar
Evil monkey living in my closet!

Joined: March/11/04
Location: United States
Status: Offline
Points: 1206
Post Options Post Options   Thanks (0) Thanks(0)   Quote Techno Geek Quote  Post ReplyReply Direct Link To This Post Posted: March/25/04 at 3:31pm
Let's see, in regards to the first issue. Make sure that your Dreamweaver path is pointing to the folder that has the website folder. So for example if you have the website folder (e.g. C:\mysite) you would name the path C:\ and then the folder name mysite. That was SalesCart install the files on the root and not in C:\mysite\mysite (again).

Second issue, you don't have a SQL server username associated with the SQL database. If this is your server, then you need to make sure that you create a user and associate the user with your database. You also need to make sure that your DSN has that username and password spelled out in the connection string. You can re-run the wizard to specify the username and password.

Hope this helps.
Techno Geek
Customer Support Engineer
ComCity and SalesCart Technical Support
Back to Top
dstoltz View Drop Down
Newbie
Newbie


Joined: March/25/04
Status: Offline
Points: 5
Post Options Post Options   Thanks (0) Thanks(0)   Quote dstoltz Quote  Post ReplyReply Direct Link To This Post Posted: March/26/04 at 5:16am

WOO HOO!!! It works!

Thanks so much!
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 11.04
Copyright ©2001-2015 Web Wiz Ltd.

Copyright 2015 by ComCity® LLC and SalesCart™.  All Rights Reserved