# Database **URL:** https://discuss.workflowgen.com/c/administration/database/12.md [Latest](https://discuss.workflowgen.com/latest.md) · [Categories](https://discuss.workflowgen.com/categories.md) · [Tags](https://discuss.workflowgen.com/tags.md) --- ## [About the Database category](https://discuss.workflowgen.com/t/about-the-database-category/27)
**Author:** [@wfg-admin](https://discuss.workflowgen.com/u/wfg-admin)\ **Replies:** 0\ **Last updated:** [November 16, 2016, 5:33pm UTC](https://discuss.workflowgen.com/t/about-the-database-category/27 "2016-11-16T17:33:45Z")
Discuss database management. --- ## [Database Optimization](https://discuss.workflowgen.com/t/database-optimization/2080)
**Author:** [@lyelle](https://discuss.workflowgen.com/u/lyelle)\ **Replies:** 2\ **Last updated:** [October 28, 2022, 8:02pm UTC](https://discuss.workflowgen.com/t/database-optimization/2080 "2022-10-28T20:02:13Z")
Overview To maintain a healthy database performance or if your database is experiencing slow response time due to heavy usage, we suggest to improve its performance behavior by adding a SQL Server scheduled job (i.e. aut… --- ## [Your WorkflowGen web server occasionally receives a database connection timeout error message](https://discuss.workflowgen.com/t/your-workflowgen-web-server-occasionally-receives-a-database-connection-timeout-error-message/495)
**Author:** [@wfg-admin](https://discuss.workflowgen.com/u/wfg-admin)\ **Replies:** 0\ **Last updated:** [October 27, 2009, 1:00am UTC](https://discuss.workflowgen.com/t/your-workflowgen-web-server-occasionally-receives-a-database-connection-timeout-error-message/495 "2009-10-27T01:00:00Z")
Issue Your WorkflowGen web server occasionally receives a database connection timeout with the following error message: Server Error in '/wfgen' Application. Timeout expired. The timeout period elapsed prior to obtain… --- ## [What are the installation requirements for an Oracle 11g or 12c setup with WorkflowGen?](https://discuss.workflowgen.com/t/what-are-the-installation-requirements-for-an-oracle-11g-or-12c-setup-with-workflowgen/494)
**Author:** [@wfg-admin](https://discuss.workflowgen.com/u/wfg-admin)\ **Replies:** 0\ **Last updated:** [May 5, 2009, 2:30am UTC](https://discuss.workflowgen.com/t/what-are-the-installation-requirements-for-an-oracle-11g-or-12c-setup-with-workflowgen/494 "2009-05-05T02:30:00Z")
Note: Oracle database is no longer supported as of WorkflowGen version 7.16.0. We recommend migrating to MS SQL Server 2017 or later. There are two possible scenarios when installing WorkflowGen on an Oracle 11g or 12c… --- ## [WorkflowGen installation for Oracle fails to create the database structure](https://discuss.workflowgen.com/t/workflowgen-installation-for-oracle-fails-to-create-the-database-structure/492)
**Author:** [@wfg-admin](https://discuss.workflowgen.com/u/wfg-admin)\ **Replies:** 0\ **Last updated:** [June 23, 2008, 5:21am UTC](https://discuss.workflowgen.com/t/workflowgen-installation-for-oracle-fails-to-create-the-database-structure/492 "2008-06-23T05:21:00Z")
Note: Oracle database is no longer supported as of WorkflowGen version 7.16.0. We recommend migrating to MS SQL Server 2017 or later. Description One of the common errors that occurs during the WorkflowGen installation… --- ## [Sporadic SQL exception errors caused by anti-virus software](https://discuss.workflowgen.com/t/sporadic-sql-exception-errors-caused-by-anti-virus-software/491)
**Author:** [@wfg-admin](https://discuss.workflowgen.com/u/wfg-admin)\ **Replies:** 0\ **Last updated:** [June 16, 2008, 6:15am UTC](https://discuss.workflowgen.com/t/sporadic-sql-exception-errors-caused-by-anti-virus-software/491 "2008-06-16T06:15:00Z")
Issue If a Symantec anti-virus such as Symantec Endpoint Protection is installed and running on the WorkflowGen web server, you might experience sporadic SQL exception errors such as those listed below: Incorrect synt… --- ## [How to reset WorkflowGen runtime content](https://discuss.workflowgen.com/t/how-to-reset-workflowgen-runtime-content/499)
**Author:** [@wfg-admin](https://discuss.workflowgen.com/u/wfg-admin)\ **Replies:** 0\ **Last updated:** [July 20, 2013, 8:51pm UTC](https://discuss.workflowgen.com/t/how-to-reset-workflowgen-runtime-content/499 "2013-07-20T20:51:59Z")
Question How do I reinitialize WorkflowGen while keeping my web forms, web services and users? I would like the request count and the history of past requests to reinitialize. Solution These three SQL queries will remov… --- ## [I am not able to connect to the WFGEN database even when the user is defined in WFGEN database as a valid user](https://discuss.workflowgen.com/t/i-am-not-able-to-connect-to-the-wfgen-database-even-when-the-user-is-defined-in-wfgen-database-as-a-valid-user/498)
**Author:** [@wfg-admin](https://discuss.workflowgen.com/u/wfg-admin)\ **Replies:** 0\ **Last updated:** [January 10, 2012, 3:56am UTC](https://discuss.workflowgen.com/t/i-am-not-able-to-connect-to-the-wfgen-database-even-when-the-user-is-defined-in-wfgen-database-as-a-valid-user/498 "2012-01-10T03:56:00Z")
Issue I am not able to connect to the WFGEN database even when the user is defined in the database as a valid user. Solution The user account might be missing certain permissions. Make sure the following conditions are … --- ## [Recommended use of connection names instead of strings when connecting to an external database](https://discuss.workflowgen.com/t/recommended-use-of-connection-names-instead-of-strings-when-connecting-to-an-external-database/1550)
**Author:** [@wfg-admin](https://discuss.workflowgen.com/u/wfg-admin)\ **Replies:** 0\ **Last updated:** [January 9, 2020, 3:08pm UTC](https://discuss.workflowgen.com/t/recommended-use-of-connection-names-instead-of-strings-when-connecting-to-an-external-database/1550 "2020-01-09T15:08:24Z")
We strongly recommend using a connection name rather than a connection string in your custom solution or application code when connecting to an external database in order to simplify multi-environment management. Connec… --- ## [How to insert (add) a record to a database table](https://discuss.workflowgen.com/t/how-to-insert-add-a-record-to-a-database-table/496)
**Author:** [@wfg-admin](https://discuss.workflowgen.com/u/wfg-admin)\ **Replies:** 0\ **Last updated:** [January 5, 2010, 4:10am UTC](https://discuss.workflowgen.com/t/how-to-insert-add-a-record-to-a-database-table/496 "2010-01-05T04:10:00Z")
The following example shows how to create a database table and then populate that table with values from your form using code-behind. First, you’ll need a table in a database. Use the following script to create a test t… --- ## [How to configure a common datasource for use in multiple WorkflowGen instances](https://discuss.workflowgen.com/t/how-to-configure-a-common-datasource-for-use-in-multiple-workflowgen-instances/501)
**Author:** [@wfg-admin](https://discuss.workflowgen.com/u/wfg-admin)\ **Replies:** 0\ **Last updated:** [March 13, 2015, 2:49am UTC](https://discuss.workflowgen.com/t/how-to-configure-a-common-datasource-for-use-in-multiple-workflowgen-instances/501 "2015-03-13T02:49:06Z")
Description Multiple instances of WorkflowGen can be set up independently from each other (for example, Developer, QA, Production), each with its own master database. When deploying a process that uses global lists or d… --- ## [I receive the following SQL error when accessing WorkflowGen: A SQL error has occurred .Net SqlClient Data Provider: Invalid column name ‘RES’](https://discuss.workflowgen.com/t/i-receive-the-following-sql-error-when-accessing-workflowgen-a-sql-error-has-occurred-net-sqlclient-data-provider-invalid-column-name-res/497)
**Author:** [@wfg-admin](https://discuss.workflowgen.com/u/wfg-admin)\ **Replies:** 0\ **Last updated:** [February 27, 2010, 9:34am UTC](https://discuss.workflowgen.com/t/i-receive-the-following-sql-error-when-accessing-workflowgen-a-sql-error-has-occurred-net-sqlclient-data-provider-invalid-column-name-res/497 "2010-02-27T09:34:57Z")
Solution If you receive an SQL error indicating .NET SqlClient Data Provider: Invalid column name RES, it’s likely because your SQL Server database collation is set to Latin1\\\_General\_BIN, which is not compatible for us… --- ## [Access information given in the form](https://discuss.workflowgen.com/t/access-information-given-in-the-form/1057)
**Author:** [@athomas](https://discuss.workflowgen.com/u/athomas)\ **Replies:** 1\ **Last updated:** [May 23, 2018, 4:30pm UTC](https://discuss.workflowgen.com/t/access-information-given-in-the-form/1057 "2018-05-23T16:30:04Z")
So once someone hits submit, the information on the form gets stored into a database. Where can I begin researching how to utilize the information stored in that database for another app that my team is developing? --- ## [Using the Process data storage option](https://discuss.workflowgen.com/t/using-the-process-data-storage-option/502)
**Author:** [@wfg-admin](https://discuss.workflowgen.com/u/wfg-admin)\ **Replies:** 0\ **Last updated:** [November 17, 2016, 3:38am UTC](https://discuss.workflowgen.com/t/using-the-process-data-storage-option/502 "2016-11-17T03:38:53Z")
By default, process file data (including attachments) are stored in the WorkflowGen file system or in a predefined path. However, you can store them in the WorkflowGen database instead by enabling the Process data storag… --- ## [Setup: Oracle: Error nvarchar2 cannot be 4000](https://discuss.workflowgen.com/t/setup-oracle-error-nvarchar2-cannot-be-4000/500)
**Author:** [@wfg-admin](https://discuss.workflowgen.com/u/wfg-admin)\ **Replies:** 0\ **Last updated:** [June 14, 2014, 2:40am UTC](https://discuss.workflowgen.com/t/setup-oracle-error-nvarchar2-cannot-be-4000/500 "2014-06-14T02:40:35Z")
Issue When trying to install Workfowgen with an Oracle Database we get an error "Error nvarchar2 cannot be 4000." Solution It depends on the Database character set. WorkflowGen supports only National and Database… --- ## [WorkflowGen v5: What are the installation requirements for an Oracle 10g setup with WorkflowGen?](https://discuss.workflowgen.com/t/workflowgen-v5-what-are-the-installation-requirements-for-an-oracle-10g-setup-with-workflowgen/493)
**Author:** [@wfg-admin](https://discuss.workflowgen.com/u/wfg-admin)\ **Replies:** 0\ **Last updated:** [May 5, 2009, 1:32am UTC](https://discuss.workflowgen.com/t/workflowgen-v5-what-are-the-installation-requirements-for-an-oracle-10g-setup-with-workflowgen/493 "2009-05-05T01:32:00Z")
For WorkflowGen version 5.x only Issue What are the installation requirements for an Oracle setup with WorkflowGen? Description There are 2 possible scenarios when installing WorkflowGen on an Oracle 10g database…