I was struggling for a while for trying to connect to sybase server in DTS package. I was using Sybase ASE odbc driver to connect to the server. After a long fight i found the setting for the server which i am trying to connect is missing in the sql.ini file. I would like to share my learning with this post. Things to note in sql.ini. You could find the file in the folder where symposium call center is installed. The above set of information should be created in sql.ini for each sybase server we...

Tip: To work with sql-server 2005 databases and to execute queries it is not mandatory to install sql-server client on the machine. We can use sql-server 2000 query analyzer to connect to sql 2005 databases and to execute queries