Knowledgebase
Home » Item #915
I get various page errors after setting up my CactuShop with Microsoft SQL Server
Question
I have set up my site to run with a Microsoft SQL Server database but I get errors on the site. Some pages work, so the database connection itself is clearly ok. Where else should I look?
Answer
There are a number of things you should check:
1. Look at the strDatabaseType setting in the config.asp file - it should be set to "mssql". If your CactuShop is v5.116 or before, you should also set numCursorType to 1 (from v5.117 onwards, this is set automatically.
2. Make sure your tables have records in! Some users have copied across table structure, but without data. CactuShop requires data such as the config settings, language strings, etc. in order to function. If you used DTS to copy the tables to the live server, make sure you check the options to copy data too.
3. In most CactuShop tables, the first field is called [something]_ID and is a unique identifier for each record. As such, in most tables this should be set to be both PRIMARY KEY and IDENTITY. Exceptions are tables holding most link records as well as the following:
CFG_Name - just set to be PRIMARY KEY
LS_ID - just set to be PRIMARY KEY
4. CactuShop is designed to run on a database set to US settings. If your database is running British or other settings you may get date problems that cause query errors. For more information:
[#592] Changing the date settings of your MS SQL database