Hi All,
I have just reinstalled server & studio 4.51 and Spectra 1.01 successfully
on my machine after a decision with our dev team to have them installed on
the d: partition (although it has been working fine on my c: for the last
few months).
I now have a problem when trying to upgrade the cfaObject database to SQL
Server 7.
I set up a new db in SQL 7 and call it cfaObjects. I then create an ODBC
dsn called cfaObjectsNew. Then, I log into the Webtop and select to migrate
dbs and from is 'cfaObjects' and to is 'cfaObjectsNew'.
I get the following error:
ODBC Error Code = 23000 (Integrity constraint violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY
constraint 'pk_propertydefinitions'. Cannot insert duplicate key in object
'propertydefinitions'.
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (3:1) to (3:67).
HELP!!!!
PS I've tried uninstalling and physically deleting the .db and .mdb dbs in
prog files/allaie/spectra/databases before reinstalling, stopping all
services including SQL Server, to no avail
****************************
Emma Newby
Internet Server Developer
circle.com
****************************
e - [EMAIL PROTECTED]
t - 0117 914 6217
w - http://www.circle.com
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
