[English]Discussion

Zitat

2009/10/14 18:12:13
query:Owner
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Anyone know a way to fix this?o:,I'm using MsSQL Express 2005

Zitat von vaxtang91;35584

i got a problem when im trying to open database server (after i opend account server seccsesfuly) here is the error

the database server ini is in the script foldet and i changed all the info there to what is sayes in a guide i found in other forum O_O maybe somone allso has a more info guide cuz there its not realy understood ^^ maybe i did somthing wrong

waiting for reply ^^

Zitat von vaxtang91;37786

if you see some posts before i did all that i got the same databaseserver.ini in the script folder and in the resource folder and still he tells me Fail to read databaseserver.ini i have no freaking idea why that happens please if somone can tell me whats wrong O_O look at some older posts youle see my databaseserver.ini screenshot please somone try to help me i cant get the database server working O_O

p.s:when im trying to put the 127.0.0.1 instad of no-ip it gives me those errors

1:2009/10/13 01:02:22
query:uspLoadPlayerData '01'
SQLSTATE:42S02 error:[Microsoft][SQL Native Client][SQL Server]Invalid object name 'CHARACTER_TBL'.

2:2009/10/13 01:02:22 LoadPlayerData - query: uspLoadPlayerData '01'

any ideas for that?

anyone can finaly help me? i think it has somthing to do with the fact that when i put up my DB in SQL 4 of 5 parts gave me red errors down O_O here some screens
Account_DBF:

Character_01_DBF:

Item_DBF:

Log_01_DBF:

Ranking_DBF:

hope that is enoght info so somone will finaly help me with my problem!

thanks waiting for reply! :)

Zitat von vaxtang91;38445

anyone can finaly help me? i think it has somthing to do with the fact that when i put up my DB in SQL 4 of 5 parts gave me red errors down O_O here some screens
Account_DBF:

Character_01_DBF:

Item_DBF:

Log_01_DBF:

Ranking_DBF:

hope that is enoght info so somone will finaly help me with my problem!

thanks waiting for reply! :)

Alles anzeigen

did you open "log01" in ODBC? if not, open one like the character01 and login.
did you changed databaseserver.ini in resource folder too? same as DBServer.ini in Script?

When I change all my WAN IP (public IP) I get this in cache server..and everything is connected, and online...

2009/10/15 05:43:28
CDPCoreClient::OnJoin - server not found id:1 account:keith player:Keith world:1

any idea why?

Zitat

anyone? please help me :X

i cant open worldserver.exe.

this is my .ini files:

and when i open the worldserver.exe, error.txt is opened and i see this error:

anyone? please help me!!! alot of ppl waiting for my server = \

Zitat von GarbeTz;38496

did you open "log01" in ODBC? if not, open one like the character01 and login.
did you changed databaseserver.ini in resource folder too? same as DBServer.ini in Script?

still errors O_O god dammit im going crazy haha can somone please support me in MSN or somthing? i cant get that freaking thing to work O_O can somone give me a screen shot of his DBserver.ini in script folder and in resource folder? and a pic of the folder itself? and everything else? so i can compere to mine? O_O

Need help with this.

How i can fix it's need help please.

Zitat von pimme;38849

Need help with this.

How i can fix it's need help please.

i think you should try other resfiles.:wink:

hi can u help me guys... why i always get wrong password in my server when i create an account.. i used already md5 password, nForceIsGay+pass, and the gala one..

can u help me with this??

what neuz i use whe md5 password is put in databse and the same in nForceIsGay+pass??? can help me tnx

And one thing... what i supposed to choose ind setting up ODBC??

SQL server??? or SQL NAtive Client?? tnx

ok so ive managed to start all the exe files without your help O_O hehe so now i got another problem

how do i connect to the server i just made? O_O what launcher and neuz do i use? ive tryed fame launcher and neuz but i changed it to my ip and still connects to fame please help this is (hopefully) the last problem i have till i can login on my server :)

