Kbase P107770: WebSpeed agents connecting schema holder and OpenEdge MS SQL DataServer
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/18/2005 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
WebSpeed 3.x
SYMPTOM(s):
WebSpeed agents connecting schema holder and OpenEdge MS SQL DataServer
Using NEXT-VALUE statement with sequence defined in the MS SQL Server database
Compiling WebSpeed application fails with error 3142
You do not have sufficient permission to increment sequence values. (3142)
CAUSE:
Missing -U and -P parameters for user connecting the MS SQL Server database
FIX:
Add -U and -P parameter for the user and password with adequate permissions to update the sequence.