EventPro User Manual

[Database]

Hide Navigation Pane

[Database]

 Previous topic Next topic No directory for this topic No expanding text in this topic  

[Database]

 Previous topic Next topic Topic directory requires JavaScript JavaScript is required for expanding text JavaScript is required for the print function Mail us feedback on this topic.  
1.You can connect to an Access database (Standard Version) or to an SQL Server database (Enterprise Version).  
2.Go to C:\Program Files\EPWeb\Bin and open the EPWeb.ini file in Notepad.  Look at the [Database] section near the bottom of the page. This determines where and how the connection to the database is made.
a.The Standard Version (Access) database looks like this:

[Database]

Provider=JET

DatabasePath=

DatabaseName=

b.The Enterprise Version (SQL) database looks like this:

[Database]

Provider=MS-SQL

DatabaseName=

SQLServer=

SQLAuthentication=Y

UserName=

Password=

3.To change from an access database to an SQL database, note the additional lines you must add to the bottom of the EPWeb.ini file.
4.Below is a list of the options and their descriptions.

Option

Description

Provider

This option specifies database type and sets how you will be connecting to the database. If you are connecting to an access database, you would enter JET for the provider. If you are connecting to a SQL Server database, you would enter MS-SQL as the provider.

DatabasePath

This is the path to the folder that contains the EventPro access database. This option only applies to a Jet provider (Standard users only).

DatabaseName

If you are using a Jet provider, this option will be the name of the database file (for Standard users only).  If you are using MS-SQL as the provider, this option would be the actual name of the database.

SQLServer

This option only applies to a MS-SQL provider. It specifies the SQL server name.

SQLAuthentication

This option only applies to a MS-SQL provider. Give this option a value of Y if you are using SQL authentication or N if you are not. If you are using SQL authentication, you will need to enter values for the Username and Password options. If you are not using SQL authentication, Windows authentication will be used.

When using Windows Authentication, the IUSR account of the server running EPWeb will require Read/Write Access to the EventPro database.

Username

This option only applies to a MS-SQL provider using SQL authentication. This is the username used to log into the SQL Server.

Password

This option only applies to a MS-SQL provider using SQL authentication. This is the password used to log into the SQL Server.