Symptom
The server is running perfectly fine but clients connect returns the following error:
Connection failed.
[Sybase][ODBC Driver][SQL Anywhere]Database server not found
If you have a LogFile parameter enabled in connection string (-c "uid=dba;pwd=sql;server=demo;LogFile=c:\log\client.log"), you will see the following in the log file:
Tue Mar 24 2015 15:08:35
15:08:35 Attempting to connect using:
UID=dba;PWD=sql;ServerName=demo;CON=some_connection_name;LOG=c:\log\client.log;ASTART=NO;Host=***
15:08:35 Attempting to connect to a running server...
15:08:35 Attempting TCPIP connection (no sasrv.ini cached address)
15:08:35 Looking for server with name somename
15:08:35 Trying to find server at address ***.***.***.155:2638
15:08:40 TCP/IP link, function connect(), error code 10060
15:08:40 A HOST value was specified, skipping LDAP check
15:08:40 Sending broadcast to find server
15:08:40 Using broadcast address of: ***.***.***.155:2638
15:08:41 Resending
15:08:42 Resending
15:08:43 Resending
15:08:44 Resending
15:08:45 Server not found (no reply received)
15:08:45 Failed to connect over TCPIP
15:08:45 Removing failed address from sasrv.ini cache
15:08:45 Not attempting to autostart server
15:08:45 Cannot connect to server
Read more...
Environment
- Any supported SAP SQL Anywhere
- Any supported Sybase SQL Anywhere
- Any supported OS
Product
Keywords
anyhwere, port, default, open, firewall, policy, TCP, block, dbping, telnet, ServerPort , KBA , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.