[Help]Stuck at CharCreation >>

Hey ppl i was sucessfull in making my server....every thing is running well but once i log in the client n try to make a new char the game does not advance....what cn be the prob ?
well i tried to change the order of server startups n launched Zoneagent at the end....then again i was able to log in n even able to select "Createchar" option but got stuck while naming it (nothing happns after i name it n prees ok),n yes i had this error when i tried to name selected char in zone/account n main server : ACCOUNT:Acc Error 1x1002.....is my account server faulty,if so cn sm one provide a archive of their working Account servers(i'll change setting accod'ly) if possible or post a solution to my prob :(

problem is: *as I said before* if your server runs without errors it doesnt mean it has no erros at all.

1) double check your ini files and compare them with your odbc entries. if necesary, delete all odbc entries related with the server and add them manually.

2) check your log files

3) search on the forum

Did go through 1st n 3rd step but never found the solution,mind elaborating 2nd one though......using account servers from other files (1.20/2.05) won't disrrupt the current working setup will it ?
Did try to search n i guess no one before had similar prob.....or cn't find the appropriate kayword to search,btw i'll still try.....

mixed versions: http://forum.ragezone.com/a3/how-con...nt-140974.html

another with mixed versions
(see what akaruz has to say about that)

http://forum.ragezone.com/a3/event-i...ml#post1347518

His error is a common one. It happens when the account server is unable to connect to the Account Database.
Dude, can you please post the ODBC file that you have registered here!
Its is 100% a case of wrongly registered ODBC's and nothing else..!!
Cant be a client incompatibility problem coz you are able to log on into the game.

Post your ODBC registry entries here or copy and paste them.

And btw Ins@ne I sent you a pm today did you recieve it?

Yep. I did receive that and also an infraction from Exclamatio too ... :(( .. I lost a point. Any idea what these points do?

I'll reply to your PM in a lil while.

Infraction I believe it was because of the signature =(

Yes. I kinda posted info about my server in the siggy..
He removed it and now I had to change it again.
What are the points for..any idea..?

I believe they are for a warning. It will disappear after a few days.

ODBC's i have : [COMP is my local server]

Quote:

---

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI]

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\A3Friend]
"Driver"="C:\WINDOWS\System32\SQLSRV32.dll"
"Server"="COMP"
"Database"="FriendDB"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\A3RcvResult]
"Driver"="C:\WINDOWS\System32\SQLSRV32.dll"
"Server"="COMP"
"Database"="A3ItemEvent"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\A3Seriallist]
"Driver"="C:\WINDOWS\System32\SQLSRV32.dll"
"Server"="COMP"
"Database"="A3ItemEvent"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\EventA3]
"Driver"="C:\WINDOWS\System32\SQLSRV32.dll"
"Server"="COMP"
"Database"="ASD"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\FriendDB]
"Driver"="C:\WINDOWS\System32\SQLSRV32.dll"
"Server"="COMP"
"Database"="HSDB"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\HSDB]
"Driver"="C:\WINDOWS\System32\SQLSRV32.dll"
"Server"="COMP"
"Database"="HSDB"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\LETTERDB]
"Driver"="C:\WINDOWS\System32\SQLSRV32.dll"
"Server"="COMP"
"Database"="FriendDB"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\LocalServer]
"Description"=""
"Server"="COMP"
"Trusted_connection"=""
"UseProcForPrepare"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\Login202]
"Driver"="C:\WINDOWS\System32\SQLSRV32.dll"
"Server"="COMP"
"Database"="ASD"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\NEWASD]
"Driver"=""
"Server"="COMP"
"Database"="ASD"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources]
"LocalServer"="SQL Server"
"A3RcvResult"="SQL Server"
"A3SerialList"="SQL Server"
"FriendDB"="SQL Server"
"NEWASD"="SQL Server"
"Login202"="SQL Server"
"LETTERDB"="SQL Server"
"EventA3"="SQL Server"
"A3Friend"="SQL Server"
"HSDB"="SQL Server"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC File DSN]
"DefaultDSNDir"="C:\Program Files\Common Files\ODBC\Data Sources"

---

wanted to ask does my server name i.e. COMP has to be in brackets ? {like Server = (COMP) } n i had changed the double "/" in C:\\WINDOWS\\System32\\SQLSRV32.dll .....hope i diddn't do ne thing wrong here

also i dun have space b/w LocalServer,A3RcvResult and A3Seriallist ......dunno but its just being shown that way under quote's

This is what happens when you dont bother having a look at it.
The ODBC needs to be edited.
Remove the unwanted spaces everywhere and fix any other writing errors. It will fix your problem.

i had already edited space b/w wrong ODBC's but they tend to appear with space within Quote's

