Comments by Ozzie Mozzie

Ozzie Mozzie 8-Dec-22 17:01pm View

Thank you. I appreciate your advice and have updated the procedure.
The previous procedure worked ok but as you have pointed out it was leaky. :)

Ozzie Mozzie 13-Mar-15 19:42pm View

I fixed the typo but it still fails to create the row.

Ozzie Mozzie 13-Mar-15 14:07pm View

Thanks for picking the typo up that may well be the problem. I fix that and try it as soon as I get the opportunity.
Thanks again.
I will post the result here :)

Ozzie Mozzie 13-Mar-15 6:34am View

This works when I use SQL Server script but application code still does not work:
USE [PlatinumDB]
GO

INSERT INTO [dbo].[Errors]
(
eName
,eInstance
,eMessage
,eModule
,eProcedure
,eUserId
,eUserMessage
,ecName
,ecCode
,ecDescription
,ecMessage)
VALUES
(N'eName'
,N'eInstance'
,N'eMessage'
,N'eModule'
,N'eProcedure'
,N'eUserId'
,N'eUserMessage'
,N'ecName'
,N'ecCode'
,N'ecDescription'
,N'ecMessage')
GO

Ozzie Mozzie 13-Mar-15 6:12am View

But there is no stored procedure

Ozzie Mozzie 13-Mar-15 6:05am View

No Exception

Ozzie Mozzie 13-Mar-15 6:03am View

Yes it does still complete

Ozzie Mozzie 12-Mar-15 22:01pm View

Please help me with an example

Ozzie Mozzie 12-Mar-15 21:35pm View

Please provide example :)

Ozzie Mozzie 12-Mar-15 21:06pm View

No row created and no indication of failure from the server

Ozzie Mozzie 12-Mar-15 21:02pm View

I removed the second "conn.Open();" down the bottom (oversight) but it still fails.

Ozzie Mozzie 12-Mar-15 20:55pm View

I get no error message in the application but it seems to return on cmd.ExecuteNonQuery();

Comments by Ozzie Mozzie (Top 12 by date)