[Help]loginserver

i have searched and prodded forums trying to figure out what im doing wrong ......maybe someone can help me here ...

i keep getting error "load version list failed" i have read several guides trying to fix it .....

please help me ...what am i doing wrong

Run This In Query manager

Code:

---

CREATE TABLE [dbo].[VERSION] (
        [version] [smallint] NULL ,
        [filename] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
        [compname] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
        [hisversion] [smallint] NULL
) ON [PRIMARY]
GO

---

ok do i run it in query manager under my KN_online db or in something else?

this is what i got from running in KN_online

Server: Msg 2714, Level 16, State 6, Line 1
There is already an object named 'VERSION' in the database.

then its something in your version.ini

ok this is what is in my version.ini without ip addy for obvious reasons


[DOWNLOAD]
URL=wizgate.nefficient.co.kr
PATH=pub/wizgate2/knight/upgrade

[ODBC]
DSN=KN_online
UID=knight
PWD=knight
TABLE=VERSION

[CONFIGURATION]
DEFAULT_PATH=D:\KOserver

[SERVER_LIST]
COUNT=4
SERVER_00=*
NAME_00=Eddie

your db name is KN_online?

yes my db is KN_online and i set all other db's the way the guide said...


this is what im getting in the log file for version manager

*** 37000, 170, [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'N'., 81 ***


thx in advance for any help

also im not understanding why the client is so hard to find... all the links seem to dead

delete the old VERSION table and use that one he posted

did that and still getting load version list fail ....i dunno the guide is very consice and i followed it to the letter ...maybe the 1098 server isnt gonna work for me....any suggestions?

ok check your knight user permissions make sure you add him on security logins and users...
make sure the password is knight
and then right click on KN_online
Properties then permission and check all rows for knight...

donno if you have done that already..

have the same prob nothing helps

CREATE PROCEDURE MYST_LOGIN
@AccountID varchar(21),
@Password varchar(13),
@nRet smallint OUTPUT

AS


DECLARE @Nation tinyint, @CharNum smallint
SET @Nation = 0
SET @CharNum = 0

DECLARE @pwd varchar(13)

SET @pwd = null

SELECT @pwd = strPasswd FROM [dbo].[TB_USER] WHERE strAccountID = @AccountID
IF @pwd IS null
BEGIN
SET @nRet = 0
RETURN
END

ELSE IF @pwd <> @Password
BEGIN
SET @nRet = 0
RETURN
END

SELECT @Nation = bNation, @CharNum = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
IF @@ROWCOUNT = 0
BEGIN
SET @nRet = 1
RETURN
END
IF @CharNum = 0
BEGIN
SET @nRet = 1
RETURN
END
ELSE
BEGIN
SET @nRet = @Nation+1
RETURN
END


GO










RUN THAT IN QUERY

i would give credits but i forgot who posted it :)

could someone point out where query is? shook my kn_online db upside down still cant find the damn file xD

This may sound dum but are you trying to run this on vista? Because I did that, when I first tried setting up my server and got the same errors you posted.

ya, i've just recently realized that vista sucks balls... login server kept giving me that dam "load version list fail!!" error, then i transfered my server files, to my xp desktop, and the login manager worked perfectly, so i've been spending some time learning how to downgrade my laptop to xp. good times...