and I will post a hint here. I know the guide asks for an sql account for the ODBC entries, but ... you dont *have* to.

Quote:

---

Originally Posted by RudyMartin

and I will post a hint here. I know the guide asks for an sql account for the ODBC entries, but ... you dont *have* to.

---

You mean i don't have to create an a3serial login for ODBC's or that it already exists ?
btw i have already made the a3serial login with password dkdlxpawprhdnpc

.....plz elaborate ur point Rudy

Quote:

---

[ODBC 32 bit Data Sources]
MS Access Database=Microsoft Access Driver (*.mdb) (32 bit)
Excel Files=Microsoft Excel Driver (*.xls) (32 bit)
dBASE Files=Microsoft dBase Driver (*.dbf) (32 bit)
A3GameCharDB=SQL Server (32 bit)
A3ItemStorageDB=SQL Server (32 bit)
ClanDB=SQL Server (32 bit)
A3Friend=SQL Server (32 bit)
A3RcvResult=SQL Server (32 bit)
A3SerialList=SQL Server (32 bit)
EventA3=SQL Server (32 bit)
FriendDB=SQL Server (32 bit)
HSDB=SQL Server (32 bit)
LETTERDB=SQL Server (32 bit)
Login202=SQL Server (32 bit)
NEWASD=SQL Server (32 bit)
LocalServer=SQL Server (32 bit)
[MS Access Database]
Driver32=C:\WINDOWS\system32\odbcjt32.dll
[Excel Files]
Driver32=C:\WINDOWS\system32\odbcjt32.dll
[dBASE Files]
Driver32=C:\WINDOWS\system32\odbcjt32.dll
[A3GameCharDB]
Driver32=C:\WINDOWS\system32\SQLSRV32.dll
[A3ItemStorageDB]
Driver32=C:\WINDOWS\system32\SQLSRV32.dll
[ClanDB]
Driver32=C:\WINDOWS\system32\SQLSRV32.dll
[A3Friend]
Driver32=C:\WINDOWS\system32\SQLSRV32.dll
[A3RcvResult]
Driver32=C:\WINDOWS\system32\SQLSRV32.dll
[A3SerialList]
Driver32=C:\WINDOWS\system32\SQLSRV32.dll
[EventA3]
Driver32=C:\WINDOWS\system32\SQLSRV32.dll
[FriendDB]
Driver32=C:\WINDOWS\system32\SQLSRV32.dll
[HSDB]
Driver32=C:\WINDOWS\system32\SQLSRV32.dll
[LETTERDB]
Driver32=C:\WINDOWS\system32\SQLSRV32.dll
[Login202]
Driver32=C:\WINDOWS\system32\SQLSRV32.dll
[NEWASD]
Driver32=C:\WINDOWS\system32\SQLSRV32.dll
[LocalServer]
Driver32=C:\WINDOWS\system32\SQLSRV32.dll

---

Check your ODBC.ini (the configuration file for the ODBC's) It should match this. If it does not, then you made a mistake somewhere...!!

well i have pasted my ODBC's n u think it matches ur ODBC's insane HELL No.....guess i'll create the way u have but i cn't see other fields besides Driver32 in ODBC's ?
i'll manually re-create the ODBC's u have given......plz assign them as fully correct so that i cn get going with it now :)

Dude,
I gave you the config file of my ODBC's. Not the registry format. Search for the file ODBC.ini and check if it matches what I gave. If anything is missing, then you need to add that in. This is a verification procedure not the registration procedure.

well guess i diddn't mention but i am using a diffrent zoneserver from other files(its 1.00 ateast thats whats writen after serverversion in SvrInfo) as i could not resolve the "ERROR:: [ITEM_PROVIDER] Init Fald" error in other Zoneservers (like i'm not the only one with this prob)....temme a way to correct this prob if possible....searching diddn't help cause all results i got said to check ODBC's (checked them many times with guide n they r not wrong for sure) and re-check the guide (all steps re-checked but stuck at one,i'll mention that in the end)

Now i was not able to edit the pasword already in a3serial login....i did add "dkdlxpawprhdnpc" as password but when i started a3serial again it had the previous pas (its a 10-char password),same password exists in sa login but my DB's (7770,8880,9990) r working with my ACCTUAL sa password........i tried to delete n create new a3serial with required password but got msg "
Error 21002: [SQL-DMO]User 'a3serial' already exists." n old a3serial re-appeared

help me sm one........still wonder how u ppl get ur servers up as i am too following same steps from the same guide :P

Do one thing. Go to A3ItemEvent>Logins and delete the "a3serial" from there and then make a new id by that name with that long password afresh.

Quote:

---

Originally Posted by iNs@nE

Do one thing. Go to A3ItemEvent>Logins and delete the "a3serial" from there and then make a new id by that name with that long password afresh.

---

HURRAY its working :poster_ss
So it wasn't the ODBC's after all just the way u need to go about stuff.....thx a mil Insane (btw do help me to diagnose furthur probs :P)

awe i got stuck at the same prob for which i started this thread....the ChreatChar,nothing happns after i log in n try to click CreateNewChar,cn this be due to the client i'm using,my client ver is 2.02,n i am also using 2.02 files or could this be the A3Client.exe,as i had used 127.0.01 loop-ip while hexing......plz ne body else has had this prob n got past it ?

4) make sure account server states "/// GATE 0: OK ///" when its starts up. If not, shut it down and start it over.

