AnyView Browser returns lines instead of data on Pervasive SQL (PSQL) on SP3.

Issue Description

AnyView Browser returns lines instead of data on PSQL with Service Pack 3.

Due to a cursor issue with ODBC, the rowset property is not being set correctly.

Solution

In order to resolve this issue, you must add a line to general section of the the anyview.ini file to override the default cursortype.

Follow these steps to override the default cursortype in the anyview.ini file: 

1. Navigate to the AnyView physical directory.
2. From the AnyView physical directory, open the anyview.ini file in Notepad.
3. Add the line "CURSORTYPE=2" under the [GENERAL] section of anyview.ini file.
4. Save the change.
5. Unload the AnyView Web Application. Show Me
   1. From the IIS Server, launch the Internet Services Manager.
   2. Navigate to the AnyView Web Application. (In a standard installation, this would be in the Default Web Site folder.)
   3. Right-click on AnyView and select 'Properties'.
   4. From the Virtual Directory tab, click 'Unload' then 'OK'.