http://forum.salescart.com/forum/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sun, 10 May 2026 05:22:10 +0000 Tue, 30 Nov 2004 19:19:19 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 11.04 360 forum.salescart.com/forum/RSS_post_feed.asp?TID=245 http://forum.salescart.com/forum/forum_images/web_wiz_forums.png http://forum.salescart.com/forum/ http://forum.salescart.com/forum/forum_posts.asp?TID=245&PID=870&title=convert-to-sql-2000-server#870 Author: dremer
Subject: 245
Posted: November/30/04 at 7:19pm

I believe it is a database issue when I upsized it to SQL. Do you guys have .sql file that I can use to import/create a new Shop database using Query Analyzer tool.

Thanks
Dave]]> Tue, 30 Nov 2004 19:19:19 +0000 http://forum.salescart.com/forum/forum_posts.asp?TID=245&PID=870&title=convert-to-sql-2000-server#870 http://forum.salescart.com/forum/forum_posts.asp?TID=245&PID=864&title=convert-to-sql-2000-server#864 Author: Techno Geek
Subject: 245
Posted: November/30/04 at 8:18am

10 items but you can't remove them? That almost sounds like a database permission issue.]]> Tue, 30 Nov 2004 08:18:33 +0000 http://forum.salescart.com/forum/forum_posts.asp?TID=245&PID=864&title=convert-to-sql-2000-server#864 http://forum.salescart.com/forum/forum_posts.asp?TID=245&PID=861&title=convert-to-sql-2000-server#861 Author: dremer
Subject: 245
Posted: November/29/04 at 9:45pm

Will -
I already upsized the access database to SQL database. Under Frontpage 2002, I added the sql database under tools\web settings\database tab. When I go to view1.asp I get 10 items in the shopping cart, but I cannot delete items or checkout. The global.asa is pointing to the sql database. Is there something I'm missing

Thanks
Dave]]> Mon, 29 Nov 2004 21:45:11 +0000 http://forum.salescart.com/forum/forum_posts.asp?TID=245&PID=861&title=convert-to-sql-2000-server#861 http://forum.salescart.com/forum/forum_posts.asp?TID=245&PID=860&title=convert-to-sql-2000-server#860 Author: Techno Geek
Subject: 245
Posted: November/29/04 at 9:18pm

You don't have to purchase the SQL version if you don't want to. That entitles you to no support when your SalesCart PRO doesn't work with the SQL database :)

You use the Access Upsize wizard to convert your Access database to an SQL backup file, then restore the backup file, then make sure that your ASP files are looking at the SQL databases. That means you setup an ODBC data source, point it to your SQL database, then modify your SalesCart connector (either global.asa or salescart.asa) to look at that DSN.

Hope this helps...]]> Mon, 29 Nov 2004 21:18:06 +0000 http://forum.salescart.com/forum/forum_posts.asp?TID=245&PID=860&title=convert-to-sql-2000-server#860 http://forum.salescart.com/forum/forum_posts.asp?TID=245&PID=858&title=convert-to-sql-2000-server#858 Author: dremer
Subject: 245
Posted: November/29/04 at 9:13pm

I have the SalesCart Pro 5.0 that uses MS Access as the database. I want to convert away from MS Access to SQL 2000 server. What changes do I need to make to the webpages/database to get it to work properly? Please don't say purchased the SalesCart SQL version

Thanks for your help
Dave]]> Mon, 29 Nov 2004 21:13:23 +0000 http://forum.salescart.com/forum/forum_posts.asp?TID=245&PID=858&title=convert-to-sql-2000-server#858