Search results

  1. Jeff Winchell

    Good Place For Qad Database Documentation Support

    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 &...
  2. Jeff Winchell

    Launching Mpro - Error 748 No More Resources

    Actually I went on a wild goose chase though I learned something from it (including all your comments above). This proved to be the solution to my exact problem: How To Use Mpro
  3. Jeff Winchell

    How To Use Mpro

    THAT is the solution to my confusion/the confusing error messages. Thank you!
  4. Jeff Winchell

    Launching Mpro - Error 748 No More Resources

    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...
  5. Jeff Winchell

    Dbtool Does Nothing. Still Have Odbc Data Width Errors

    FWIW, I have a lot of experience using software where the database and application comes from the same vendor, including products where there was very little relational about the DBMS. Seems to me that every database vendor either tries to champion the fact that they are relational, or that they...
  6. Jeff Winchell

    How To Use Mpro

    In Putty's settings for Connection|Data|Terminal Details|Terminal-types string I changed the default value of xterm to linux and standard editor keys (delete/backspace/home/end, arrow keys,etc) all worked as expected, but then the Function keys stopped working, though I saw on a thread you (Rob)...
  7. Jeff Winchell

    Simple (but More Than Char Mode Sqlexp) Querying Tool For Qad2013ee On Redhat

    I should have amended this message. I got ODBC mostly working. I have another thread now about trying to use mpro which seems to be the only non-sql interface that resides on the same linux box that runs the progress db. I think I found a file from 2001 that gives some tips.
  8. Jeff Winchell

    Dbtool Does Nothing. Still Have Odbc Data Width Errors

    I was talking about a database having fields marked as mandatory, so I don't know what "if the application makes the field mandatory" has to do with this.
  9. Jeff Winchell

    How To Use Mpro

    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...
  10. Jeff Winchell

    Simple (but More Than Char Mode Sqlexp) Querying Tool For Qad2013ee On Redhat

    OK. So I need to skip ODBC to make sure nothing is getting mistranslated and deal directly with the OpenEdge databases. On Redhat Linux 6.5 I believe my two options from Progress Software to talk to some non-single user data sources are the mpro and sqlexp. Is that correct?
  11. Jeff Winchell

    Dbtool Does Nothing. Still Have Odbc Data Width Errors

    The comment in this thread about making a field mandatory yet having to rely on the application to "make it so" has me concerned. So I'd like to check if there are examples in my QAD database where a table's column is listed as N in sysprogress.syscolumns.is_nullable, but in the actual data this...
  12. Jeff Winchell

    Dbtool Does Nothing. Still Have Odbc Data Width Errors

    Yes. That is what I am doing (copy a db to MS SQL), while also learning a bit at a time about the DBMS properties of Progress since my company has had that (with QAD) for some years and will continue to have that QAD app for some years.
  13. Jeff Winchell

    Unique Index On Nullable Column?

    Oh fun. ;-) "Note that you can avoid this happening by marking the field as mandatory, but, of course, you need matching application logic to ensure that a value is assigned." When you mark a field as mandatory, does the sysprogress.syscolumns.nullflag get set to "N"? (If so this means I can't...
  14. Jeff Winchell

    Unique Index On Nullable Column?

    So there can be multiple records with the same value (in the sense that the null must be recorded as some kind of byte/series of bytes in the index), but if you can't create a unique index on a table (say one one column) and insert two records with this same unique index key non-null value (like...
  15. Jeff Winchell

    Unique Index On Nullable Column?

    dBASE from its early days had what they called unique indexes which would let you find the one record matching a value in the index, and if there were more than one records with that value, the index would not let you find those others. Then various dBASE clone products copied that design and...
  16. Jeff Winchell

    Unique Index On Nullable Column?

    Then I will bite my tongue. ;-)
  17. Jeff Winchell

    Unique Index On Nullable Column?

    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...
  18. Jeff Winchell

    Dbtool Does Nothing. Still Have Odbc Data Width Errors

    I thought I saw that QAD gets started by the account I logged in with. But apparently it gets launched by the root, which to me is suboptimal. Later down the road I will do a security audit on our QAD installation and likely change a bunch of stuff.
  19. Jeff Winchell

    Dbtool Does Nothing. Still Have Odbc Data Width Errors

    So after running dbtools logged in as root I was able to use the ODBC driver in order to import some progress tables into SQL Server using SQL Server's default import facilities. However, one bug that I referenced here Querying The Catalog Via Odbc still remains. When I used linked servers to...
  20. Jeff Winchell

    Dbtool Does Nothing. Still Have Odbc Data Width Errors

    OK. I seemed to have solved the problem by logging on with the root user. I'm not sure why the account which seemed to have root privileges was not good enough, but I'll take this for now. I also just learned we are going live in about 2 months with QAD 2016 which uses Progress 11.6. So it won't...
Top