Just moved the database to a new server, via an import/export in Enterprise Manager.
Getting this error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'MEMBER_ID', table <<Omitted>>.PMLC_BOARDS_MEMBERS_PENDING'; column does not allow nulls. INSERT fails.
you will need to redo your import as it has not transferred the datatypes correctly, I am guessing that you imported it from access in order to get those errors.
try a search in the access and sql forums there are some very good guides on how to move from access to sql
Default values are surely missing. As HuwR wrote, we've described the migration process several times. Basically you should create the database structure using setup.asp and then use DTS to migrate the data.
Topic Locked
Posted - 08 July 2004 : 19:50:44
