Zone server - Init failed

[Abaya HK]

Hello All,

I am trying to setup A3 using SQL server 2008 R2 in my Win7, 64 bit machine.

Everything seems to be fine except for ZoneServer error - init failed.

I went through forum and I understood that the only issue that could cause this would be a3serial login. However, I did try creating it one more time and restarted my machine. I don't see any progress in that. I have attached the screenshots of my SQL security section and the error screenshot.

Please provide me your thoughts. I know this topic has been discussed many times, but I think I did all correct still Zoneserver error.

Kindly help.

Thanks.

 

[cyberinferno]

Hello All,

I am trying to setup A3 using SQL server 2008 R2 in my Win7, 64 bit machine.

Everything seems to be fine except for ZoneServer error - init failed.

I went through forum and I understood that the only issue that could cause this would be a3serial login. However, I did try creating it one more time and restarted my machine. I don't see any progress in that. I have attached the screenshots of my SQL security section and the error screenshot.

Please provide me your thoughts. I know this topic has been discussed many times, but I think I did all correct still Zoneserver error.

Kindly help.

Thanks.View attachment 142530View attachment 142531

Its clearly showing connection error. Check ODBC entries!

 

[Abaya HK]

Karthik,

It din't help. I tired everything again. Still I am getting the error. Might be something to do with Win 7 OS this is because the ODBC default folder in Xp and previous versions is"C:\\Program Files\\Common Files\\ODBC\\Data Sources".

However, Win 7, there is no folder path "C:\\Program Files\\Common Files\\ODBC\\Data Sources". So when we run the odbc.reg or copy paste the odbc reg files and run it, its not going to make any difference as there is no such path exists. The way I made 7770, 8880, 9990 and till account server run is, I manually entered DSN is using BDE as explained in the earlier forum page.

Need help in fixing the ODBC entries issue. Zone server still throwing me ConnectDB Error.

I am setting up the game in Win 7 64 bit OS.

 

[Abaya HK]

I made it work. Did few things to the ODBC.Reg file. My Zone server working fine now. In my experience, Zone server error can happen only for two reasons.

1) Your a3serial and the password is wrong. It did happen to me while copying there was a blank space and it created me some issues.
2) Your ODBC.Reg file. If you are making a3 server on Win7 32 or 64, then you need to change the => "DefaultDSNDir"="C:\\Windows\\System32" folder path.

====================================================================

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:\\Windows\\System32"

Ciao - Regards.

 

[Prot]

I feel good now.. I hate it when members just reply "Problem solved"

It helps others to solve similar issues.

Closing thread as the issue is resolved already.