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 for Me (Login required).

Search for additional results

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