Search results

  1. T

    Table repair question

    Forgot to run the dbtool - works now in sqlexp.bat so thats cool. Thank you Caspar and tamhas for all your help and swift replies!
  2. T

    Table repair question

    Manged to update lock files in Progress Explorer Tool under default configuration. Managed to do all update commands. Unfortunately I still get === SQL Exception 1 === SQLState=HY000 ErrorCode=-210012 [DataDirect][OpenEdge JDBC Driver][OpenEdge] Column notes in table PUB.lc has value...
  3. T

    Table repair question

    Just set in %DLC%\startup.pf the line "-L 15000" and restarted the server in the Progress Explorer Tool. Restarted sqlexp and am still getting the Lock table is full error. Checked log file, it said to increase the -L number so I put it up to 50000. Restarted server and sqlexp.bat and still...
  4. T

    Table repair question

    Thanks for your reply. Am trying to do this but get the following when I do the update index or update column lines: === SQL Exception 1 === SQLState=HY000 ErrorCode=-210016 [DataDirect][OpenEdge JDBC Driver][OpenEdge] Lock table is full. (7870) I tried changing my ODBC isolation...
  5. T

    Table repair question

    Unfortunately it does not give me a progress error number. I have just done another test and I can retrieve all data apart from 1 field per table. So I could grab the data one column at a time I suppose. Thanks for the tip about sqlexp utility which I had not found yet. Did SELECT *...
  6. T

    Table repair question

    Attempt to access table through ODBC from R. Message from Visual Studio JIT debugger: An unhandled win32 exception occurred in Rgui.exe [12720]. Attempt to access same table with DTS Wizard error: Messages Error 0xc02090f5: Data Flow Task: The component "Source - Query" (1) was unable...
  7. T

    Table repair question

    The tables all have legal filenames if thats what you mean. I get table data via the following SQL: SELECT * FROM PUB.\"tablename\" If I do, for example: SELECT TOP 1 * FROM PUB.\"tablename\" Then I get 1 row. However if I do say SELECT TOP 100 * FROM PUB.\"tablename\"...
  8. T

    Table repair question

    Aha - you're quite right - so much for search facility in Opera. Anyway, I did the following to get the database to work with 10.2B, 1) cd %DLC%\bin\101dbutils 2) set DLC=<path to the DLC installation>\bin\101dbutils 3) set PROMSGS=%DLC%\promsgs 4) set PROCFG=%DLC%\progress.cfg 5) set...
  9. T

    Table repair question

    Thanks for your reply. Not sure what you mean though, I could find the string "fixed to work with" in my message. So far I have found that I can access certain fields and certain early rows so am writing a function to go row by row until it hits the one that causes the exception. I still...
  10. T

    Table repair question

    No I didn't. Should I have done? If so how would I have done that?
  11. T

    Table repair question

    Hi, I am trying to retrieve some data out of a couple of tables from an old Progress 10.0B database which was then fixed to work in Progress 10.2B (of which I have the Evaluation copy at present). I have managed to get at 90% of the data but there are 14 tables which appear to elude me. I...
  12. T

    Progress equivalient to LIMIT clause

    Hi, I need to page through a table. Normally in something like MySQL I would do something like SELECT * FROM [table] WHERE [condition] LIMIT [start],[n] I would then in whatever scripting language it is increment start multi times until there were no more records. Thereby I could say...
  13. T

    Progress Explorer Tool Question

    Aha! Moved the database files to the C drive and it worked. Thank you for all your help and swift replies - very much appreciated!
  14. T

    Progress Explorer Tool Question

    So the DLC path was the reason for the last message. Now all I get when I do the proutil command is: "OpenEdge Release 10.2B as of Mon Dec 14 17:02:01 EST 2009" Still no lg files being created anywhere.
  15. T

    Progress Explorer Tool Question

    There is no .lg file in the same directory as the demo.db file. I tried a search which came up with nothing. I tried your command line command specifying twice, once with the absolute paths and the second with relative paths. Both came up with the message: "The system cannot find the...
  16. T

    Progress Explorer Tool Question

    Thanks for your replies. MaximMonin: The path inside the demo.db file was .\demo.db. When I tried just typing Demo or demo as the database filename, and pressed the start button it said it could not find the database. As this does not happen when I specify the full path I assume this means...
  17. T

    Progress Explorer Tool Question

    Hi, I am new to Progress and am trying to create a new server for the Demo database in 10.2B. I have several questions. (1) When I type a Path and filename of a database into the Database Properties window, the comment at the bottom always says "database not found", would this change...
  18. T

    Problems upgrading from OpenEdge 10.0B to 10.2B

    Thanks everyone, I have now managed to do it with your help and some support from progress. For the record this is how I did it.1) cd %DLC%\bin\101dbutils2) set DLC=\bin\101dbutils3) set PROMSGS=%DLC%\promsgs4) set PROCFG=%DLC%\progress.cfg5) set PROCONV=%DLC%\convmap.cp6) set...
  19. T

    Problems upgrading from OpenEdge 10.0B to 10.2B

    Thanks, that makes sense.
  20. T

    Problems upgrading from OpenEdge 10.0B to 10.2B

    Ok, so in 10.0B the row ids were 32-bit and in 10.2B the row ids are 64-bit. Just to be clear, are you saying there is no way to open a 10.0B database in 10.2B?
Back
Top