Why do I get the error "Driver"s SQLAllocHandle on SQL_HANDLE_ENV failed" when starting the StarTeam Server?

0 Likes

Problem:

Why do I get the error "Driver"s SQLAllocHandle on SQL_HANDLE_ENV failed" when starting the StarTeam Server?

Resolution:


  • Product Name: StarTeam
  • Product Version: 2005 R2
  • Product Component: Oracle database
  • Platform/OS Version: Windows


This can occur if you have an invalid or incorrect PATH variable. To check your PATH variable:

  1. Right-click My Computer
  2. Choose PROPERTIES | ADVANCED | ENVIRONMENT VARIABLES
  3. Locate the PATH variable and copy it"s contents to a text editor such as notepad

Once you have done this you should now look for the following:

  1. A missing semicolon between the different application paths. Each application path in the list should be separated by a semicolon.
  2. Look for spaces between the semicolon and the next application path. Remove any spaces.
  3. If you have more than one Oracle installation, make sure the latest version appears in the PATH before any older versions. If you have uninstalled older versions and references still exist in the PATH then remove them.

If the PATH appears fine then the issue may be rights related.

  1. Opened up Windows Explorer
  2. Navigated to Oracle | ora92
  3. Right clicked and selected properties
  4. Clicked on Securities tab
  5. Clicked on Authenticated Users
  6. Unchecked Read and Execute | Click Apply
  7. Rechecked Read and Execute | Click Apply
  8. Clicked ok to close window
  9. Restart server


Old KB# 27587
Comment List
Related
Recommended