oh and can i use a no-ip addres instad of 127.0.0.1 so others can login or do i need diffrent ip?

Zitat von vaxtang91;39110

ok so ive managed to start all the exe files without your help O_O hehe so now i got another problem

how do i connect to the server i just made? O_O what launcher and neuz do i use? ive tryed fame launcher and neuz but i changed it to my ip and still connects to fame please help this is (hopefully) the last problem i have till i can login on my server :)

oh and can i use a no-ip addres instad of 127.0.0.1 so others can login or do i need diffrent ip?

can you help me please?
i need help about start the .exe files
i cant open worldserver.exe

can you help me at msn or something?

Hello everybody. I know the file that I modify the exp, drop and drop penya? I also want to know where and how to put GM account. Thank JoauNn

Zitat von vaxtang91;39110

ok so ive managed to start all the exe files without your help O_O hehe so now i got another problem

how do i connect to the server i just made? O_O what launcher and neuz do i use? ive tryed fame launcher and neuz but i changed it to my ip and still connects to fame please help this is (hopefully) the last problem i have till i can login on my server :)

oh and can i use a no-ip addres instad of 127.0.0.1 so others can login or do i need diffrent ip?

anybody?:lll._.:

Zitat von vaxtang91;39492

anybody?:lll._.:

how u fixed ur problem in databaseserver.ini failed to read ini?????

anyone knows how to change the exp , drop and penya rate?

Zitat von mtrosin;39527

anyone knows how to change the exp , drop and penya rate?

Constant in resource

Zitat von ctby23;39093

And one thing... what i supposed to choose ind setting up ODBC??

SQL server??? or SQL NAtive Client?? tnx

Native Client.

Zitat von ctby23;39088

hi can u help me guys... why i always get wrong password in my server when i create an account.. i used already md5 password, nForceIsGay+pass, and the gala one..

can u help me with this??

what neuz i use whe md5 password is put in databse and the same in nForceIsGay+pass??? can help me tnx

execute this and try again.
User= test
Password= test
if doesnt work may your accountserver.ini is not correct, or something...

-- SQL Manager 2008 for SQL Server 3.4.0.7
-- ---------------------------------------
-- Host       : 93.174.93.179\FAMESQL
-- Datenbank  : ACCOUNT_DBF
-- Version    : Microsoft SQL Server  10.0.1600.22


USE [ACCOUNT_DBF]
GO


INSERT INTO [dbo].[ACCOUNT_TBL] ([account], [password], [isuse], [member], [id_no1], [id_no2], [realname], [reload], [vers], [attempts], [bantime], [lastip])
VALUES 
  (N'test', N'172c2125beb8251396f14e01cf1766e6', N'T', N'A', NULL, N'172c2125beb8251396f14e01cf1766e6', N'F', NULL, 0, NULL, NULL, NULL)
GO


INSERT INTO [dbo].[ACCOUNT_TBL_DETAIL] ([account], [gamecode], [tester], [m_chLoginAuthority], [regdate], [BlockTime], [EndTime], [WebTime], [isuse], [secession], [net_enable], [vers], [AccSource], [AccSourceID], [email], [birthday], [ban_reason], [ip])
VALUES 
  (N'test', N'A000', N'2', N'F', '20080818 00:51:35.700', N'20010101', N'20990101', N'20050101', N'O', NULL, NULL, 0, N'0', 0, N'a2lsbGEtZGF2QHdlYi5kZQ==', N'MDguMDkuMTk5Mw==', N'', N'test')
GO

Zitat von lydiocampos;39526

how u fixed ur problem in databaseserver.ini failed to read ini?????

used a normal clean and new DB the one i had gave me errors and i found a better one that added to SQL server with no errors and it just workd :) i knew somthing was wrong with my DB

anyway ive started the server and loged on and everything is cool...now what should i change so anyone else can join on my server :) and can i use no-ip? cuz ive been told i cant O_O

