Knowledgebase

Home » Item #425

Error: 'Line 1: Incorrect syntax near '='' (after upsizing to MS SQL)

Item: #425
Date: 12 Mar 2003
Applies to
v3
v4
v5

Question

I have upsized my CactuShop database to MS SQL Server but get this error:

Microsoft OLE DB Provider for SQL Server error '80040e14'

Line 1: Incorrect syntax near '='.

Why is this and how do I fix it?

Answer

This is a cursor type problem. The constants used for different types of database cursors differ between Access and MS SQL.

From v5.117 onwards, the cursor type is set depending on the strDatabaseType set in the config.asp file. In prior versions, you need to manually set the numCursorType (or cursortype in v4.x) in the config.asp file.

To fix the problem, change the cursor type to 1 (for MS SQL). It should be set to 3 for MS Access sites.

Can't find the answer you need? Click here to open a support ticket.

« Back