KB-36107: Synchronizing databases in HotStandBy applications.
Question: In a HotStandBy application with two databases to record the same data (one in the main computer, and another one in the secondary computer), is there synchronism between DBs?…
Category: DataBases
KB-27220: Authentication error on MS SQL Server.
Question: Why is thre an authentication error when I try to establish connection with an MS SQL Server database? Solution: To fix this, you must use the MS SQL Server’s…
Settings for enabling network access to SQL Server.
This article illustrates the necessary settings to enable remote access to SQL Server Express 2005. 1. Go to Start–All Programs–Microsoft SQL Server 2005–SQL Management Studio Express and follow the instructions…
KB-32513: Select() and Update() in the same SQL clause.
Question: Can I set a Select() and an Update() in the same SQL clause, similarly to the example below? Update EQUIPMENT Set EQUIPMENT.EQUIPMENT=’‘, EQUIPMENT.DISABLED=, EQUIPMENT.CLASS_EQUIP=CLAS_EQUIP.INDEX, EQUIPMENT.SECTOR=SECTORS.INDEXWhere EQUIPMENT.INDEX= and CLAS_EQUIP.CLASS_EQUIP=’‘ and…
KB-31234: Pointing to the local computer in the Database.
Question: How can I point to the local computer in the Database? Solution: To do so, go to Server field in the Database’s proprerties, erase the computer’s name and then…
KB-31065: Connecting E3 to a Pervasive Database.
Question: Can I connect E3 to a Pervasive Database via ODBC? Solution: Yes, you can, but there are technical problems. You must know the connection string, and you cannot use…
KB-26454: Data loss when E3Server disconnects from the Database.
Question: How can I set a security procedure in order to avoid losing data when E3 Server disconnects from the Database? Solution: E3 automatically avoids losing data on the Database:…
KB-6354: E3’s _sync.e3i file in HotStandby mode.
Question: Why is the name_of_database_sync.e3i file created in the active server of an application in Hot-Standby mode? Solution: When you enable the EnableSyncrhonization property in an application on HotStandby mode,…
KB-32697: Data exchange between E3 and an application developed on C++ Builder.
Question: Can data be acquired from an application developed on C++ Builder and viewed in E3? Solution: Yes, it can! To do so, we recommend one of the following: OPC…
KB-35543: SQL query returns values only when date/time field is an exact value.
Question: How can I set up an SQL query to return data whenever a historic field of type date/time has a certain value? Solution: For a Microsoft SQL Server…