I tried MetaTraffic with MS SQL 2005 and got next error:
[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.
after some digging in Internet I found the solution and want to share it.
You need modify file core.asp - go to line 150 and modify connection string for MS SQL as follows:
strConn = "Provider=SQLOLEDB;" &_
"Data source=" & aryMTDB(1) & ";"
If blnPort = True Then
strConn = strConn & "PORT=" & intPort & ";"
End If
strConn = strConn & "Initial catalog=" & aryMTDB(2) & ";" &_
"User Id=" & aryMTDB(3) & ";" &_
"Password=" & aryMTDB(4) & ";"
(instead of Provider=MSDASQL.1 and DRIVER={SQL Server} )
Good luck!
VB