How to configure Sybase IQ

a.       Start installation of “Setup” file iq1540_nc_win32_2

Note: - During installation select License copy as option

b.      Create ODBC DSN connection for Sybase IQ from Control Panel -> All Control Panel Items -> Administrative Tools -> Data Sources(ODBC) -> System DSN -> Click Add Button

                                                               i.      On ODBC tab, specify DataSource name = MyDataSource

                                                             ii.      On Login tab, specify

User=<Any User Name>

                Password=<Any Password>

                Action=Connect to a running database on another computer

                Host=<IP Address>

                Port=<Port number>

                Server=<Server Name>

                Database name=<DB Name>

                                                            iii.      Click on OK , OK

c.       Open Start -> Sybase -> Sybase IQ 15.4 -> Interactive SQL

In ODBC Data Source name, browse ODBC that we have created and click on Connect

d.      You can also access GUI based window of Sybase IQ with same steps from Start -> Sybase -> Sybase IQ 15.4 -> Sybase Central