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
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple. The final solution for this task involved creating a custom text parser and then reading…
Aerodynamic noise is the cause of the majority of the noise produced by helicopters. The inordinate amount of noise helicopters produce is a major problem in the both a military and civilian setting. To remedy this problem the use of an aerogel coat…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…