Hello GodLikerz ;)
So, i have got everything working now, but theres one problem (ore maybe more?) left:
Everytime, i try to get past the Serverscreen (where the Channels are listed), i get this error:
and in my error.txt + CQuery-LogFile is the following content:

Zitat

error.txt
2009/10/21 12:19:00
C:\neurospace\PROGRAM\_database\DbManager.cpp, 351 CHARACTER_STR 'S2',@im_idPlayer='0000000',@iserverindex='01',@iaccount='edin',@im_szName='172c2125beb8251396f14e01cf1766e6',@iplayerslot=0,@idwWorldID=0,@im_dwIndex=0,@im_vPos_x=0.000000,@im_vPos_y=0.000000,@im_vPos_z=0.000000,@im_szCharacterKey='(null)',@im_dwSkinSet=0,@im_dwHairMesh=0,@im_dwHairColor=0,@im_dwHeadMesh=0,@im_dwSex=0,@im_vScale_x=0.000000,@im_dwMotion=0,@im_fAngle=0.000000,@im_nHitPoint=0,@im_nManaPoint=0,@im_nFatiguePoint=0,@im_dwRideItemIdx=0,@im_dwGold=0,@im_nJob=0,@im_pActMover='(null)',@im_nStr=0,@im_nSta=0,@im_nDex=0,@im_nInt=0,@im_nLevel=0,@im_nExp1=0,@im_nExp2=0,@im_aJobSkill='(null)',@im_aLicenseSkill='(null)',@im_aJobLv='(null)',@im_dwExpertLv=0,@im_idMarkingWorld=0,@im_vMarkingPos_x=0.000000,@im_vMarkingPos_y=0.000000,@im_vMarkingPos_z=0.000000,@im_nRemainGP=0,@im_nRemainLP=0,@im_nFlightLv=0,@im_nFxp=0,@im_nTxp=0,@im_lpQuestCntArray='(null)',@im_chAuthority='F',@im_dwMode=0,@im_idparty=0,@im_idMuerderer=0,@im_nFame=0,@im_nDeathExp=0,@im_nDeathLevel=0,@im_dwFlyTime=0,@im_nMessengerState=0,@iTotalPlayTime=0,@im_Card='(null)',@im_Index_Card='(null)',@im_ObjIndex_Card='(null)',@im_Cube='(null)',@im_Index_Cube='(null)',@im_ObjIndex_Cube='(null)',@im_Inventory='(null)',@im_apIndex='(null)',@im_adwEquipment='(null)',@im_dwObjIndex='(null)',@im_aSlotApplet='(null)',@im_aSlotItem='(null)',@im_aSlotQueue='(null)',@im_SkillBar=0,@im_Bank='(null)',@im_apIndex_Bank='(null)',@im_dwObjIndex_Bank='(null)',@im_dwGoldBank=0,@im_nFuel=0,@im_tmAccFuel=0,@im_dwSMTime='(null)',@iSkillInfluence='(null)',@im_aCompleteQuest='(null)',@im_extInventory='(null)',@im_InventoryPiercing='(null)',@im_extBank='(null)',@im_BankPiercing ='(null)',@im_dwReturnWorldID=0,@im_vReturnPos_x=0.000000,@im_vReturnPos_y=0.000000,@im_vReturnPos_z=0.000000,@im_nPKValue=0,@im_dwPKPropensity=0,@im_dwPKExp=0,@im_nAngelExp=0,@im_nAngelLevel=0,@iszInventoryPet='(null)',@iszBankPet='(null)', @im_dwPetId=0,@im_nExpLog=0, @im_nAngelExpLog=0,@im_nCoupon=0

edin, 172c2125beb8251396f14e01cf1766e6 (yeah, its 'test' :P)

