Geeks With Blogs
Baskar B.V SQL - BI Consultant

 

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.

Posted on Friday, January 18, 2008 8:32 PM | Back to top


Comments on this post: Connecting to Sybase Server

# re: Connecting to Sybase Server
Requesting Gravatar...
hey, it works! thanks..
Left by jam on Aug 14, 2009 1:38 AM

# re: Connecting to Sybase Server
Requesting Gravatar...
What is the ICCM_Server?
Left by Erin on Feb 16, 2010 1:19 PM

# re: Connecting to Sybase Server
Requesting Gravatar...
Dude,

Thanks for the post. I found another way. It might be more easy.

Click on Start > Run > Type "dsEdit" > Click OK
Add the server information. This will update the Sybase sql.ini file. The server name in dsEdit must match whatever server name that was set in Control Panel > Data Sources (ODBC).
Left by Amin on May 05, 2011 9:17 AM

# re: Connecting to Sybase Server
Requesting Gravatar...
Thank you Baskar, This really helped me resolve my issue.
Left by Manasa on Nov 23, 2011 11:25 PM

# re: Connecting to Sybase Server
Requesting Gravatar...
Good one, this is a typical issue with the sybase and time consuming to find out the exact cause. Anyway, nice to see this post as it saves time for many. Cheers mate.
Left by Rajesh on Dec 08, 2011 3:36 AM

# re: Connecting to Sybase Server
Requesting Gravatar...
Thanks A lot
Left by Saad on Feb 11, 2012 11:28 PM

# re: Connecting to Sybase Server
Requesting Gravatar...
Hi,
I am having issue when connecting to a Sybase server through ASE ODBC Driver 12.0,

i am getting below error:

"[SYBASE][ODBC Sybase driver][Sybase]ct_connect(): user api layer: internal Client Library error: Read from the server has timed out.[SYBASE][ODBC Sybase driver][Sybase]ct_connect(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect"

We have three ODBC Connections , Two are running fine one is not working since last 2 weeks.

We have Windows Server 2008. However the same ODBC Connection is working fine fron other server.

i can ping sybase server successfully through DSEDIT.

Please help me out .

Thanks,
Saurabh
Left by Saurabh on Oct 24, 2013 9:33 AM

Your comment:
 (will show your gravatar)


Copyright © Baskar B.V | Powered by: GeeksWithBlogs.net