User login

MetaTraffic 2.0 Boxshot

SQL Server 2005 error.

Posted by phong [October 9, 2008]

Hi, we used to use Metatraffic2 on SQL Server Express and it worked beautifully. Recently we changed to MS SQL Server 2005 and we are now getting the following error in the front end tracking code:

Microsoft OLE DB Provider for ODBC Drivers error '80040e23'

[Microsoft][ODBC SQL Server Driver][SQL Server]The cursor does not include the table being modified or the table is not updatable through the cursor.

/cms/metatraffic/clsLog.asp, line 177

I have looked at forums throughout the net and it appers that the ADO recordset update method you have used might not be supported in SQL Server 2005. Is this true? Can you help us fix this problem please.

Strange, I use Metatraffic2

Strange, I use Metatraffic2 and MS SQL Server 2005 on a couple of domains with no problems.

Suggested fix

Please see my post http://metasun.net/node/493