[iNs@nE]

Numerous number of problems being faced by you people are because of the wrong ODBC's. I hope this one helps or atleast minimize your problems.

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"="(local)" "Database"="FriendDB" "LastUser"="sa" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\A3RcvRes ult] "Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll" "Server"="(local)" "Database"="A3ItemEvent" "LastUser"="sa" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\A3Serial List] "Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll" "Server"="(local)" "Database"="A3ItemEvent" "LastUser"="sa" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\EventA3] "Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll" "Server"="(local)" "Database"="ASD" "LastUser"="sa" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\FriendDB] "Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll" "Server"="(local)" "Database"="HSDB" "LastUser"="sa" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\HSDB] "Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll" "Server"="(local)" "Database"="HSDB" "LastUser"="sa" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\LETTERDB] "Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll" "Server"="(local)" "Database"="FriendDB" "LastUser"="sa" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\LocalSer ver] "Description"="" "Server"="(Local)" "Trusted_connection"="" "UseProcForPrepare"="Yes" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\Login202] "Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll" "Server"="(local)" "Database"="ASD" "LastUser"="sa" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\NEWASD] "Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll" "Server"="(local)" "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="(local)"

Yes, there are a few unwanted spaces included in the registry. Unable to change them due to forum restrictions. Please make the following changes before moving ahead.
1. Change A3RcvRes ult to A3RcvResult
2. Change A3Serial List to A3SerialList
3. Change LocalSer ver to LocalServer

Registering Your ODBC's:

This is the complete ODBC's registry needed for the running A3 Server Version 2.02
You need to repleace (local) with the name of your Server.
For those who do not know where to find this, you could open "Service Manger" and get the name from there.

All you need to do is copy and paste this in a notepad and save the file to "ODBC.reg" and then double click it. It will ask you if you want to register them to your registry.
Click OK.

Congratulations! You have successfully registered your ODBC's.

Verifying your ODBC's:
Open Control Panel>Administrative Tools>Data Sources (ODBC)
Go to SystemDSN tab.
Click on the ODBC you registered and then press "Configure"
Then check if your server name and the Name of the ODBC is correctly written.
In the next step, select SQL Authentication and enter your SA Password.
Then check if the default database is set to what is mentioned in the above registry.
Then make sure "Perform Translation for character data" is ticked and click Next.
Then Test Data Source. It should say "Test Completed Successfully"

NOTE: Do not forget that you have to first setup and restore your databases in Enterprise Manager. Why do I have to do this first?
Thats because you are directing them to take data from the databases.

[trixter]

