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

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

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