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.
Search found 1 match
Search found 1 match
• Page 1 of 1
- by wmccann
- Fri 14 Oct 2022 02:28
- Forum: ODBC Drivers
- Topic: Foxpro updates and ODBC
- Replies: 0
- Views: 113208
Search found 1 match
• Page 1 of 1
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