09-12-2011 06:33 AM
Jguykema,
On a side note - what browser (and version/build of it) are you using?
So we can test and try to determine why there is no attachment option presented.
09-15-2011 01:49 PM
I have the same issue and cannot seem to get past it. Here is the error log:
Changed database context to 'ScottsdaleArtAuction'.
*********** Schema Update failed **************
*********** Exception message follows *********
System.Data.SqlClient.SqlException: Incorrect syntax near '100'.
Setting Database Compatibility Level...
at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
Schema Update failed.
09-16-2011 07:45 AM
Can you provide us what is version of database from previous version ?
Also can you try to upgrade database from previous version like demo to ACT 2012 and see if we getting same results ?
Thanks,
Tushar Vyas
ACT! Database Services
09-16-2011 08:02 AM
That doesn't look like the entire log file.
09-16-2011 04:55 PM
same problem here
from Act 2009 database
Win 7, 64bit OS
error:
Changed database context to xxxxxx'.
*********** Schema Update failed **************
*********** Exception message follows *********
System.Data.SqlClient.SqlException: Incorrect syntax near '100'.
Setting Database Compatibility Level...
at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
Schema Update failed.
09-16-2011 10:42 PM
It is the entire log file and i am upgrading from 2009. I tried on the Demo and got the same result, same log file.
09-20-2011 04:00 PM
Issue: Changed database context to 'XXXX'.
*********** Schema Update failed **************
*********** Exception message follows *********
System.Data.SqlClient.SqlException: Incorrect syntax near '100'.
Setting Database Compatibility Level...
at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
I had the same error, found SQL 2005 was shown in the actdiag for 2012, I did see in the configuration manager had the act7 instance running as well as the browser. in the end I had to pull 2005 and 2008, reinstall 2008 then reattach back to ACT using SecurityCmdLnApp.exe.
10-03-2011 02:47 PM
I'm also having this problem, below is my error message. Would be great to fix, otherwise I cannot access my database.
Changed database context to 'Main'.
*********** Schema Update failed **************
*********** Exception message follows *********
System.Data.SqlClient.SqlException: Incorrect syntax near '100'.
Setting Database Compatibility Level...
at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
Schema Update failed.
10-03-2011 04:14 PM
Hi Stanley
Are you able to advise your steps for the process you did to fix your problem??
Thanks heaps
Chris
10-03-2011 04:55 PM
I determined that the same thing was wrong with mine. Win 7 Home premium had set up my adminstrator user as multiple and Act installation only allows one primary administrator to change setting in Act7.I needed to make a new user as Administrator, remove net 2005 and net2008, re install 2008 and attach to act database. It was frustrating enough to have to call support and let a nice chap from South India do a remote go at it as I ate lunch and watched cursor pong.