Can you help me pls? after log in char DC

[Shakugan]

Query Error!!! Query Result : -1, Query : exec _AddCurrentUserCount 64, 0, '2012-11-14 13:59:49'
SQL Error State:42000, Native Error Code: 1FB2, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Fehler beim Konvertieren des varchar-Datentyps in datetime.
exec _AddCurrentUserCount 64, 0, '2012-11-14 13:59:49'


I have changed my odbc files in english and my Region and Language in english too! doesnt work for me :(

i have read i need to change anythink on SRO_VT_ACCOUNT maybe?
Can you help me with TimeViewer pls?

[MentaL]

[lemoniscool]

you could have a look at the _AddCurrentUserCount Procedure and have a look at what point it returns -1, in addition to that try to find out why you get the error message that tells you that you cant convert a varchar datatype to a datetime datatype

aside of that check your ODBC settings, inside them you can set a "Default Language" for that DSN, set it to "English" in case you didnt do that already, if that doesnt work, the easiest way to fix this problem is to edit the tables where the error occurs set the Datatype of the Date Column to varchar

[Shakugan]

you know where is this _AddCurrentUserCount Procedure?

[lemoniscool]

SRO_VT_ACCOUNT->Programmability->Stored Procedures->_AddCurrentUserCount

(Or in German what i think you are because of the error message)
SRO_VT_ACCOUNT->Programmierbarkeit->Gespeicherte Prozeduren->_AddCurrentUserCount

[Shakugan]

-- ================================================
-- Template generated from Template Explorer using:
-- Create Procedure (New Menu).SQL
--
-- Use the Specify Values for Template Parameters
-- command (Ctrl-Shift-M) to fill in the parameter
-- values below.
--
-- This block of comments will not be included in
-- the definition of the procedure.
-- ================================================
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
CREATE PROCEDURE <Procedure_Name, sysname, ProcedureName>
-- Add the parameters for the stored procedure here
<@Param1, sysname, @p1> <Datatype_For_Param1, , int> = <Default_Value_For_Param1, , 0>,
<@Param2, sysname, @p2> <Datatype_For_Param2, , int> = <Default_Value_For_Param2, , 0>
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

-- Insert statements for procedure here
SELECT <@Param1, sysname, @p1>, <@Param2, sysname, @p2>
END
GO

_____________________________________________________________________

USE [SRO_VT_ACCOUNT]
GO
/****** Object: StoredProcedure [dbo].[_AddCurrentUserCount] Script Date: 11/14/2012 14:27:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[_AddCurrentUserCount]
@nShardID INT,
@nUserCount INT,
@dLogDate DATETIME
AS
BEGIN
INSERT INTO _ShardCurrentUser (nShardID, nUserCount, dLogDate) VALUES (@nShardID, @nUserCount, @dLogDate)
END

------------------------------------------------------------------
anythink to change maybe????

[lemoniscool]

no you dont have to change the procedure, just look what it does and see that it inserts into _ShardCurrentUser Table
so when inserting into it, it returns with the error you posted above, which means you have to edit _ShardCurrentUser Table

but to be honest i didnt have to edit that table, so try editing your ODBC DSN for SRO_VT_ACCOUNT first .. inside the settings you can set a default language for it which has to be English (and is set to German by default if you use a German OS for example)

[Shakugan]

could you check it via timeviewer maybe?

[lemoniscool]

//Edit:
Problem Solved

[Shakugan]

Uploaded with ImageShack.us

somethink wrong happend i dont know :(((((

we changed ODBC files perfektly !

could you show me how to set my region and time settings on configurations?

[lemoniscool]

as i said to you already, if the same error happens with other Stored Procedures too, fix them as we fixed _AddCurrentUserCount

[Shakugan]

Please i need help -.- pls can someone help me pls



need i somethink to change in _LogShedule ?? pls help me