Search results

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!

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...

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...

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...

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 *...

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...

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\"...

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...

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...

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

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...

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...

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

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.

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...

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...

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...

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...

Thanks, that makes sense.

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?