Connecting to Sybase Server
来源:互联网 发布:淘宝换手机屏幕可靠么 编辑:程序博客网 时间:2024/04/26 21:44
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 are connecting to.[SERVER1] is the connection name which has to be given in place of "server name" while created the odbc connection. The one highlighed in bold is very important step. <<SERVER1 IP>> is the ip address of the sybase server. Save the sql.ini file. The location of the file should be mentioned in place of "Interfaces file" property under the Connection tab in odbc setting.
If you have not done the above steps you would basically get the error message
---------------------------
Warning
---------------------------
[SYBASE][ODBC Sybase driver][Sybase]ct_connect(): user api layer: internal Client Library error: HAFAILOVER:Trying to connect to server.
---------------------------
OK
---------------------------
That's it. Now try the test connect while creating the odbc driver and it should work fine.
Hope this post helps. I would like to receive your valuable comments about this post.
- Connecting to Sybase Server
- Connecting to my online server
- Error connecting to MySQL server
- ADO.NET 之Connecting to SQL Server
- Error when connecting to Windows Server 2003 using Remote Desktop
- Problem in connecting VS 2005 to SQL Server 2008
- Connecting to LDAP server using JNDI in Java
- mongodb Failed: error connecting to db server: no reachable servers
- Hadoop 错误 Problem connecting to server: localhost/127.0.0.1:9000
- PHP - Connecting to MySQL
- Connecting JIRA to MySQL
- Connecting to the Network
- Connecting to a eXtremeDB
- Connecting to the Network
- Connecting to the Network
- Connecting to the Network
- Connecting to CentOS 7
- Connecting to the Network
- RTP协议分析
- SQLite 增删改查学习教程
- Audio bit rate
- 黑产科普—最近大规模的QQ空间钓鱼攻击
- S5PC100看门狗定时器
- Connecting to Sybase Server
- hibernate一对一映射
- SSP Timer Job Distribution List Import Job was not run
- Bubble(1)
- EBP
- Sublime Text 2 tips for Python and web developers
- hbase中filter查询例子
- 内容共享 之 发送内容到其他的APP
- 智能算法浅介----模拟退火,遗传算法,禁忌搜索,神经网络等