[Guide] ODBC Registration

[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.

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\A3RcvResult]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="A3ItemEvent"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\A3SerialList]
"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\LocalServer]
"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]

dbmanage.rundb fail !!!

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]

yup

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]

hmm

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-05-server-guide-updated-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]

 

[iNs@nE]

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-05-server-guide-updated-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]

#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]

Re: ODBC Registration

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

 

[iNs@nE]

Re: ODBC Registration

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

 

[lexil]

Re: ODBC Registration

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

 

[iNs@nE]

Re: ODBC Registration

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

 

[ekoar]

Re: ODBC Registration

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]

Re: ODBC Registration

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..!!