Are there ODBC drivers available for a Windows XP system, running MSAccess 2007, to connect to a SyBase SQL Anywhere 5.0 database? (files stored on the local PC)?
asked 20 Nov '13, 16:19
The ODBC driver and related software shipped with SQL Anywhere 5 along with database engine, all of which you need to gain access to the database; an ODBC driver is not sufficient. All of this software must accompany the database file in a working installation... do you have any of it at all? (if you are missing one or two files, someone may be able to help)
FYI a working installation of SQL Anywhere versions 6 through 9 can provide immediate access to a SQL Anywhere 5 database. SQL Anywhere versions 10 through 16 can upgrade a SQL Anywhere 5 database file as well, before providing access to the upgraded database. Later versions are available in Developer Edition format; see links on this page.
answered 20 Nov '13, 16:30