Knowledgebase

Home > Item #26

Site times out on order submission after I converted to SQL Server

Item: #26
Date: 9 Aug 2001
Applies to
v3

Question

I have upsized my database to SQL Server. Everything seems to be working fine, except that at the final step--order submission--the script times out. This was not a problem while using Access. How can this be fixed?

Answer

This is a cursor problem on versions 3.200 of CactuShop and below which may affect some users. Search for the following code in the mailorder.asp script or WorldPay version (if using that):

rs_main.Open cmdTemp, , 1, 3

and change to

rs_main.Open cmdTemp, , 1, cursortype

then search for

rs_main6.Open cmdTemp, , 1, 3

and change to

rs_main6.Open cmdTemp, , 1, cursortype

This should solve the problem.

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

« Back