Symptom
- ODBC data source connecting to a Microsoft SQL Server database is created and confirmed working successfully with connection tests.
- Remote Server for SQL Server database is created in Sybase Central
- Connection tests for remote server fails with the following error message [SAP][ODBC Driver][SQL Anywhere] Unable to connect to server 'RemoteSQLServer': [DataDirect][ODBC lib] Data Source not found and no default driver specified.
Read more...
Environment
- SQL Anywhere version 17.0
- Linux
- Microsoft SQL Server (as remote server)
Product
SAP SQL Anywhere 17.0
Keywords
CIS, Remote Server, ODBC, odbc.ini, ODBCINI, ODBC_INI, ODBCHOME, SQL Anywhere, Linux, Unix , 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.
SAP Knowledge Base Article - Preview