Symptom
The .NET client application does not connect to the remote database server because of the following error:
System.Data.EntityException: The underlying provider failed on Open. ---> Sap.Data.SQLAnywhere.SAException: Database server not found
at Sap.Data.SQLAnywhere.SAConnection.Open()
at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure)
--- End of inner exception stack trace ---
The client log file (Log.txt) shows:
11:18:31 Attempting to connect using:
UID=dba;PWD=********;ServerName=MyServerName;DataSourceName=MyDS;INT=NO;LOG=D:\temp\Log.txt;PROWS=200;RetryConnTO=5;CPOOL=NO;Host=xxx.xx.xxx.xxx:1234
11:18:31 Attempting to connect to a running server...
11:18:31 Attempting TCPIP connection (address xxx.xx.xxx.xxx:1234 found in sasrv.ini cache)
11:18:31 Looking for server with name MyServerName
11:18:31 Trying to find server at cached address xxx.xx.xxx.xxx:1234 without broadcasting
11:18:31 TCP/IP link, function connect(), error code 10048
11:18:31 Trying to find server at address xxx.xx.xxx.xxx:1234
11:18:31 TCP/IP link, function connect(), error code 10048
11:18:31 A HOST value was specified, skipping LDAP check
11:18:31 Failed to connect over TCPIP
11:18:31 Removing failed address from sasrv.ini cache
11:18:31 Retrying connection
...........
11:18:36 Attempting TCPIP connection (no sasrv.ini cached address)
11:18:36 Looking for server with name MyServerName
11:18:36 Trying to find server at address xxx.xx.xxx.xxx:1234
11:18:36 TCP/IP link, function connect(), error code 10048
11:18:36 A HOST value was specified, skipping LDAP check
11:18:36 Failed to connect over TCPIP
11:18:36 Removing failed address from sasrv.ini cache
11:18:36 Not attempting to autostart server
11:18:36 Cannot connect to server
Read more...
Environment
SAP SQL Anywhere 17.0.0.1358
Microsoft Windows
Product
Keywords
Winsock , KBA , BC-SYB-SQA-CLI , SQL Anywhere - Client libraries (odbc, jdbc ...) , 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.
SAP Knowledge Base Article - Preview