Search results

Last week we had a corrupt index on a progress (9.1e) database. After reindex, the problem was solved. My question is: What is the best way to regulary check the db consistency so we can prevent this type of problems? Are there any "standard" scripts/batch files out there with the 'standard' db...

Hello, I've been searching for long times for finding this sort of information. I'm trying to get peoples pictures out of Progress into Microsoft SQL. I managed to insert the information in SQL tables, but as stated in this discussion, its broken into 16k chunks. So now i have a table with...

Hello, Is it possible what you suggest, to set up a linked server (linked to progress, and it works fine) as a publisher and distributor to a MS SQL subscriber?

Hello, I'm also using a linked server to access data from progress. But when i do a query like select * from openquery(linkservername, 'select * from table') I notice in the results the column order is different than it should be. Is there any way to influence the column order, but still...

...another problem: I'm trying to create a linked server in SQL 2008 to Progress with an ODBC link. We successfully installed and tested the MERANT 3.60 32-BIT Progress SQL92-v9.1.D. Also the connection test was succesfully. We installed it from the 32-bit ODBC Administration tool in Windows...

..Thanks Casper, We did some extra research and found a workaround for this problem: If youget to the summary screen during installation, start the resource kit utility (formerlyy sysinternals) "process explorer" and do a find on _isdel.exe. Double-clik on all ISDEL.exe's of the typ "handle"...

Hello, I know this post is quite "old", bu I'm having the same problem like you did, except i'm running Windows Server 2008 x64. I'm triny to install Progress 9.1E, but get the same error: "the process cannot access the file because it is being used by another process...

...I am wondering why the EXPORT command is not used in the script? Wouldn't that be a lot easier, to build a script tha exports the listed tables by using the EXPORT command?

Wow Thanks! That works perfect! At first I replaced the wrong part of the code, but when I corrected it, it worked! Many Thanks!:)

...well, the export script works, and all selected tabels are exported to csv files, with semi-colon as delimiter, BUT...next problem: all rows in each csv file end with a semi-colon, like this: rf502_obj;rf502_code;rf502_desc; 1763394,2027;10;"Contact person"; 1763395,2027;20;"Report at"...

Casper, It works!:) Finally! I'v been trying and trying again, and kept getting the "could not create buffer" error. Main difference is that I used the prowin32 command, and you are using the mbpro command. But maybe we had an incorrect path or something like that. Many Thanks! FYI, We are...

No, it even fails with just 1 table, en it's certainly typed correct. For some reason, I think you were right that it has something to do woth not having connection to the database, maybe the .pf file i used. Did you try to run this export.p from a .bat file? If so, can you post the command line...

...to be honest I changed it a bit :blush:. In wanted the script to export only some tables, not just 1 and not all of them. In the next sample only 1 table is exported, but there can be entered more. The table name in the error is the one in the script, ms120. DEFINE VARIABLE cDir AS...

...well, the batch file contains c:\etcetc..\prowin32.exe -b -pf c:\test\param.pf -p c:\test\export.p and the param.pf filed contains -db tbsdb Is it not enough for connection? What should be the correct command line?

Hello, I'm new to ProgressTalk and this is my first post!:) I tried te dynamic table-dump script, and in the Prodedure Editor, it works! However, when I run it from a .bat file, I get the error message: "Could not create buffer object for table ... (7334)" What am I doing wrong? Using...