Using Windows-7 Desctop, Oracle 12 and old Gupta 3.0.0-PTF1 sometime I get this silly SQL error message.
This is a longtime running programm and there is no syntax error. One or two time a day I get this. Error 166 is not really a ORACLE SQL-Error. So far as I know it comes from Gupta ORA SQL-Router DLL.
166: Cannot create a front-end result set
SQL Query looks like this. But this is not the only one and not the problem.
If SqlConnect( lvhs )
If SqlPrepareAndExecute( lvhs, 'select 1 into :lvZahl from dual' )
If SqlFetchNext( lvhs, lvInd )
Any idea what's going on?
1.Try Deleting all files that are accumulated in the Temp folder (router caches rows in temp file).
2.Verify that there is sufficient memory available.
3.Make sure your app have enough rights to access temp folder.... ie.OS security or non-admin issues.
4.You can disable the front- end result set by calling the function bOk = SqlSetResultSet ( hSql, False ) in case result set is not required.
5.If you have multiple applications running simultaneously then you can assign individual TEMP-directories for each application by calling function SetEnvironmentVariableA().