SAP Knowledge Base Article - Preview

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


  • 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



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


Sybase SQL Anywhere 10.0


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.