I am trying to connect MS Access 97 to SQLAnywhere 6.0. Test connection returns no errors and I can open tables with no records. But if I open a table with records I receive an ODBC call failed message. Next the table opens with the #Name? in each row/column cell.
Information on the driver and configuration settings follow. Please let me know if I can provide more information.
DB use: multiuser
The driver is Adaptive Server Anywhere 6.0 Version 6.00.022188 dbodbc6.dll 4/8/99.
driver configured as System Data Source on PC (Windows 95 OS)
ODBC tab settings:
No isolation level selected
Microsoft applications (Keys in SQL Statistics) not checked
Delphi applications not checked
Prevent driver not capable errors not checked
Delay autocommit until statement closed not checked
Describe cursor behavior: if required checked
Supply user id and password checked (logging in as guest role)
Automatically start database if not running checked
Automatically shut down database after last connect checked
Liveness timeout 120 seconds
Buffer size 700 bytes
Buffer space 20 KB
Allow multiple record fetching checked
Primary key of attached table:
Long integer unique index
Thanks in advance for your time and help.