Archivo del Autor: carlosap

http://knowledgebase.progress.com/articles/Article/P99089?popup=true   Article Number 000022572 Environment All Supported Operating Systems OpenEdge 10.x, 11.x OpenEdge Server Technology Category: AdminServer Question/Problem Description How to increase or modify java heap size for the Admin Server in OpenEdge ? How to increase java memory for Admin Server in OpenEdge? How to set the JVMARGS in Release 10? How to… Leer más: How to increase or modify java heap size for the… »

Article Number 000034388 Environment OpenEdge 10.2B06 OpenEdge 11.1 Question/Problem Description JAVA-LANG Nullpointer Exeption on starting database agent after installing 10.2B SP6 The database is started and can be connected to OpenEdge Explorer shows the database as not running Clarifying Information Database Agent started without issues in 10.2B05 Only databases with a specific servergroup defined fail… Leer más: JAVA-LANG Nullpointer Exeption on starting database agent after installing 10.2B… »

Resolution To create a SQL DBA and hide all Progress Schema tables and views from the public do the following: PRECAUTIONS: A.  Take a backup of the database prior to making any changes. B.  Test on a copy or test database prior to making changes to the Production database. 1.  Enable the SYSPROGRESS sql DBA by registering/adding  the user SYSPROGRESS via the 4GL… Leer más: How to revoke SQL privileges of the Default DBA and… »

Hi All, We are connecting to the Progress Database from ASP.NET web application using the Progress ODBC Driver. The isolation Level is set to READ COMMITTED IN THE Driver Properties. We are trying to retreive the data based on certain conditions from one of the web pages. However, if the record is locked in Progress… Leer más: odbc locks connection progress »

Nota al final añadir: – append defaultSchema=pub to the end of the URL. Like: jdbc:datadirect:openedge://localhost:5555;databaseName=testdb;defaultSchema=pub http://knowledgebase.progress.com/articles/Article/000032547   Resolution First download the installer file squirrel-sql-<version>-install.jar from http://squirrel-sql.sourceforge.net and install the SQuirreL SQL Client under Windows or Linux using the command: java -jar squirrel-sql-<version>-install.jar During the graphical installation an installation path will be asked, as well as if a base or a… Leer más: How to configure the SQuirreL SQL Client to connect to… »

or Progress 9.1D and later, the method for using the secondary login broker for SQL connections has changed. Databases that have both Progress ABL and SQL clients simultaneously connected should use a secondary login broker to avoid the following limitations caused by the use of a single broker: – The need to establish the maximum… Leer más: How to set up a secondary login broker for SQL-92… »