giardina Moderatore |
| Località: Putignano | Nazione: Italy | Web: http://www.media.it |
|
|
RE: Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
Original Message
| After the last 3 upgrades the message started to come:
| Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
|
| [Microsoft][ODBC SQL Server Driver][SQL Server]ALTER TABLE only allows
| columns to be added that can contain nulls or have a DEFAULT definition
| specified. Column 'Data' cannot be added to table 'OfficeRichiesta' because
| it does not allow nulls and does not specify a DEFAULT definition
|
|Reply Message
In Table "OfficeRichiesta" of your database the field "Data" not is present. It not is common situation. In new release 2.58 we have change polulate procedure for re-create destroied field, but if you want can be solve the problem also now:
1) Do in Administrative area.
2) In "Tools" execute Copy of your principal database in database access backup.mdb. (It is empty database)
3) When the procedure done you find all your portal data in new database backup.mdb with correct structure.
4) In Tools select "Change Database" and select backup.mdb as principal database.
5) Now STOP IIS Admin Service or Restart Server. When the portal start no error are displayed.
If you want now you can delete all table in database.mdb, repair and compact database and do same process from backup.mdb to database.mdb for move data in original path.
Good Work.
Giuseppe Giardina
Support and Development
Store Portal Stuff.
|