Question and Answer Database
FAQ: FAQ4694D - "invalid field type" database error with MSSQL server 7
Category: Database (MSSQL)
Platform: All-32Bit
Product: All32Bit,
Question:
When I try to activate my Table/Query I get an error stating
"invalid field type", what does this mean?
Answer:
Microsoft no longer supports DB-LIB with the release of MS SQL Server 7 which means that
DB-LIB doesn't have support for the 4 new data types that SQL 7 offers - namely NTEXT,
NCHAR, NVARCHAR and GUID. In order to successfully use new types offered by SQL Server 7
and above you'll need to use CT-LIB. This should eliminate the error message.
6/22/99 2:35:14 PM
Last Modified: 01-SEP-99