Error Converting From 3.70 To 5.0

elysaval

I try to open a 3.70 database with client 5.0 and choose to convert database but i get the following error : "2705,42S21 ,[Microsoft],[ODBC SQL Server],[Sql Server],Table Column Name must be unique. Column Name 'securityoption' of table 'dbo.$ndo$dbproperty' is specified more then once. SQL : ALTER TABLE [dbo].[$ndo$dbproperty] ADD securityoption INTEGER NOT NULL DEFAULT 0

Thanks. Elisa.

Arhontis

Hello Elisa, and welcome to mibuso,

have you tried opening your 3.70 database with a version 4 client and convert it and then convert your database to 5.0?

(3.70 -> 4.0 (maybe sp3) -> 5.0)

kriki

This error you get when you opened the database before to convert and it gave an error. The next time you get this error.
Easiest way to remove this error : go with SQL into the table (Design the table!) and remove the that field, save the table and retry the conversion.

elysaval

THANK YOU VERY MUCH, I DELETED THE FIELD IN SQL SERVER AND THE CONVERSION NOW WORKS FINE !

BYE!