Session Server Closes After Login

06/24/2010 23:28 steven031291#1
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

[Only registered and activated users can see links. Click Here To Register...]
06/25/2010 01:41 pieter#2
you are using an outdated siege script

u have to fix the year 2010 bug in the FN_BinDateToStr function asswell
06/25/2010 02:50 steven031291#3
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
06/25/2010 03:57 steven031291#4
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
06/25/2010 07:54 pieter#5
make so u fixed the function FN_BinDateToTime allready?

that OLE error should not be critical
06/25/2010 10:57 steven031291#6
i did this for temp
Quote:
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
06/25/2010 12:04 Nosferatu.#7
Quote:
Originally Posted by steven031291 View Post
i did this for temp
Quote:
Originally Posted by steven031291 View Post
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
06/25/2010 12:07 ~Kakkarot~#8
#merged
06/25/2010 15:39 Bullet2l#9
Quote:
Originally Posted by steven031291 View Post
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.
06/25/2010 22:45 steven031291#10
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
06/26/2010 07:15 Zombe#11
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.