Knowledgebase
Home » Item #362
Prodtype.asp fails after upscaling the site to SQL Server
Question
After converting an Access database to SQL Server, my prodtype.asp page started to fail.
It now gives the following error:
Microsoft OLE DB Provider for SQL Server error '80040e14'
Line 1: Incorrect syntax near '='.
D:\WWWROOT\SITENAME\WWW\ASP\../includes/functions.asp, line 493
What is the problem and how do I fix it?
Answer
SQL Server has different cursor type defaults to Access. If you do not change the cursortype value in the config.asp file, many pages will behave erratically or fail.
Technically, this is because with cursortype=3, 'recordcount' statements return -1 instead of the true number of records pulled out by a query. Many parts of CactuShop rely on checking how many records are pulled out, hence the resulting problems.
To fix this issue, open the config.asp file and ensure cursortype is changed to 1 (for SQL Server).