Configuring sybase odbc driver

The Sybase ODBC drivers provided by Informatica are for Sybase ASE. To connect to Sybase IQ, get the drivers from the vendor (Sybase) and install them. After the installation, do the following to configure the ODBC connectivity: Assume: Sybase IQ drivers are installed in the directory /usr/sybase/IQ_4/. For more information about ODBC, see your Windows operating system documentation. Click on the System DSN tab to display the System Data Sources dialog box. The dialog box appears with a list of sources you might have already defined. Click Add to add a new Data Source. The Create New Data Source dialog box appears. Select Adaptive Server ODBC Driver as the driver you .  · The Sybase ODBC driver is a database connectivity driver that is part of the Microsoft Windows server platform. If your application utilizes the Sybase ODBC connection to interact with the database, then the Sybase driver has .

The Sybase ODBC drivers provided by Informatica are for Sybase ASE. To connect to Sybase IQ, get the drivers from the vendor (Sybase) and install them. After the installation, do the following to configure the ODBC connectivity: Assume: Sybase IQ drivers are installed in the directory /usr/sybase/IQ_4/. For more information about ODBC, see your Windows operating system documentation. Click on the System DSN tab to display the System Data Sources dialog box. The dialog box appears with a list of sources you might have already defined. Click Add to add a new Data Source. The Create New Data Source dialog box appears. Select Adaptive Server ODBC Driver as the driver you want to use for Adaptive Server, and click Finish. The ODBC Adaptive Server Setup dialog box appears. From Start | All Programs | Sybase | Data Access (bit) | ODBC Data Source Administrator; Create a shortcut on desktop, entering odbcadexe When you start the ODBC Administrator, you see something like this: Proceed to configure data source. Click Add button and select “Adaptive Server Enterprise”.

The Sybase ODBC Driver is a powerful tool that allows you to connect with Sybase, directly from any applications that support ODBC connectivity. Configuring the ODBC driver · Start the ODBC Data Source Administrator (odbcadexe) from the Windows System program group. · Click on the System DSN tab to. To configure the ODBC connection to a Sybase Database, select the “SQL Anywhere 16” ODBC driver.