CQuery-LogFile
2009/10/21 12:19:00
query:CHARACTER_STR 'S2',@im_idPlayer='0000000',@iserverindex='01',@iaccount='edin',@im_szName='172c2125beb8251396f14e01cf1766e6',@iplayerslot=0,@idwWorldID=0,@im_dwIndex=0,@im_vPos_x=0.000000,@im_vPos_y=0.000000,@im_vPos_z=0.000000,@im_szCharacterKey='(null)',@im_dwSkinSet=0,@im_dwHairMesh=0,@im_dwHairColor=0,@im_dwHeadMesh=0,@im_dwSex=0,@im_vScale_x=0.000000,@im_dwMotion=0,@im_fAngle=0.000000,@im_nHitPoint=0,@im_nManaPoint=0,@im_nFatiguePoint=0,@im_dwRideItemIdx=0,@im_dwGold=0,@im_nJob=0,@im_pActMover='(null)',@im_nStr=0,@im_nSta=0,@im_nDex=0,@im_nInt=0,@im_nLevel=0,@im_nExp1=0,@im_nExp2=0,@im_aJobSkill='(null)',@im_aLicenseSkill='(null)',@im_aJobLv='(null)',@im_dwExpertLv=0,@im_idMarkingWorld=0,@im_vMarkingPos_x=0.000000,@im_vMarkingPos_y=0.000000,@im_vMarkingPos_z=0.000000,@im_nRemainGP=0,@im_nRemainLP=0,@im_nFlightLv=0,@im_nFxp=0,@im_nTxp=0,@im_lpQuestCntArray='(null)',@im_chAuthority='F',@im_dwMode=0,@im_idparty=0,@im_idMuerderer=0,@im_nFame=0,@im_nDeathExp=0,@im_nDeathLevel=0,@im_dwFlyTime=0,@im_nMessengerState=0,@iTotalPlayTime=0,@im_Card='(null)',@im_Index_Card='(null)',@im_ObjIndex_Card='(null)',@im_Cube='(null)',@im_Index_Cube='(null)',@im_ObjIndex_Cube='(null)',@im_Inventory='(null)',@im_apIndex='(null)',@im_adwEquipment='(null)',@im_dwObjIndex='(null)',@im_aSlotApplet='(null)',@im_aSlotItem='(null)',@im_aSlotQueue='(null)',@im_SkillBar=0,@im_Bank='(null)',@im_apIndex_Bank='(null)',@im_dwObjIndex_Bank='(null)',@im_dwGoldBank=0,@im_nFuel=0,@im_tmAccFuel=0,@im_dwSMTime='(null)',@iSkillInfluence='(null)',@im_aCompleteQuest='(null)',@im_extInventory='(null)',@im_InventoryPiercing='(null)',@im_extBank='(null)',@im_BankPiercing ='(null)',@im_dwReturnWorldID=0,@im_vReturnPos_x=0.000000,@im_vReturnPos_y=0.000000,@im_vReturnPos_z=0.000000,@im_nPKValue=0,@im_dwPKPropensity=0,@im_dwPKExp=0,@im_nAngelExp=0,@im_nAngelLevel=0,@iszInventoryPet='(null)',@iszBankPet='(null)', @im_dwPetId=0,@im_nExpLog=0, @im_nAngelExpLog=0,@im_nCoupon=0
SQLSTATE:42000 error:[Microsoft][SQL Native Client][SQL Server]Die gespeicherte Prozedur 'CHARACTER_STR' wurde nicht gefunden.
2009/10/21 12:19:16
query:MAIL_STR_REALTIME 'S1', '01'
SQLSTATE:24000 error:[Microsoft][SQL Native Client]Ungültiger Cursorstatus
2009/10/21 12:20:16
query:MAIL_STR_REALTIME 'S1', '01'
SQLSTATE:24000 error:[Microsoft][SQL Native Client]Ungültiger Cursorstatus

Alles anzeigen

How do i fix this?

Greetings,
Edin