Hi,
I have a linked Foxpro 2.0 table (part of a commercial payroll program) in my access database using your ODBC connector - everything is great until I go to update a record.
System throws me an error but the odd part is that the error is due a different dbf file (in the same directory). I have not linked to this file. If I remove the file I can update the record as required.
Further investigation lead to the discovery that in the DBF file there is a text field of 255 characters but I believe the actual data in the field is longer than this. I cannot update the field as I get an error.
The exact error when I try to write to any table or open the "bad" table is:
"Field "xxx" of type 'C' has a wrong size 255 (c:...... path and name of table) (#239279088)"
If I change the offending table's suffix to .dbfx I can write to any of the other tables!
Any thoughts on how to resolve/why the odbc driver is accessing tables that are not linked to the access database?
Thanks,
W.
Foxpro updates and ODBC
Discussion of open issues, suggestions and bugs regarding usage of ODBC Drivers
Jump to
- General Forums
- ↳ Announcements
- Database Tools
- ↳ dbForge for MySQL
- ↳ dbForge for Oracle
- ↳ dbForge for PostgreSQL
- ↳ dbForge for SQL Server
- ADO.NET Data Providers
- ↳ Entity Framework support
- ↳ LinqConnect (LINQ to SQL support)
- ↳ dotConnect for Oracle
- ↳ dotConnect for MySQL
- ↳ dotConnect for PostgreSQL
- ↳ dotConnect for SQLite
- ↳ dotConnect for DB2
- ↳ dotConnect for SQL Server
- ↳ dotConnect for Cloud Applications
- ↳ dotConnect Universal
- ↳ Entity Developer
- Delphi Data Access Components
- ↳ EntityDAC
- ↳ Universal Data Access Components
- ↳ Oracle Data Access Components
- ↳ SQL Server Data Access Components
- ↳ MySQL Data Access Components
- ↳ InterBase Data Access Components
- ↳ PostgreSQL Data Access Components
- ↳ SQLite Data Access Components
- ↳ VirtualDAC
- dbExpress Drivers
- ↳ dbExpress driver for Oracle
- ↳ dbExpress driver for SQL Server
- ↳ dbExpress driver for MySQL
- ↳ dbExpress driver for InterBase & Firebird
- ↳ dbExpress driver for PostgreSQL
- ↳ dbExpress driver for SQLite
- ODBC Drivers
- ↳ ODBC Drivers
- Network Security
- ↳ SecureBridge
- Developer Tools
- ↳ Code Compare
- ↳ Review Assistant
- ↳ LINQ Insight
- ↳ SSIS Data Flow Components
- ↳ Excel Add-ins