Search results

I realize this isn't directly a Progress question, but does anyone know a good place to get help on deciphering the QAD database? QAD's ER and data dictionary files are very incomplete and at least sometimes wrong. I post about these problems on community.qad.com in their BI, Reporting &...

Well, it seems that when I run mpro /mypath/mydb, mpro ignores that database and does not setup a connection to that database. So then I tried mpro /mypath/mydb -S myportnumber and I got the error message The server or the system has no more resources. Please contact Progress Technical Support...

Environment is character mode Linux on a machine with QAD installed. I use putty on a Windows 7 PC to ssh into the Linux machine. I suspect this is part of my challenges. I have tried to use MPRO to do some ABL commands that clearly won't work running on SQLENV. I can't seem to copy and paste...

I am reviewing some QAD tables and it appears that Progress lets you define a unique index that has a nullable column. Is that correct? This is in an OpenEdge 10.2 database. (for QAD users, one example table is vph_hist having the nullable columns vph_ref and vph_pvo_id as part of the unique...

I ran dbtool and it appears to do nothing. As soon as I give an answer to the prompt about verbose level, I IMMEDIATELY get back to the linux prompt as if the tool has run and done everything in a nanosecond. It is actually doing nothing as I the ODBC error messages continue. I also noted that...

Both of these failed: select top 10 * from mylinkedserver.mydatabase.sysprogress.systables select top 10 * from mylinkedserver.mydatabase.pub._file error message for 1st one: Msg 7356, Level 16, State 1, Line 3 The OLE DB provider "MSDASQL" for linked server "mylinkedserver" supplied...

The simple ODBC test connection works. The simple linked server test connection works. I can get a list of tables using that linked server. Outside of SQL Server, I can write a powershell script that does a select * from sometable. I cannot get a Select * from [whateverlinkedtable] to work...

I am brand new to Progress/OpenEdge, QAD (and my new employer). Using QAD/Progress is just part of my duties as their DBA. So I am looking for something with a little bit easier to use tool to explore the data in QAD than the character mode SQLEXP. What are 1 or a few options? (which might...