dude i set up my whole odbc once again coz comp crashed :(( But nw i get tat dbmanage error !! searched forums but dint find specific answer as to wts causing prblm ! Everything else is running fine !! I had posted this problem but tat time i had changed some maps and this problem had been solved but now i m not gettin as to wats wrong coz everything installed is new !!

[iNs@nE]

did you install Borland's Database Engine..?

[trixter]

yup i did install BDE !! Still same old problem !!!

[iNs@nE]

Did you restore all your databases correctly..?
And check your mainserver's svrinfo.ini to check if you properly directed the database sources..!!

[trixter]

all databases were restored !!!
Tis is my svrinfo.ini

#Main Server Info.
[SvrInfo]
#Server ID Number
WorldIndex=23
#World Name
WorldName=ECLIPSE

#Main Server information
ThisServerIP=127.0.0.1 //ip wan o lan
ThisServerPort=7789

#ASD Middlware Info. to connect
CharacDBServerNum=1
CharacDBIP=127.0.0.1//ip wan o lan
CharacDBPort=8880
StorageDBServerNum=1
StorageDBIP=127.0.0.1 //ip wan o lan
StorageDBPort=9990

#WGS setting
WGSIP=127.0.0.1 //ip wan o lan
WGSPORT=9017


#World Info.
ZoneServerNum=3
BattleServerID=1
#[SvrInfo]
;GameLogServerIP=127.0.0.1 //ip wan o lan
;GameLogServerPort=8000

#Map count
MaxMap=26

[MapZone]
Map0=0
Map1=0
Map2=0
Map3=0
Map4=0
Map5=0
Map6=0
Map7=0
Map8=0
Map9=0
Map10=0
Map11=0
Map12=0
Map13=0
Map14=0
Map15=0
Map16=0
Map17=0
Map18=0
Map19=0
Map20=0
Map21=0
Map22=0
Map23=1
Map24=0
Map25=0

[ODBC]
ODBCNAME=FriendDB
ODBCID=sa
ODBCPASS=12345

[Update Log Info]
ClanPath=c:\a3\Clan
LogPath=c:\a3\Clan\LOG

[Clan Web DB Info]
SourceName=ASD
UserName=sa
PassWd=12345

[ClanInfo]
;bInitNameTable=1
;nSaveClanLog=1

[HSDB]
ODBCNAME=HSDB
ODBCID=sa
ODBCPASS=12345

[iNs@nE]

Change your world index to zero bcoz from your previous posts I notice that you are using all 0 files and not 23 unless you wish to change them now.
And check if your databases are restored properly.
Try restoring them again.
If the same problem persists, then obtain a new set of databases.
If possible get the ones which are in the raw form and not the file form.
Once you get them, use the query analyzer to restore them.

[trixter]

Hey insane i deleted everything and again went thro the whole procedure making the server again !!! Thnz a lot to this guide http://forum.ragezone.com/a3/2-02-2-...ed-150577.html !!! No errors nothing but some problems ve come dono its coz of problem wit server files or i ve made some mistake !!!
First when i run mainserver - get rundb k [127.0.0.1 , 8880 ] ok the same comes for 9990 ! should i ve an ok for 7770 coz it nevr cmes !!!

Second - In zonserver warning pet counter is not found ! ok ?
Other tan this its working fine !!!
The other 1 problem i m facing is after i select my character it goes to the loading screen and is stuck forever !!
Is this "stuck forever " server files problem ?

[trixter]

lolz no clue as to how i got thro the loading screen but i checkd my mainserver window after login in and saw this error -http://img99.imageshack.us/my.php?image=letterdnsl5.jpg

[trixter]

ImageShack - Hosting :: letterdnsl5.jpg

[iNs@nE]

Originally Posted by trixter

Hey insane i deleted everything and again went thro the whole procedure making the server again !!! Thnz a lot to this guide http://forum.ragezone.com/a3/2-02-2-...ed-150577.html !!! No errors nothing but some problems ve come dono its coz of problem wit server files or i ve made some mistake !!! First when i run mainserver - get rundb k [127.0.0.1 , 8880 ] ok the same comes for 9990 ! should i ve an ok for 7770 coz it nevr cmes !!! Second - In zonserver warning pet counter is not found ! ok ? Other tan this its working fine !!! The other 1 problem i m facing is after i select my character it goes to the loading screen and is stuck forever !! Is this "stuck forever " server files problem ?

First of all you LetterDB problem.
This is occuring coz your ASD or Clan databases do not contain the table of LetterDB which works for the messaging system.

As for the petcounter, I uploaded the one for "0" index servers sometime in the recent past. Download that and paste it in your A3 Log folder. It will solve your problem.

And one more thing, your chars are not loading as you are indicating the wrong ODBC Registry to try and retrieve the information from the Databases.
Make sure the ODBC registered in 7770 is Login202 and 8880, 9990 is NEWASD.

Your other problem is pretty unclear. Please try and explain more clearly..!

[zaugola]

Originally Posted by trixter

#WGS setting WGSIP=127.0.0.1 //ip wan o lan WGSPORT=9017

try change this setting to like this

#WGS setting
WGSIP=127.0.0.1 //ip wan o lan
WGSPORT=7770

this port should direct to ur account port....

and change this also...

[ODBC]
ODBCNAME=FriendDB to LETTERDB
ODBCID=sa
ODBCPASS=12345

so it would look like this.....

[ODBC]
ODBCNAME=LETTERDB
ODBCID=sa
ODBCPASS=12345

hope it work, cos im having the same prob with u n went through all the programme flows just to figure it out.....

[Legendary]

Make sure both the ports on Zoneagent and Mainserver match. Also you can use FriendDB or LETTERDB. As long as the correct tables are inside and Mainserver can detect them.

The loading screen stuck problem is due to your client or server NOT being able to connect to the other servers. It should sa /// GATE: OK //// in the Zoneserver console. Start your Zoneserver more slowly next time about 1 minute between Mainserver and Accountserver and 2 minutes between Zoneserver if you lack the system resources.

[iNs@nE]

As Zagoula said, do not change your port to 7770 unless your comp can support multiple ports. The only PC's in the whole world that can do that is the Alienware. 7770 is already used for running the databases.

[lexil]

cant find Admintriv Tools :S plz send me a image link on this

[iNs@nE]

Switch to Classic View if your's is not..!!

[lexil]

K but my computer is dutch so dont know which one and the pictures of the programs arent the same >.<

[iNs@nE]

Post a screenshot of your control panel. I'll mark out which one..!!

[ekoar]

hi i changed the 8880 to NEWASD but still stuck at char creation..
hers my svrino.ini frm the mainserver directory..
help me.


#Main Server Info.
[SvrInfo]
#?

[iNs@nE]

Did you install Borland's Database Engine..? Without this you cannot access the databases..!!

And did you create the 1000 directories in teh account section and also set teh correct location in the account server svrinfo.ini file..? If not do that first. You need to create the 0-999 folders and then set the correct location of that and the LOG..!!
Preferrably on the D drive to avoid problems in the future..!!

[ekoar]

yes i have BDE installed and have created the 1000 directories..
but still and wid the files i use..
ther is already a chracter Akaruz in the Akaruz id...
i tried logging in wid that char and still it gives
Acc Error 0x1001
Click OK to exit program
wid other ids i cant even create a char...
If u know Hades server had this prob in between wherin i cudnt login wid my char and used to get the same error..there used to be a problem wid the storage boxes too along wid this error and not all IDs were affected...
any suggestions.. ?

[iNs@nE]

The Akaruz character wont log-on on your system as there is no information regarding that char in the charac0 table. Thats why the error..

Check your ODBC's once again. See if the NEWASD has been linked properly..!!

[zaugola]

Originally Posted by ekoar

#WGS setting WGSIP=127.0.0.1 WGSPORT=9017 <--- change this according to tdb.ini in 7770 folder

are you sure your tdb.ini in 7770 folder using 9017 port? if no, then u need to change 9017 to 7770, that should solve the prob about the account.

Originally Posted by ekoar

[Clan Web DB Info] SourceName=ASD <--- if u r using ODBC from Insane, this should be A3ASD UserName=sa PassWd=sa

verify ur ODBC......

stuck at loading screen? pls wait at least 2 mins b4 executing each server.... n make sure u see something like this when u executed zoneserver :-

/////////// GATE OK = 0 ///////////

[ekoar]

hmmm... wont changing that to 7770 conflict wid the ASD7770.exe ?? and abt Clan Web DB..i have no DB registered for A3ASD ( or linked)...
tho' i trid all this and still im stuck at char creation...
i get GATE OK everywhere frm main server to zoneserver to battleserver...

PS : THE 8880ASD.EXE OPENS UP A BLANK frmDEBUG WINDOW WHN I TRY TO CREATE A CHAR...Y IS IT BLANK ?..IT DOESNT EVEN SAVE ANY LOGS AFTER TICKING THE 'SAVE TO LOGS'..
I GET A Acc Error 0x1002 IN THE MAINSERVER AND ACCNT SERVER WINDOWS...( NOT I NZONESERVER)
PLZ HELP ME...I TRIED RE-DOING THE SERVER FRM SCRATCH..USED DIFF FILES....MIXED FILES...BUT STILL I GET THIS ERROR...

[zaugola]

actually it will not conflict with the asd 7770, in fact.... it will detect ur accont weather it is available or not.... which mean mainserver.exe will listen to the 7770 port

if u set 7770db.exe to established 7770 port n ur mainserver.exe/accountserver.exe will listen to 9017 port, then how ur main server.exe or accountserver.exe will function correctly?

so ur mainserver.exe need to intact with ur ASD db through this port..... n also with ur accountserver.exe

as for the odbc A3ASD, better u should follow Ins@ne guide, i think he is more detail on how to register ODBC. follow his guide on ODBC if u din understand Legendary or akaruz guide...

n just like rudy said, it doesnt mean ur server functioning correctly even though u manage to run it....

better check ur port n ur ODBC again.....