Search the Knowledgebase Browse by Category
Genesis R&D SQL rss button
Knowledge regarding the SQL version of Genesis R&D
(Page 1 of 3)     «« |  Prev | 1 | 2 | 3 | Next | »»
There were 52 questions found in this category:
  1. questionAn 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 ...

  2. questionAttaching 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 ...

  3. questionAttaching the Genesis R&D 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 Genesis R&D Database (gendata) in SQL Server 2000: Copy the gendata.mdf file from "[CD]:\win32\program files\ESHA Research\data" into a drive t ...

  4. questionAttaching the Genesis R&D SQL 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 Genesis R&D SQL Database (gendata) in SQL Server 2005 or 2008:1. Copy the gendata.mdf file from "[CD]:\win32\program files\ESHA Research\data" i ...

  5. questionCan 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 ...

  6. questionCan I update my Genesis to the latest version of the software?
    Any existing Windows-based version of Genesis can be either updated or converted to the current version of Genesis R&D SQL. Genesis 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 update). To update from pro ...

  7. questionCan 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 ...

  8. questionClient 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 ...

  9. questionDoes 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.

  10. questionExporting 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 ...

  11. questionGram 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 ...

  12. questionGranting 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 ...

  13. questionHow 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 ...

  14. questionHow do I calculate the 'score' required for Protein %DV shown on a Nutrition Facts label?
    Genesis Nutrition Facts Labeling %DV for Protein In order to list % DV for protein on the Nutrition Facts label, you will need to enter either a PER or PDCAAS value. PER (protein efficiency ratio) PER is a method used for determining the quality of protein in food. It is used to determine the p ...

  15. questionHow 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 ...

  16. questionHow do I convert from Genesis standard to Genesis SQL?
    The Genesis R&D 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.

  17. questionHow do I export a Nutrition Facts Panel (label) to Word (Genesis R&D SQL)?
    Note: This is for the SQL version of Genesis R&D. If you wish to export the label to Word using the standard (non-SQL) version of Genesis R&D, refer to this document. From within Genesis R&D SQL, view the label. With the label on screen, right-click on the Label. From the menu that appears, cho ...

  18. questionHow 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 ...

  19. questionHow 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 ...

  20. questionHow 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

(Page 1 of 3)     «« |  Prev | 1 | 2 | 3 | Next | »»

Powered by ActiveKB Knowledgebase Software