I recently ran into a web client system that was unable to operate properly. Whenever a page opened, the following error would be thrown:
The following SData diagnosis occurred: Description=Operation failed. Message=Invalid usage of the option NEXT in the FETCH statement. : Incorrect syntax near ‘OFFSET’. HTTP status: Internal Server Error (500).
The solution to this is something simple that I had ran into before. Luckily my senility hadn’t yet reached that memory bank. Here is how to fix this issue:
In the Saleslogix Connection Manager on the server someone had chosen the 2012 SQL Client (SQLNCLI11.1) rather than the 2010 SQL Client as the SQL OLE DB Provider to use to connect to the database.
After redefining the connection using the other provider, and an IIS reset- Kamblam! A working web site!