INI File

Owned by Nate Edwards
Last updated: Dec 20, 2024 by Patrick Murphy

Below is a line by line explanation of the ini file (the order of lines may be slightly different in your ini file.)

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

Example INI File

  1. [DatabaseConnection] 
  2. DatabaseName=gendata 
  3. AttachDBFileName=C:\ProgramData\Esha Research\data\eshadata.mdf
  4. Provider=SQLOLEDB.1
  5. ServerName=servername\esha
  6. DBConnectionString=Provider=SQLOLEDB.1;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. NutrientFilesFolderPath=C:\NutrientFiles
  16. AlternateReportFilesFolderPath=C:\CustomReports 
  17. [Recent File List] 

Line options and other settings:

[DatabaseConnection] Denotes the Database Connection section

DatabaseName=gendata  (typically "eshadata" for Food Processor, can be custom name of your database as well, you can verify this with the mdf name on the server)

AttachDBFileName= (This is the location of the database file, it can be left blank as noted on the left of the path to the mdf as in line 3 above) 

Provider=SQLNCLI11 (There are two options for this line, SQLNCLI11 (2012 and later) and SQLOLEDB.1 (2008 DB Instances))

ServerName=servername\esha (The servername goes here, 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)

DBConnectionString=Provider=SQLOLEDB.1;Data Source=servername\esha;Initial Catalog=gendata;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 (overrides the Database Connection Settings above)

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

NutrientFilesFolderPath=C:\NutrientFiles This sets an alternate location for nutrient files (this can be a shared drive as well.) The program will look in both the c:\program files (x86)\esha research\foodprosql\nutrientfiles\ and c:\programdata\esha research\foodprosql\nutrientfiles\ folders to find .nut files

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\genesissql\AdditionalReports

[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