Cannot create a front-end result set

[husheduser]

I'm using TD 1.5.1 PTF6 against an Oracle database (tried in both 8i and 9i clients and servers). Once in a while I get the message "Cannot create a front-end result set".
I know I have to delete all the frs* files that are being accumulated in the Temp folder (I've even put a job that does that task), but I still get that message when connecting a lot of cursors and having a heavy load.
The remedy according to error.sql is to "Verify that there is sufficient memory at the client workstation. Verify that the FILES configuration parameter of your operating system is set high enough to support multiple files.". The problem is that I think this solution applies to Win 95 or less... since the FILES parameter was used in the CONFIG.SYS if I'm not mistaken.

Any ideas on what to do to avoid this error?

[Steve Leighton]

Firstly do you need a Front End Result Set - i.e. do you need to scroll backwards through a Result Set or select a specific row using SqlFetchPrev() or SqlFetchRow().
If not , switch off Result Set mode using SqlSetResultSet ( hSql, FALSE).
Otherwise , I have written a SQL Handles class that specifically manages FRS files associated with each handle, and deletes or re-uses them in real-time. You can choose how many handles to connect before they get re-used , and any associated FRS files get created or deleted or re-used accordingly. Had absolutely no problems as you describe, using this class - and the TEMP folder is left clean after you disconnect your app.
You will have to send me your eMail address if you want it.

[sreekumar]

Dear SteveLeighton,

I have the same problem when connecting Oracle db using ODBC connection.
it would be helpful if you send me the class which you created to me.
email id - sreekumar@sbntech.net

Thanks in Advance,
Sreekumar

[husheduser]

@SteveLeighton

Would you be so kind to send the source code of the class or function you mentioned to the following e-mail: husheduser@gmail.com

Thanks in advance.

[pointman]

@SteveLeighton
Can you please send the source code of the class you had mentioned to the following e-mail: kalpana.kannan@infor.com
Thanks.

[Rudi]

Hallo Steve,

could you please send me the source code too?
I have big problems with Oracle and CTD 1.51 PTF6.
mail: max_stg@yahoo.de
Thank you.

Rudi

[Steve Leighton]

All . You need to specify what version of TD you are running. No point in me sending you a 5.1 file if you are running v3 or whatever. You wont be able to open it. Rudi your 1.5.1 version is on its way.

[Vishal69_]

All . You need to specify what version of TD you are running. No point in me sending you a 5.1 file if you are running v3 or whatever. You wont be able to open it. Rudi your 1.5.1 version is on its way.

Hi Steve

I have same problem, of FRS, While running two application Simultaneously, it pops up with an error "Cannot create a front-end result set".

I have TD3.0 and Oracle 11g DB and Client 11g.

Appreciate your help in resolving this issue !

Regards,
Vishal

[Christof]

This can be managed by assigning individual TEMP-directories for each application. This avoids conflicts between concurrent *.frs files.

Either use batch files which are setting the TEMP environment variable to a proper directory or (the more elegant approach) let the app create a subdirectory in TEMP and call SetEnvironmentVariableA(TEMP, ...) to let the process environment point to the individual TEMP directory.

Greetings
Christof

[Vishal69_]

This can be managed by assigning individual TEMP-directories for each application. This avoids conflicts between concurrent *.frs files.

Either use batch files which are setting the TEMP environment variable to a proper directory or (the more elegant approach) let the app create a subdirectory in TEMP and call SetEnvironmentVariableA(TEMP, ...) to let the process environment point to the individual TEMP directory.

Greetings
Christof

Hi Christof,

I do not see any function called 'SetEnvironmentVariableA'.

Is there any lib, which i need to include in App.

Please help.

thnx,

vishal

[Christof]

Code: Select all

External Functions
   Library name: Kernel32.dll
      Function: SetEnvironmentVariableA
         Description:
         Export Ordinal: 0
         Returns
            Boolean: BOOL
         Parameters
            String: LPCSTR
            String: LPCSTR

http://msdn.microsoft.com/en-us/library ... 85%29.aspx

Greetings
Christof