KB-33024: SQL Server update.
Question: Can I update SQL Server v. 2000 to v. 2005 in E3? Is there any incompatibility? Is it necessary to reconfigure E3? Solution: Yes, this update can be done…
Category: DataBases
KB-32674: Compacting an Access database.
Question: Why do Access files not reduce their sizes after its records are deleted? Is there another way to make them release this space? Solution: This is Access’ normal behavior.…
KB-32789: SQLEXPRESS’s size limits.
Question: What are SQLEXPRESS’s size limits? Solution: SQLEXPRESS 2005/2008 supports 1 CPU, 1GB RAM, and has a 4-GB storage capacity per database. SQLEXPRESS SQLEXPRESS 2008 R2 supports 1 CPU, 1GB…
KB-32112: Connection with SQL Server working only locally.
Question: Why can I only establish connection with a SQL Server Express database locally, and not in a computer other than the one where this DB is running? Solution: In…
KB-27977: Deleting the records stored in a database.
Question: How can I delete all the records from a database via E3? Solution: To do so, you have to create a Query and, in it, set up the SQL…
KB-28432: Maximum size and recommended interval for Access databases.
Question: What is the maximum size for an Access database? And how often can it record data?Solution: The maximum recommended size for an Access database is approximately 200 MB. The…
KB-27205: SQL query execution retrieval via E3.
Question: How can I tell whether a query’s DELETE command was successfully sent to the database? Solution: To do so, you can use the return of query’s EXECUTE command to…
KB-14572: Error: Table structure can’t be generated in the Database.
Question: After configuring the fields, the data server (Access), and table name in a historic, I click Generate Table and the following error message is displayed: Table structure (title of…
KB-28705: Error when executing a connection to Oracle database via scripts when Oracle Client is not installed.
Question: When I open the Viewer or WebViewer and click on a button that executes a script to query an Oracle database, a connection error to the database is generated.…
KB-19208: Copying data from an Excel spreadsheet to an Access database.
Question: How can I copy data from an Excel spreadsheet to an Access database? Solution: There are two possibilities: At runtime: With a script using an ADO connection to access…