Q
Problem solve Get help with specific problems with your technologies, process and projects.

Two stored procedure events not working with DECS and SQL Server backend

I am an Access/SQL developer, new to the Domino/Notes field. When I set up DECS with SQL Server 2000 as backend -- fields in Notes linked to external fields -- there are no problems.

If I try with a simple form, for the four events (create, open, update, delete) using stored procedures, two of them are OK (delete, open), but the other two receive an error message, "Server error: Realtime service error inserting external record."

I ran SPROC from query analyzer with default data. It ran OK and assigned the correct permissions to the user. Is there a way I can troubleshoot this problem?

 CREATE Procedure sprocSQLEmployee _Settings_CREATE ( @PK varchar(50), @Description text, @Setting varchar(100), @Values text) with recompile As set nocount on declare @err int set @err = 0 begin tran INSERT INTO Settings (PK, Description , Setting, [Values] ) VALUES (@PK, @Description , @Setting , @Values) set @err=@@error if @err=0 commit tran else rollback tran return GO

LEI and DECS both struggle with stored procedures. That being said, it looks to me like the SPROC is performing a rather simple insert to Settings table/view, so take the SP out of the picture. I suggest you try a "create" and or "update" going directly at the table/view.

Do you have comments on this Ask the Expert question and response? Let us know.

Dig Deeper on Lotus Notes Domino Application Development

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchWindowsServer

Search400

  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...

SearchDataCenter

SearchContentManagement

Close