Recent content by ClayGoss

  1. C

    How to kill old report user connections...

    I found a way! Thanks!
  2. C

    How to kill old report user connections...

    We have OE10.1A running on WS2K3R2. Against it, we run various reporting tools like Crystal using a generic, read-only user. After some days, there are a bunch of connections left open under this user as folks have crashed out or the like. Someone must go in once a week and manually...
  3. C

    How to do a case sensitive query to an OE10 db that is case insensitive

    Ok. How would I do it in 4GL?
  4. C

    How to do a case sensitive query to an OE10 db that is case insensitive

    I wish to do an ODBC SQL query of an OE10 DB that was setup as case insensitive in a case sensitive fashion. Specificly, I would like to get a distinct list of the values in a field in a table showing all case versions of a given value like: THE The the ...instead of just: THE Thanks.
  5. C

    9.1C Progress Explorer won't load in MMC

    We have a system develop in Progress which is currently running against a 10.1A database. The vendor has put out an upgrade and this new version drops support for running Report Builder reports. We have a few we need to covert to Crystal. Since there is no wiz-bang conversion tool, I want to...
  6. C

    Convert Report Builder to Crystal

    Thanks tamhas, I have decicded to install a copy of Progress 9.1c on a "sandbox" server - Windows Server 2003 R2 - so I can at least open these Report Builder reports to see what they are doing. After installing it and the patches I have, the Progress Exprorer reports the following: MMC...
  7. C

    Convert Report Builder to Crystal

    I am looking for a tool/service to conver some report builder reports to Crystal. Thanks.
  8. C

    Convert Report Builder to Crystal

    I am looking for a tool/service to conver some report builder reports to Crystal. Thanks.
  9. C

    Cannot Start AdminService

    When you say "administrator", do you mean the local "administrator" or the "domain administrator"? I ask, because our production server was installed as the "domain administrator" on WS2k3 R2 and this has never been an issue. As a mater of fact, the local "administrator" has "never" logged...
  10. C

    Cannot Start AdminService

    On a workstation - Windows XP - we have a test OE 10.1A db. If I reboot the box, the AdminService appears to be runing, but ProgressExplorer cannot connect to the server declaring "Cannot connect to the Admin Server. Ensure the Admin Server is running. (8336)" If I go to Services and try to...
  11. C

    How to determine the last date/time a table was updated in OpenEdge 10 via ODBC...

    Re: How to determine the last date/time a table was updated in OpenEdge 10 via ODBC.. >> There are, probably, counters (most likely, implemented as database sequences) I am not sure what you are talking about - and suppose they exist, and would tell the date/time tables were modified, can they...
  12. C

    How to determine the last date/time a table was updated in OpenEdge 10 via ODBC...

    Re: How to determine the last date/time a table was updated in OpenEdge 10 via ODBC.. Well, not much help to me. We do not have Progress development tools - just a OE10.1A db with "embedded" licensing provided by a software vendor and the vendor's application. We would like to know where the...
  13. C

    How to determine the last date/time a table was updated in OpenEdge 10 via ODBC...

    We have an OE10.1A db - I would like to be able to determine when tables were last updated. Does anyone know of a way to query this in SQL-92 via ODBC?
  14. C

    ODBC Insert or Update a lvarbinary field with an image file's contents

    I have posted on the progress site to have some one contact me about purchasing the Developer Kit. Thanks for the input!
  15. C

    ODBC Insert or Update a lvarbinary field with an image file's contents

    There are NO .p or .w files, only .r How do I tell if the system had a 4GL developer's license with it? Is the Application Compiler in the OpenEdge Start Menu folder part of it?
Top