2144601 - How to connect to ASA 7 via 64 bit ODBC Drivers | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2144601 - How to connect to ASA 7 via 64 bit ODBC Drivers

Symptom

  • Would like to connect to Adaptive Server Anywhere (ASA) 7 database in a 64bit software using DSN
  • Cannot find the 64bit ODBC driver for ASA 7
  • Using SQL Anywhere version 10 + 's 64bit ODBC Driver gives Error Message:
 "Invalid option 'ansi_substring' -- no PUBLIC setting exists'"

                   screenshots 1.JPG


Read more...

Environment

  • Adaptive Server Anywhere 7
  • Sybase SQL Anywhere 10
  • Windows 2008 R2 64 bit
  • SAP Data services 4.2 64 bit

Product

Sybase SQL Anywhere 10.0

Keywords

Sybase, ASA, ODBC, compatible, regsvr32, import, DSN , KBA , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , How To

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.