Cannot create a front-end result set

General discussion forum about all databases other than SqlBase.
husheduser
Columbia
Posts: 11
Joined: 09 Jun 2018, 04:41
Location: Columbia

Cannot create a front-end result set

Post by husheduser » 06 Sep 2009, 11:55

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?

User avatar
Steve Leighton
Site Admin
Site Admin
New Zealand
Posts: 342
Joined: 05 Mar 2017, 20:57
Location: Stroud, England <--> Tauranga, New Zealand

Re: Cannot create a front-end result set

Post by Steve Leighton » 06 Sep 2009, 21:43

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.
Greetings from New Zealand
Steve Leighton

Bankside Systems Ltd.
UK ♦ Australia ♦ New Zealand

www.banksidesystems.co.uk

Image

sreekumar

Re: Cannot create a front-end result set

Post by sreekumar » 20 Jan 2010, 08:33

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
Columbia
Posts: 11
Joined: 09 Jun 2018, 04:41
Location: Columbia

Re: Cannot create a front-end result set

Post by husheduser » 23 Mar 2010, 16:43

@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

Re: Cannot create a front-end result set

Post by pointman » 22 Feb 2011, 21:17

@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

Re: Cannot create a front-end result set

Post by Rudi » 09 Mar 2011, 10:48

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

User avatar
Steve Leighton
Site Admin
Site Admin
New Zealand
Posts: 342
Joined: 05 Mar 2017, 20:57
Location: Stroud, England <--> Tauranga, New Zealand

Re: Cannot create a front-end result set

Post by Steve Leighton » 13 Mar 2011, 21:47

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.
Greetings from New Zealand
Steve Leighton

Bankside Systems Ltd.
UK ♦ Australia ♦ New Zealand

www.banksidesystems.co.uk

Image

Vishal69_

Re: Cannot create a front-end result set

Post by Vishal69_ » 15 Nov 2011, 10:17

SteveLeighton wrote: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
Germany
Posts: 191
Joined: 06 Mar 2017, 07:27
Location: Frankfurt, Germany

Re: Cannot create a front-end result set

Post by Christof » 16 Nov 2011, 10:33

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_

Re: Cannot create a front-end result set

Post by Vishal69_ » 21 Nov 2011, 08:27

Christof wrote: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
Germany
Posts: 191
Joined: 06 Mar 2017, 07:27
Location: Frankfurt, Germany

Re: Cannot create a front-end result set

Post by Christof » 22 Nov 2011, 08:07

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

Return to “General Discussion”

Who is online

Users browsing this forum: [Applebot], [Ccbot] and 0 guests