Archivo del Autor: carlosap

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 »

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 »

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 »

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 »

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 »