Mailing List Archive: 49091 messages
  • Home
  • Script library
  • AltME Archive
  • Mailing list
  • Articles Index
  • Site search
 

ODBC/Error

 [1/5] from: sqlab:gmx at: 9-Jan-2003 10:11


Hello A few weeks ago, I complained about not getting a response to my feedback reporting an error with ODBC in /Command. As I still have no answer, I am asking the list, how do you handle severe ODBC errors. The special error I get when pulling the network plug from a computer connected to an Oracle Database via ODBC. I can catch the first error occurence, but after recovering my script throws an second (ODBC) error executing commands doing nothing with ODBC. If I catch the second error too, Rebol starts to consume MB of memory very soon. So this is no real help. Has someone a solution to this? TIA AR -- +++ GMX - Mail, Messaging & more http://www.gmx.net +++ NEU: Mit GMX ins Internet. Rund um die Uhr für 1 ct/ Min. surfen!

 [2/5] from: maarten:koopmans:surfnet:nl at: 9-Jan-2003 10:51


Try a different database with different ODBC driver (Mysql for example). Then you can rule out that that's the one consuming the memory and causing the problems. --Maarten

 [3/5] from: sqlab:gmx at: 10-Jan-2003 9:43


For some reasons Mysql is no viable alternative. But I will try with some different drivers when I have some time. Additonally I will try what a unloading and loading of the ODBC driver will do. Unfortunately RT has no Free for ODBC, although they provide it for the DLL API. AR
> Try a different database with different ODBC driver (Mysql for example). > Then you can rule out that that's the one consuming the memory and > causing the problems. > > --Maarten >
-- +++ GMX - Mail, Messaging & more http://www.gmx.net +++ NEU: Mit GMX ins Internet. Rund um die Uhr für 1 ct/ Min. surfen!

 [4/5] from: sqlab:gmx at: 10-Jan-2003 12:28


I used different drivers and the waste of memory is directly correlated to the amount of memory I allocate in REBOL. Just the internal garbage collector is no longer working. This is also indicated by the fact, that the most following errors happen near an recycle. AR
> Try a different database with different ODBC driver (Mysql for example). > Then you can rule out that that's the one consuming the memory and > causing the problems. > > --Maarten >
-- +++ GMX - Mail, Messaging & more http://www.gmx.net +++ NEU: Mit GMX ins Internet. Rund um die Uhr für 1 ct/ Min. surfen!

 [5/5] from: maarten:koopmans:surfnet:nl at: 10-Jan-2003 14:43


What command version are you using? There are intermediate builds that have bug fixes in the gc. If you are using 2.0, go to rebol.com and ask for a more recent build. Perhaps that helps. --Maarten