What is the INI file?

Note: this applies to on-premises installations only.  ESHA Cloud deployment does not conform to these INI file settings.

With every install of the Food Processor, there is an INI file ("foodprosql.ini") created that can be modified for various changes. Below is a line-by-line explanation of the INI file. (The order of lines may be slightly different in your file.)

INI files are located in the install directory (by default C:\Program Files (x86)\Esha Research\FoodProSQL\foodprosql.ini)

Note: It is likely the INI file is protected.  To edit the file either follow either method below:

1. Open Notepad as Administrator and navigate to the file location, edit and save the changes. Or,
2. Copy the INI file from its original location to the Desktop.  Open & edit the file in a text editor, and save your changes.  Then, copy (and replace) the INI file back to the program directory.

Example INI File

1. [DatabaseConnection] 
2. DatabaseName=eshadata
3. AttachDBFileName=C:\ProgramData\Esha Research\data\eshadata.mdf
4. Provider=SQLNCLI11
5. ServerName=servername\esha
6. DBConnectionString=Provider=SQLNCLI11;Data Source=servername\esha;Initial Catalog=eshadata;Integrated Security=SSPI;User Id=;
7. UsesUDLFileConnection=0
8. UDLFilePathString=
9. CommandTimeout=20
10. ConnectTimeout=180
11. [Application]
12. UseGlobalSettings=0
13. GlobalSettingsOwnerId=0
14. GlobalSettingsOwnerName=
15. NovaPdfPrinterName=FoodPro PDF Printer
16. NutrientFilesFolderPath=C:\NutrientFiles
17. AlternateReportFilesFolderPath=C:\CustomReports 
18. PersonalTemplateFolder=C:\EshaPortTemplates (This is only for ESHA Port)
19. [Recent File List] 

Line options and other settings:

[DatabaseConnection] 
Denotes the Database Connection section.

DatabaseName=eshadata
typically "eshadata" for The Food Processor but can be custom name of your database as well, you can verify this with the name of the database as attached in SQL Server.

AttachDBFileName=
This is the location of the physical database file.  In some cases this line may be blank (after the equals sign).

Provider=
There are three potential options for this line:
   · MSOLEDBSQL.1 (SQL Server 2014 and later)
   · SQLNCLI11 (SQL Server 2012 and later)
   · SQLOLEDB.1 (SQL Server 2008)

ServerName=SQL Server Instance Name
Typically, [COMPUTERNAME\ESHA] for an ESHA-installed SQL Server instance.  For a local install it can be (localdb)\v11.0.  It can also be different than the servername\esha format if you created your own instance for the database.  For some cases, a Port is required (e.g. [SERVERNAME], [PORT NUMBER]).

DBConnectionString=Provider=[Provider= from above];Data Source=[SQL Server Instance Name];Initial Catalog=[Database Name as Attached in SQL Server];Integrated Security=SSPI;User Id=; 
This is the connection string and should match with the previous lines (data source = servername and initial catalog = database name).

UsesUDLFileConnection=0 
This is set to 0 normally, it will be set to 1 if you want to force the UDL connection.

UDLFilePathString= 
If using the UDL file, this is the path to where you have the UDL file (most commonly in the install directory).

CommandTimeout=20 
This controls the timeout on commands, 20 seconds is default and rarely changed

ConnectTimeout = 180
This controls the timeout when launching the program and connecting to the database, on slow systems this may be extended or rarely shortened (for testing) measured in seconds 180 allows for 3 minutes to connect to the database before timing out.

[Application] 
Denotes the Application section.

UseGlobalSettings=0 
Change to 1 to use global settings (share settings between users).

GlobalSettingsOwnerId=0 
The owner of the global settings, the name of the user who will be the default settings. Typically it would be something like DomainName\UserName if you are using Windows authentication.

NovaPdfPrinterName=FoodPro PDF Printer
Starting with 11.4, versions of Food Processor this line is set to an ESHA-installed PDF driver.

NutrientFilesFolderPath=C:\NutrientFiles 
This sets an alternate location for nutrient files (this can be a shared drive as well.) The program will automatically list nutrient configuration files from (a) the installation directory, (b), the default directory to which *.NUT files are stored, and (c) this path (if present in the INI and not empty).

AlternateReportFilesFolderPath=C:\CustomReports 
This sets an alternate location for Report Files (this can be a shared drive as well.) The default path for reports is C:\Program Files (x86)\Esha Research\programname\AdditionalReports.

PersonalTemplateFolder=C:\EshaPortTemplates 
This is only for ESHA Port, this will allow for additional templates (epf files) to be selected from the template drop-down menu.

[Recent File List] 
The files listed here are automatically logged by the program to show up in your recent file list menu on your respective program.