Incorrect Syntax near COLLATE error when performing an Installation or Upgrade of DNA 2
This document ("448") is provided subject to the disclaimer at the end of this document

This Document is available in the following languages  


Forward this document to a colleague

Provide feedback


Summary

When performing an Installation or Upgrade of NetSupport DNA, you may receive the error Incorrect Syntax near 'COLLATE' after rebooting the DNA Server.  The error will only occur when using either SQL Server 7 or MSDE1 Databases.

Details

There has been fix released in order to resolve this issue. To install this fix please perform the following:

1) Download the DBUpdate.Zip file at the bottom of this Knowledgebase Article,

2) Stop the "NetSupport DNA Server" service, by performing the following you can stop the NetSupport DNA Server service:

3) Extract the DBUpdate.Dll file into {Installation Directory}\DNA\Server (I.e. C:\Program Files\NetSupport DNA\DNA\Server),

4) Start the "NetSupport DNA Server" service, by performing the following you can start the NetSupport DNA Server service:

Once you have restarted the NetSupport DNA Server service, DNA 2 will automatically complete the installation or upgrade and will start to collect data from any connected client machines.

If you require any further assistance please contact NetSupport Technical Support support@netsupportsoftware.com
Applicable Product(s) : DNA 2.00 ,
Applicable Operating System(s) :, Windows 2000, Windows 2003, Windows NT 4.0, Windows XP
Associated Files : DBUpdate.zip (138626kb)
Date Created : 21-9-2004 00:00:00
Date Modified : 21-9-2004 10:21:12
Revision Number : 2
DISCLAIMER: The origin of this document may be internal or external to NetSupport Ltd. NetSupport Ltd makes all reasonable efforts to verify this information. However, the information provided in this document is for your information only. NetSupport Ltd makes no explicit or implied claims to the validity of this information.

Any trademarks referenced in this document are the property of their respective owners.