Clan error 58 window server 2003

[davidscofield]

hi all.
I had read all method to fix error 58 . but i can't setup clan
I had change all file claninsert.aspx, setting.asp, sodsetting.asp, sqldll.reg, hex file clan.dll .
change sql config TCP/IP port 1433. virtual drectory iis clan, clancontent, Servermain.
i had rename ClanDb to ClanDB .

But i can not fix error.
I had used sql server 2005 express. netframework 2.0
i had get error billingDBerror

233208|SELECT IDX FROMS1ClanSub UL WHERE userid='admin' AND ChName='Admin' Incorrect syntax near 'UL'.

Can you help me about it
thank you so much

 

[Phatkone]

SELECT IDX FROMS1ClanSub UL WHERE userid='admin' AND ChName='Admin'

should be:

SELECT IDX FROM ClanSub UL WHERE userid='admin' AND ChName='Admin'

however, do you have the ClanSub table? the files from sanduur and my files use 4 tables:

CL (clan list, has list of clans and their leader)
UL (user list, has list of the members of each clan)
CT (clan ticket, has a ticket against each player that is active in the game)
LI (image, keeps a tally of where the clan image/number is up to, incrementing with each new clan)

Looks like ClanSub is what we have as UL

 

[davidscofield]

i had use clan file sandurr .
it get all table UL,CL,CT,LI.

i had setup clan success with window 2008 ago.
but when i setup on window 2003. it not run.

can you help me about it?

 

[davidscofield]

i think sql server 2005 not open port 1433 for clansystem
because i ping port method . port 1433 not listening . port 1433 is dead. sql server only use dynamic port. not use port 1433
Why is this ?
creat clan OK but i check clan again it show error 58.
I think clan.dll not login SQL or clan system not login sql.
When i check page claninsert.aspx it return code=1
iis work fine. but it still error 58
i having check it.
thank you so much

 

[Phatkone]

hard set from dynamic port to 1433

 

[davidscofield]

yes. thank you so much