Surendra Sharma

Surendra Sharma

Search This Blog

Wednesday, June 12, 2013

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

No comments:

Post a Comment