SQL error when I try the archive server function

SQL error when I try the archive server function

Hi,
Now I am trying the archive server function, but I met a SQL error when I try to make a 'Picture Switch' function which is to load the Control picture..
Precisely, I followed the "Archive_Server.pdf" in the "Tutorials" documents. I have created a basic archive, and a picture Archive Revision (with defaut control elements).
And then, I try to make a 'Picture Switch' function to load the picture Archive Revision. But when I click the button 'OK', there is a message in my "Output Window" view :
Error ExecuteCommand :'Recordset could not be opened Errorcode:112' FillDataReader Error!
Error ExecuteCommand SQL:'INSERT INTO [Function] ([SC_State],[SC_IDClient],[SC_CTime],[SC_MTime],[Object],[Name],[Type],[ModifiedCnt]) VALUES (?,?,?,?,?,?,?,?);
SELECT @@IDENTITY AS 'ID';'!
Error ExecuteScalar from Project:61BR! Error:Failed to insert record Errorcode:110 !

And after that, although this picture switch function is created, but I can not use it at all.. How can I resolve this problem ? :confused:

This is a migrated post! Originally posted on 23.04.2009 by user lephis. Please be aware that information can be outdated.