Managing email signatures?
Click download Free Trial
Manage Email Signatures Centrally - For All Users
extend your brand and promote your products, services, special events and news
 
Your eMailSignaturer resource    Receive answers in my inbox    Add URL in your RSS reader    Join us on Facebook     RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
LiveZilla Live Help

Operation must use an updateable query

 
Post new topic   Reply to topic    email signatureManage Email Signatures Centrally - For All Users Forum Index -> English Support
View previous topic :: View next topic  
Author Message
Dave Culley
Certified Professional
Certified Professional


Joined: 02 May 2007
Posts: 78
Location: London

Posted: Fri Aug 17, 2007 9:27 am    Post subject: Operation must use an updateable query Reply with quote

I have a client who is having issues with setup of eMailSignature. He has installed correctly 4.8.7 and put the settings database on a file server with full read/write access. He is getting this log file in debug mode

---------------- eMailSignature LOG file -------------------
- Started at 17/08/2007 10:07:22
- sign.exe version 4.8.7 has been run for this user.
------------------------------------------------------------

Connection string to settings database:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\Lwefs01\eMailSignature\settings.mdb
17/08/2007 10:07:23 Begin finding user DN
User path: LDAP://DC=cerulean,DC=int
User: test (test)
-------------- eMailSignature END LOG file -----------------
- Finalised at 17/08/2007 10:07:24
------------------------------------------------------------
Status: Syntax error in FROM clause.
insert into [lgdaUsers]([init], lastrun) VALUES('TEST', '17/08/2007 10:07:24')
Error writing to Status Monitor: -2147467259 | Operation must use an updateable query.. Internal code: WTB1

It seems like sign.exe is having issues writing back to the database?

Any Ideas?

Thanks
Back to top
View user's profile Send private message Visit poster's website
Jesper Frier
Certified Professional
Certified Professional


Joined: 09 Sep 2006
Posts: 1940
Location: Stoevring, Denmark

Posted: Fri Aug 17, 2007 11:01 am    Post subject: Status: Syntax error in FROM clause Reply with quote

One step at the time ... Laughing
Have no reports on Syntax error in FROM clause.

1) Copy default settings.mdb to the netshare and connect to this database.

If OK, there is a problem with the database.

2) Same problem for all users?

If not, update MDAC.
Back to top
View user's profile Send private message Visit poster's website
Bjarne Mess
Certified Professional
Certified Professional


Joined: 01 May 2007
Posts: 735
Location: Copenhagen

Posted: Sat Aug 18, 2007 12:05 am    Post subject: Reply with quote

Please get the very latest sign.exe from this forum. This has an even better error handling of this error.
_________________
</Bjarne> | Test Email Signature | Showcase |
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    Manage Email Signatures Centrally - For All Users Forum Index -> English Support All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Add URL in your RSS reader | About Us | Terms and conditions | © 2012 eMailSignature North America, Inc. and eMailSignature Aps.