Code:
2011-03-09 11:01:11 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Server 'PS_USERDB01' is not configured for RPC., SQL STATE: 42000, NATIVE ERROR: 7411 (0x1CF3)
2011-03-09 11:01:11 ::SaveCharacter 236 test ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(236,1, 0,5, 14,12,9,8,7,15, 250,85,195, 1,0, 0,0, 577.979980,78.559998,1762.119995, 0,200,0,0,0, 0,0,0,0, 0,0)}
Code:
2011-03-09 11:16:02 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Server 'game' is not configured for RPC., SQL STATE: 42000, NATIVE ERROR: 7411 (0x1CF3)
2011-03-09 11:16:02 SaveBuyPointItem 239 Sadie qerr=-1, {?=call usp_Save_User_BuyPointItems_PayLetterT(115,239,1500,'PK_shaiy0001','2011-03-09 11:16:02',1)}
2011-03-09 12:04:20 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Server 'game' is not configured for RPC., SQL STATE: 42000, NATIVE ERROR: 7411
i got these error after i used Bane's Linked server query >.<
and this is my save char info:
Code:
USE [PS_GameData] GO /****** Object: StoredProcedure [dbo].[usp_Save_Char_Info_E] Script Date: 03/09/2011 23:50:53 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO /****** Object: Stored Procedure dbo.usp_Save_Char_Info_E Script Date: 2008-6-7 18:31:57 ******/ /****** Object: Stored Procedure dbo.usp_Save_Char_Info_E Script Date: 2008/3/15 下午 05:25:52 ******/ ALTER Proc [dbo].[usp_Save_Char_Info_E] @CharID int, @Level int, @StatPoint smallint, @SkillPoint smallint, @Str smallint, @Dex smallint, @Rec smallint, @Int smallint, @Wis smallint, @Luc smallint, @Hp smallint, @Mp smallint, @Sp smallint, @Map smallint, @Dir smallint, @Exp int, @Money int, @Posx real, @Posy real, @Posz real, @Hg int, @Vg int, @Cg int, @Og int, @Ig int, @K1 int = null, @K2 int = null, @K3 int = null, @K4 int = null, @KillLevel tinyint, @DeadLevel tinyint AS SET NOCOUNT ON DECLARE @ServerID int DECLARE @UID varchar (18) SET @ServerID = 1 UPDATE Chars SET [Level] = @Level, StatPoint = @StatPoint, SkillPoint = @SkillPoint, [Str] = @Str, dex = @Dex, Rec = @Rec, [int] = @Int, Wis = @Wis, Luc = @Luc, HP = @Hp, Mp = @Mp, Sp = @Sp, Map = @Map, dir = @Dir, [exp] = @Exp, [money] = @Money, PosX = @Posx, PosY = @PosY, PosZ = @PosZ, hg = @Hg, vg = @Vg, cg = @Cg, og = @Og, ig = @Ig, KillLevel=@KillLevel, DeadLevel=@DeadLevel,LeaveDate=GETDATE() WHERE CharID = @CharID --UPDATE Chars SET LeaveDate=GETDATE() , LoginStatus = 0 WHERE CharID=@CharID --SELECT @Sta=LoginStatus FROM CHARS WHERE CharID = @CharID IF( (@K1 IS NOT NULL) AND (@K2 IS NOT NULL) AND (@K3 IS NOT NULL) AND (@K4 IS NOT NULL)) BEGIN UPDATE Chars SET K1=@K1, K2=@K2, K3=@K3, K4=@K4 WHERE CharID=@CharID END --IF(@Sta=0) --BEGIN --END --EXEC game.PS_UserData_IDC_T3.dbo.usp_Update_CharsPVPData_E @ServerID = @ServerID, @CharID = @CharID, @K1 = @K1, @K2 = @K2, @K3 = @K3, @K4 = @K4 IF(@@ERROR = 0 AND @@ROWCOUNT = 1) BEGIN --SELECT @UID=UserID FROM CHARS WHERE CharID=@CharID --UPDATE CHARS SET LoginStatus = 0 WHERE (CharID<>@CharID) AND (UserID=@UID) RETURN 1 END ELSE BEGIN --SELECT @UID=UserID FROM CHARS WHERE CharID=@CharID --UPDATE CHARS SET LoginStatus = 0 WHERE (CharID<>@CharID) AND (UserID=@UID) --UPDATE Chars SET LeaveDate=GETDATE() , LoginStatus = 0 WHERE CharID=@CharID RETURN -1 END SET NOCOUNT OFF






