databse error testing new 5.7.0.2 beta

Hi,
I suggest you to create a backup of the database, but there is no direct impact. The attachment table is not used for now, it's was created for a future usage.

I will remove the upgrade in the next beta if it's not required.

David Hervieux
Devolutions inc.

Hello,



We have just upgraded to 5.7.0.2 and have had a similar error. It reads "A database upgrade is required. Connect to the data source with a user with administration right to launch the auto upgrade". ALTER TABLE only allows columns to be added that can contain nulls or have DEFAULT definition specified. Column 'AttachmentData' cannot be added to table 'Attachment' because it does not allow nulls and does not specify a DEFAULT definition.




We cannot ignore this error and also we are logging in as a user with the correct level of rights.




You help on this issue will be much appreciated.


Thank you
Navin.
edited by jdwood on 2/8/2010

Hi,
What SQL Server version do you use ? Have you tried the latest version : 5.7.1.0 ?

David Hervieux
Devolutions inc.

It is SQL 2000, Also i made a mistake in typing the version. It is 5.7.2.0 that we have just upgraded to not 5.7.0.2.



Navin.

Hi,
SQL Server 2000 is not supported. I will see what I can do.




David Hervieux

Devolutions inc.

I am sorry, I wasn't aware.



Any help will be much appreciated.




Navin.

No problem, I will try to create a specific update script. The only thing that I'm sure that it will never work, it's the access right, but I imagine that you don't use it since RDM was working before the upgrade. Give me one / two days.

Can you try this special build:



http://remotedesktopmanager.com/download/Devolutions.RemoteDesktopManager.Bin.5.7.2.1.zip




Let me know
edited by dhervieux on 2/10/2010