Windows Vista support issues

For Sybase IQ 12.7 ESD #3 and later releases, the IQ Network Client is certified on the Windows Vista operating system. Following are some issues relating to running Sybase IQ software on Vista:

• Windows Vista security

  Windows Vista incorporates a new security model. User Account Control (UAC) is enabled by default and may affect the behavior of programs that expect to be able to write files, especially when the computer supports more than one user. Depending on where and how files and directories are created, a file created by one user may have permissions that do not allow another user to read or write to that file. If you install Sybase IQ in the default directories, files and directories that require read/write access for multiple users are set up appropriately.

• Sybase IQ elevated operations agent

  In Vista, certain actions require privilege elevation to execute when run under User Account Control. The programs dbelevate9.exe and iqdsn.exe may require elevation in Sybase IQ.The following dll files require elevation when they are registered or unregistered: dbodbc9.dll and dboledb9.dll.

  On a Vista system with User Account Control activated, you may receive an elevation prompt for the Sybase IQ elevated operations agent. The prompt is issued by the Vista User Account Control system to confirm that you want to continue running the identified program (if logged on as an administrator) or to provide administrator credentials (if logged on as a non-administrator).

• Deployment changes

  The program dbelevate9.exe is used internally by Sybase IQ components to perform operations that require elevated privileges. This executable must be included in deployments of Sybase IQ. Administrator privileges are required to run dbelevate.

• Sybase IQ executables signed

  Sybase IQ executables on Vista are signed by Sybase, Inc.

• Using an AWE cache

  To use an AWE (Address Windowing Extensions) cache on Windows Vista, you must run the database server as administrator. Starting a non-elevated database server with an AWE cache results in a warning that the database server must be run as an administrator to use AWE. See “-cw server option” in Chapter 1, “Running the Database Server,” in the Sybase IQ Utility Guide.

• Samples

  Samples now correctly handle Sybase IQ installation path names that contain one or more spaces.

• Windows services

  Vista-compliant services are not allowed to interact with the desktop. On Windows Vista, no Sybase IQ services interact with the desktop (even if Allow Interaction with Desktop is enabled in the service definition). Sybase IQ database servers can be monitored using the dbconsole utility or from Sybase Central. Sybase Central disables the option to allow service to interact with desktop when running on Windows Vista.