This is where the error occurs. Error using Sybase IQ proxy table. I have looked at the showplan. Email Required, but never shown. Please wait while this file loads, or download it here.

Uploader: Jumuro
Date Added: 25 June 2009
File Size: 43.73 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 79377
Price: Free* [*Free Regsitration Required]

ODBC ERROR [HY] in Workflow – Laserfiche Answers

Oct 12 A re-boot may help clear things up as will adding a couple of sticks of RAM if needed. Everything was already OK, except for 5b and 5d where I had to check Allow jicrosoft some choices. You are not allowed to follow up in this post. After restarting the model, the computation runs ok for the same query and data set, but I quickly get the error again.

That file has only the following 3 lines as mentioned mivrosoft Thanks a lot for your reply. Here is the code:. Maybe their ‘output’ through ODBC is not appropriate?

I am wondering after creating the excel file you need to reboot, because windows still sees the excel file open in the temp folder? Sign up or log in Sign up using Google. Post Your Answer Discard By clicking “Post Your Answer”, you acknowledge that you kdbc read our updated terms of serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies.


SAP SQL Anywhere Forum

Are you trying to access a large file? When my application is running up to the memory problem, I think I have, maybe 0.

If you don’t want to migrate, try comparing the query plans ShowPlan debugging. I had exceel same problem and i found the solution, changing the version of the Asp that use the web app. It won’t be the only software requiring a reboot before every use, Norton Ghost on XP is another, at least on my setup.

Nothing has changed to our knowledge but we are getting the following error when trying to test the connection. ODBC export to excel errors. It seems there is a memory leak in the Windows7 version, as the same model and data works fine on an older Windows XP computer with less memory.

ODBC export to excel errors

Please wait while this file loads, or download it here. You are viewing limited content. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

An example is the following that is part of my GLPK code: How much fxcel free when your application is running up to the memory problem?


Are you unchecking the ” read – only ” attribute that is on by default in the options before export? Plus in memory of Thomas Edison here’s another technique that did not work: As a suggestion – brake your query into some sub-query with their own where predicates and finally join just the results. Sep 06, Fortunately, I might have found a workaround; I ht001 not hh001 the error when I run the python file containing the code to start the many model runs outside of my Python compiler, in a command prompt.

So, I’d appreciate it if you can tell me easy-to-follow steps on how to close the connection and when, using the. Here is the code: A connection could not be made using the file data source parameters entered. Odb tables live update or one time only. The “solution” documented here might not be the correct one.