ODBC connectivity for IQ ETL Server running as a Windows Service [CR 456470]

If you install the IQ ETL Server on a 64-bit Windows 2003 Enterprise Edition platform as a Windows service and you plan to use ODBC connectivity, you may encounter the following issues.The IQ ETL Server (Grid Engine) Windows service may only be able to detect system data sources defined using the ODBC Data Source Administrator executable located in the C:\WINDOWS\SysWOW64 directory (odbcad32.exe, file size 32 KB). If you installed the IQ Extended Enterprise Edition Sybase IQ Server, you can access this version of the ODBC Data Source Administrator under the Start > All Programs > Sybase > Data Access (32-bit) menu. Note that the IQ ETL Server Windows service is unable to detect system or user data sources defined using the ODBC Administrator executable located in the C:\WINDOWS\System32\directory (odbcad32.exe, file size 34 KB). This version may be available under the Start > All Programs > ODBC menu.

The IQ ETL Server (Grid Engine) Windows service may not be able to detect ODBC data sources defined as user data sources. If the IQ ETL Development client is installed on the same machine with the IQ ETL Server and you want to run the ETL Demo jobs, stop the IQ ETL Server running as a Windows service. (Use the Windows Task Manager Processes tab to be sure no GridNode.exe processes are running.) Then launch the IQ ETL Development client. The IQ ETL Development client will start a GridNode.exe process and this process will be able to run the ETL demo jobs.The IQ ETL Server is a 32-bit application, even thought the Sybase IQ Server available with it in the IQ Extended Enterprise Edition release is a 64-bit application. The IQ ETL Server requires a 32-bit ODBC driver to connect to a server, regardless of whether the server is 32-bit or 64-bit. The 64-bit Sybase IQ Server includes both ODBC 32-bit and 64-bit drivers. These two ODBC drivers have the same file name (DBODBC9.DLL) but are installed in different directories. The 32-bit ODBC driver is installed in C:\Program Files\Sybase\ASIQ-12_7\win32 directory. The 64-bit driver is installed in the C:\Program Files\ASIQ-12_7\x64 directory. When you install Sybase IQ on a Windows 2003 EE 64-bit platform and accept the defaults, the different drivers are available from the Start menu. The 32-bit Sybase IQ ODBC driver is available under Start > All Programs > Sybase > Data Access (32-bit) > ODBC Data Source Administrator. The 64-bit Sybase IQ ODBC driver is available under Start > All Programs > Sybase > Data Access (64-bit) > ODBC Data Source Administrator.