5) no matter how fast are your machine, give it a minute each time you start a service BEFORE starting the next one.

Quote:

---

Originally Posted by RudyMartin

4) make sure account server states "/// GATE 0: OK ///" when its starts up. If not, shut it down and start it over.

5) no matter how fast are your machine, give it a minute each time you start a service BEFORE starting the next one.

---

4)Account server did have "/// GATE 0: OK///" when it started

5)As for this one i do the follwing :
DB's : wait for 10sec after each DB's start
mainserver : wait till ten lines pas
accountserver : i again wait for 10 lines
zoneserver : after mainserver reaches 20 lines (cause i start this only after most lag ends)
battleserver : i finally start this if every thing seems working

......still having prob with Createnewchar option....cn it be client compadiblity or is it sm thing else....plz help sm one

You are facing a problem with your Zoneserver. It is not able to connect with th e rest. Are you using the 2.02 Zoneserver or the 2.05 one..?

Quote:

---

Originally Posted by iNs@nE

You are facing a problem with your Zoneserver. It is not able to connect with th e rest. Are you using the 2.02 Zoneserver or the 2.05 one..?

---

My zoneserver seems to be working fine.....n i'm using both 2.02 n 2.05 ( have them both in diffrent A3server folders,i rename the other while using the first)
n i'm getting same prob with both files version.......

I'll upload a Zoneserver.exe for you in a few hours. GIve it a shot with that..!!

i re-did the server again following the guides but still get same error in the end while creating a char ingame (i.e. Acc ERROR 1x1002 in the servers)....btw i'm using loop-ip in A3Client.exe,cn the prob be due to this ?
n cn sm one Hex me an A3Client.exe.....my LAN ip is 192.168.1.2
i'll be really thankful if ne one cn provide a solution to my porbs.....

I'll get it done for u..
You tried your best atleast..unlike most newbie's here..!!

Well i have sm screenies of the errors i get...
When i name the selected char n press ok nothing happns......after cmming back to desktop i get these error in Mainserver n Accountserver >>ImageShack - Hosting :: erroriz3.png

Screeny of my Battleserver >>ImageShack - Hosting :: battleserverrc4.png

Screeny of my Zoneserver when it starts (no error in zoneserver when this prob occurs)>>ImageShack - Hosting :: zoneserverstartyz8.png

plz tell if i need to provide ne more info or screeny about my prob i'll do so......plz help me find a solution to this problem

do the following.

use windows search under d:\a3server and look for *.txt,*.log files modified in the past few days. see if you can get a recent error message from those files.

btw, you can also do this: under odbc control panel, enable SQL TRACER, it will generate a C:\SQL.LOG file, but you can access it when the tracer is stopped.
It were usefull to me once to fix the friends problem.

btw UNCHECK the hold checkbox under 7770 if you want to see whats going on

Your first picture shows that your Account Server is not even defined to connect to the Zone Server. This we can say due to the lack of the Zone Verifying lines in the account server. You cannot connect these characters to the ZoneServer even after acquiring their data from the Account Server.

Your battleserver is running fine. All you need to do is get ItemCounter file from someone and paste it in your A3 Log folder.

The third one is the AGIT Manager error. Delete A3AgitOwnership file from your A3Log folder. This problem will be fixed...!!

Quote:

---

Originally Posted by iNs@nE

Your first picture shows that your Account Server is not even defined to connect to the Zone Server. This we can say due to the lack of the Zone Verifying lines in the account server. You cannot connect these characters to the ZoneServer even after acquiring their data from the Account Server.

Your battleserver is running fine. All you need to do is get ItemCounter file from someone and paste it in your A3 Log folder.

The third one is the AGIT Manager error. Delete A3AgitOwnership file from your A3Log folder. This problem will be fixed...!!

---

So whats the solution to first prob ?
i have now fixed the 2nd n the 3rd prob though....

Get a new account server..!!

Quote:

---

Originally Posted by iNs@nE

Get a new account server..!!

---

mind providing one here :smiley-go