SAP Knowledge Base Article - Preview

2701925 - Database server not found

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

SAP SQL Anywhere 17.0

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.