Manage Email Signatures Centrally - For All Users

asamuel

Status: 3002: , -2147217900, Invalid length parameter passed to the SUBSTRING function.

Evaluating. Got this using my login.

Using Outlook 2003 with a sql data view as the source.

Previews fine.

Thanks.

A.

Jesper Frier · Posted: Mon Mar 17, 2008 3:53 pm Post subject: CreateAndInsert.sql

Did you run CreateAndInsert.sql found in your install directory without any errors?

This error is related to your SQL settings DB.
Please follow SQL instructions here, or just use the default Access DB for evaluation purpose (works fine up to 500 users).

asamuel · Posted: Fri Apr 11, 2008 7:36 pm Post subject: SQL2005

I forgot to mention that we are using a SQL 2005 DB.

I did use the createandinsert.sql. In any case I redid the DB.

I did follow the sql instructions.

I did a google search and found
http://www.sql-server-helper.com/error-messages/msg-536.aspx
A couple other hits mentioned that this error only started occuring for them in sql2005.

Please take a look and let me know if this makes sense to you.

Would like to finish my testing next week and push for final approval then.

Thanks
Anthony

Jesper Frier · Posted: Sun Apr 13, 2008 11:42 am Post subject: sql statement for SQL 2005

Hi Anthony,

I just finished sql statement for SQL 2005 - Please get it here.

Could you try it an see if that works on your SQL 2005?

The CreateAndInsert.sql is not changed, but it might be worth a try ...
_________________
</Jesper> | Test Email Signature | Showcase |

asamuel · Posted: Tue Apr 15, 2008 11:27 am Post subject: Same error

Ran your updated script and it created a new database.

created a new test signature pulling info from a view in my staff list sql database.

Let me know what other info might help uncover the issue.

Thanks.

Jesper Frier · Posted: Tue Apr 15, 2008 11:55 am Post subject:

Can you preview your signature from Cockpit?

Please post log file: Help -> Diagnostics (right click).
_________________
</Jesper> | Test Email Signature | Showcase |