[CR #456470] If you install ETL Server on a Windows 2003 64-bit Enterprise Edition platform as a Windows service and you plan to use ODBC connectivity, you may encounter the following issues:
The ETL Server 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 32KB). If you installed the IQ Extended Enterprise Edition Sybase IQ server, you can access this version of the ODBC Data Source Administrator by selecting Start | All Programs | Sybase | Data Access (32-bit).
The ETL Server Windows service cannot detect system or user data sources defined using the ODBC Data Source Administrator executable located in the C:\WINDOWS\System32 directory (odbcad32.exe, file size 34KB). This version may be available by selecting Start | All Programs | ODBC.
The ETL Server Windows service may not be able to detect ODBC data sources defined as user data sources.
Workaround: If ETL Development is installed on the same machine with the ETL Server and you want to run the ETL demo jobs:
Stop ETL Server running as a Windows service. Use the Windows Task Manager Processes tab to verify no GridNode.exe processes are running.
Start ETL Development. ETL Development starts a GridNode.exe process and this process can run the ETL demo jobs.
ETL Server is a 32-bit application, even though the Sybase IQ server available with it in the IQ Extended Enterprise edition is a 64-bit application. 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.When you install Sybase IQ on a Windows 2003 EE 64-bit platform and accept the defaults, the two drivers are available from the Start menu. These two ODBC drivers have the same file name—DBODBC9.DLL, but are installed in different directories.
32-bit ODBC driver – installed in C:\Program Files\Sybase\ASIQ-12_7\win32. Select Start | All Programs | Sybase | Data Access (32-bit) | ODBC Data Source Administrator.
64-bit ODBC driver – installed in C:\Program Files\ASIQ-12_7\x64. Select Start | All Programs | Sybase | Data Access (64-bit) | ODBC Data Source Administrator.
