Welcome to our knowledge base. To find what you're after, use the search box below or choose a category to view listed questions.

Search the Knowledgebase

Browse by Category

[Advanced Search]

-- Select Category -- Genesis R&D Genesis R&D SQL Nutrition     - Nutrition: General Database     - Nutrition: General Software     - Nutrition: International     - Nutrition: Labeling     - Nutrition: Nutrients & Nutrient Components     - Nutrition: Recipe Analysis     - Nutrition: Specific Foods The Food Processor The Food Processor SQL Utility Programs     - Database Utility     - ESHA Port SQL     - ESHA Security SQL

View Questions by Category

There are no sub categories

The Food Processor SQL

Knowledge regarding the SQL version of The Food Processor (Page 1 of 3)     «« |  Prev | 1 | 2 | 3 | Next | »» There were 51 questions found in this category: An error oppears when searching. (Internal SQL Server error.ADO Errors: 1 -2147217900) When searching, the program actually performs a number of searches to develop the list of matching results. In a recent update, one of the searches has begun resulting in an error. Specifically, that search is the Frequency search.Note simply clicking OK will display the search results.Search re ... Attaching the ESHA Database to SQL Server (using Database Utility) To attach the ESHA Database (eshadata or gendata) to SQL Server:1. Copy the *.mdf file from "[CD]:\win32\program files\ESHA Research\data" into the to a drive that is local to the computer (recommended is "c:\program files\ESHA Research\data").2. Check/change attributes on that file so it is no ... Attaching The Food Processor Database to your instance of SQL Server 2000 Note: using the ESHA Database with your own instance of SQL Server will require the server collation to be 'SQL_Latin1_General_CP1_CI_AS'.To attach The Food Processor Database (eshadata) in SQL Server 2000: Copy the eshadata.mdf file from "[CD]:\win32\program files\ESHA Research\data" into a d ... Attaching The Food Processor Database to your instance of SQL Server 2005 or 2008 Note: using the ESHA Database with your own instance of SQL Server will require the server collation to be 'SQL_Latin1_General_CP1_CI_AS'.To attach The Food Processor Database (eshadata) in SQL Server 2005 or 2008: 1. Copy the eshadata.mdf file from "[CD]:\win32\program files\ESHA Research\data" ... Can I install on 64 bit Windows? If you have the current version of ESHA Software, the SQL Server portion of the installation will automatically detect whether you have 32-bit or 64-bit Windows, and install the proper version of SQL Server. If you have an older version, you will need to install the SQL Server portion manually:S ... Can I update my Food Processor to the latest version of the software? Any existing Windows-based version of Food Processor can be either updated or converted to the current version of Food Processor R&D SQL. Food Processor program program versioning follows a convention of x.y.z. Where x is the Program Version, y is the major version, and z is the patch (or upda ... Can Protein be shown on the Nutrition Facts Panel (label) as %DV? Only the Genesis R&D SQL version does allow for %DV to be displayed on a Nutrition Facts panel. The basic label available in The Food Processor applications, as well as the labeling capabilities of the standard Genesis R&D program do not have the capability to report %DV of protein.Federal regul ... Client Only installation (new installation or update installations) 1. Insert the CD.2. Click Next to the Welcome Screen.3. Choose Client Only install, then Next to continue:4. Click Finish(Note: the initial installation will give way to the Client installation at this point.)5. Click Next to the Welcome screen.6. Accept the License Agreement.7. Enter your user ... Does the upcoming change in Daylight Savings Time affect my ESHA Software? All ESHA software uses the system time for any date/time stamp. In short your ESHA software should be unaffected. Exporting Nutrition Facts or Supplement Facts Label to file crashes the program. Note: The following knowledge base article only applies to The Food Processor SQL v10.4.0 and Genesis R&D SQL v9.3.0.When you export the Nutrition Facts or Supplement Facts labels to file, it may crash the program. If this is happening to you then you need to follow these instructions:1. Downloa ... Gram Weight. Why do I have to have a gram weight for everything? Do I have to have a gram weight for liquid items? In order to combine ingredients and obtain the nutrition analysis of those ingredients, the program must first convert all entered measures into a weight.All ingredients have the nutrition entered by weight. Because the volume to weight ratio is not the same for all foods (1 cup of syrup has a ... Granting Access to Additional Users (or error 80070005) By default, SQL Server grants access only to 'Builtin Administrators'. · For an existing instance of SQL Server (not installed from an ESHA CD), use Enterprise Manager or SQL Server Management Studio (Express) to add the user's Windows Authentication (Active Directory login) to the role ... How can I replace an ingredient with another ingredient in all my recipes? (Search and Replace) There is a function to Search and Replace one ingredient for another. Specifically: Close any open Recipe. Click Database / Search and Replace. In this dialog, search for the specific item you wish to replace in the upper box (Search For). Likewise, search for the specific item you would like ... How do I configure Windows Firewall to allow clients to connect to SQL Server? ESHA software uses SQL Server to host the ESHA Database. When the database resides on a separate machine (often a Server computer), there is need to allow SQL Server as an exception if Windows Firewall is enabled.To allow this exception, get into Windows Firewall (found in the Control Panel). De ... How do I convert from The Food Processor standard to The Food Processor SQL? The Food Processor SQL Edition uses a completely redesigned SQL database, and is not directly compatible with the data files from previous non-SQL versions. However, your data can be converted into the new format with a few steps. The attached .pdf document should guide you through this process. How do I find ingredients which are high (or low) in a certain nutrient (Nutrient Search / F5)? The Nutrient Search lets users search for items that are high or low in a specific nutrient. To use the Nutrient Search: 1. With a Recipe open onscreen, press the F5 button on your keyboard. 2. Click the Select... button to choose which nutrient or nutrients you wish to include in the search (m ... How do I find recipes that use a certain ingredient? (aka Item Search) 1. Click "File > Open > Recipe"2. Press the "More" button3. Type in the name of the ingredient you are searching for and check the box to "Search withing items for matches to the above criteria.". Then press "Search"4. The results will be all recipes that use the ingredient you are looking ... How do I install the program on a network? Please refer to the installation instructions located in our support section:The Food Processor SQLGenesis R&D SQL How to Backup and/or Restore the Database Note: When running Database Utility under Windows 7, Windows Vista, or Windows 2008 Server, you will need to run the application as Administrator. Specifically, right-click the Database Utility shortcut, and choose Run As Administrator.Backing Up: Exit the ESHA software from all computers. On t ... How to Create a UDL File On the client machine, create a new file called "esha.udl" in the "c:\program files\esha research\{program}sql" folder (Make sure that file extensions aren't hidden or else this will look like a text file) Open the "esha.udl" file and go to the "Provider" tab Select "Microsoft OLE Provider for ... (Page 1 of 3)     «« |  Prev | 1 | 2 | 3 | Next | »»

Powered by ActiveKB Knowledgebase Software