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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.