Session Server Closes After Login

[steven031291]

hello i login then it says disconnected from server and the event log shows

CRITICAL ERROR : SP_LOGIN_FLAG_SET PROC CALL FAIL

in using the new files posted

[pieter]

you are using an outdated siege script

u have to fix the year 2010 bug in the FN_BinDateToStr function asswell

[steven031291]

ok i get
[6688] Microsoft OLE DB Provider for SQL Server: Conversion failed when converting datetime from character string.

mind telling me how to fix it
most proberly a stored procedure

[steven031291]

im getting
[4368] ------------------ Connect Session Server IP : [ 127.0.0.1 ] ------------------
[7104] File: .\Message\FormatHandler\Provider.cpp, Line: 81
[6220] ------------------ Connect Session Server IP : [ 127.0.0.1 ] ------------------
[4368] ------------------ Connect Session Server IP : [ 127.0.0.1 ] ------------------
[7104] Provider::Execute( CCHAR * szName )
[7104] szName: SP_LOGIN_FLAG_SET
[7104] Microsoft OLE DB Provider for SQL Server: The OLE DB provider "MSDASQL" for linked server "LSV_DKRACNT" reported an error. The provider did not give any information about the error.

p.s im using mssql 2005 and ive excuted sn.txt

[pieter]

make so u fixed the function FN_BinDateToTime allready?

that OLE error should not be critical

[steven031291]

i did this for temp

USE [character]
GO
/****** Object: UserDefinedFunction [dbo].[FN_BinDateToDateTime] Script Date: 06/25/2010 10:43:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO



/************************************************** ****************************
이 름 : dbo.FN_BinDateToDateTime
설 명 : Binary Date를 DateTime 형식으로 반환한다.
반환값 :
수정내역:
Ver Date Author Description
--------- ---------- --------------- ------------------------------------
1.0 2006-05-05 Han Ji Wook 1. 초기생성
************************************************** ****************************/
ALTER FUNCTION [dbo].[FN_BinDateToDateTime] (
@i_bin_time binary(4)
) RETURNS datetime
AS
BEGIN
DECLARE @v_datetime datetime
--DECLARE @v_strtime varchar(20)
--SELECT @v_strtime = '200' + CAST(CAST(@i_bin_time as int) as varchar(20))
--SELECT @v_strtime = SUBSTRING(@v_strtime,1,4)
-- +'-'+SUBSTRING(@v_strtime,5,2)
-- +'-'+SUBSTRING(@v_strtime,7,2)
-- +' '+SUBSTRING(@v_strtime,9,2)
-- +':'+SUBSTRING(@v_strtime,11,2)
--SELECT @v_datetime = CAST(@v_strtime as datetime)
SELECT @v_datetime = '2010-05-25 00:00'
RETURN @v_datetime
END

fixed it 100% logging in thanks for your support most the problem was the linked servers werrnt getting connection to the db

[Nosferatu.]

Originally Posted by steven031291

i did this for temp

Originally Posted by steven031291

fixed it 100% logging in thanks for your support most the problem was the linked servers werrnt getting connection to the db

#Reported Cause: Double Posting at 6&7

Please use edit Button @steven031291

[~Kakkarot~]

#merged

[Bullet2l]

Originally Posted by steven031291

im getting
[4368] ------------------ Connect Session Server IP : [ 127.0.0.1 ] ------------------
[7104] File: .\Message\FormatHandler\Provider.cpp, Line: 81
[6220] ------------------ Connect Session Server IP : [ 127.0.0.1 ] ------------------
[4368] ------------------ Connect Session Server IP : [ 127.0.0.1 ] ------------------
[7104] Provider::Execute( CCHAR * szName )
[7104] szName: SP_LOGIN_FLAG_SET
[7104] Microsoft OLE DB Provider for SQL Server: The OLE DB provider "MSDASQL" for linked server "LSV_DKRACNT" reported an error. The provider did not give any information about the error.

p.s im using mssql 2005 and ive excuted sn.txt

u forgot 1 important step. SN text. must select character to excute. and pls u might be a nub, but u shld know simple rule like double post is nt allow.

[steven031291]

lol read i clearly state i did that plus ive said i fixed it and the reason was that the sql linked servers wernt connecting i had to edit the login ect

[Zombe]

Looks like a compatibility problem, the Dekaron database doesn't run perfectly on MSSQL 2005, and the reason for that is because it's server linking is a bit different...
Though some people did get Dekaron on MSSQL2005. Don't ask me how though, I have no idea.
I'd recommend you to get MSSQL2000, what 99% people run the server on.