Setting up server-Problems

[kb1991]

Hey can someone help me with the setting up the server.

i did the procedure as mention by suruchi in the post
http://forum.ragezone.com/f487/a3-server-219-files-episode-730848/

i am using windows 7 64 bit and SQL 2008

After making the server with exact steps i am facing the problem that my ports do not connect with the database ie. 7700, 8800 and 9900 even after making changes with ODBC.reg files as per

http://forum.ragezone.com/f98/borland-database-engine-win-7-a-755548/

and Running BDE
(i am uing trial version of BDE , If possible can someone give me the link of full version of BDE compatible with windows 7)

My main server, Zone server , account server , battle server and that new folder show error.
i think i am facing problem in connecting to DB. Is there any other way to connect to DB other than BDE?
i went on rz forums but couldnt come up with the possible solutions
can someone please point out where i could possibly go wrong.
Please can someone help me with this regard.
thanks in advance


Update: RECENTLY i have tried doing the work from scratch i managed to solve many problems. :

My ports do not connect to database ie 7770, 8880 and 9990

SOLVED: made fresh ODBC entries on the odbcad32 of A3Event,A3Friend etc etc...(C:\Windows\SysWOW64\odbcad32)

 

[Prot]

have u tried this one?

 

[kb1991]

have u tried this one?

Yes i did try it.. there seems to be some problem i am facing there too> it says download SQL which i did but still i get the same message

 

[ash.blackdevil]

Try the server installer in the releases section. I personally haven't tried it yet but heard it works for Win 7 64 bits.

 

[kb1991]

Try the server installer in the releases section. I personally haven't tried it yet but heard it works for Win 7 64 bits.

I have seen that .. As mentioned above i am getting some problems with the server installer of that releases section.

 

[kb1991]

Someone kindly try to help me please i would be obliged!

 

[chrissdegrece]

Help you with what, post some screenshots with errors.

 

[kb1991]

Updated main post :

Now this problem left
Problem left : Zone server Giving some errors. WARNING PET COUNTER IS NOT FOUND OK?

SOLVED: http://forum.ragezone.com/f98/petcounter-fand-ok-solve-670342/

and Event Item Connector: COnnect DB ERROR
ERROR:: [ ITEM_provider]Init Faild####
Load[] return #ERR=12
Note- i made a3serial properly with db owner ticked and ODBC entry is made Correctly!

i did same settings as in the post
http://forum.ragezone.com/f98/zoneserver-connectdb-error-740892/
Ps- i didnt get the part change ODBC manually. Some be kind enough to explain!
Same error in battle server!:thumbdown:
Attached the Screenshots of the problem!

 

[Prot]

are u using sql server 2005 or 2008?
as i remember.. setting db owner process in these sql server version is little different from sql 2000..
This error is db owner issue only.. Just google the correct procedure..

 

[kb1991]

i am using SQL 2008!! i am not able to actually figure out how to do it! Please help me regarding what to do!

 

[ash.blackdevil]

I'm unable to install BDE on win 7 64 bit. It says windows version is not compatible even when I run it in XP SP 2 mode. Please suggest me a solution to this problem. Or if possible tell me a version of BDE that can be installed on Win 7 64 bit.

 

[kb1991]

Search BDE windows 7 on google you will find it!

 

[lovbudy]

Have you tried running in compatablity mode on windows seven?

 

[kb1991]

i did! The problem i am FACING is only My ITEM event doesnt connect in ZS! rest everything is working fine!

 

[Gertrude73]

I'm unable to install BDE on win 7 64 bit. It says windows version is not compatible even when I run it in XP SP 2 mode.

 

[chrissdegrece]

Did you try google? Here is some info :

You must be registered to see links

 

[ash.blackdevil]

I had tried running the default BDE provided in Raman's files in all the compatibility modes available in Win 7, Still it didn't work. On Google too I had to spent 2-3 hrs to geta working BDE on my Windows.

But now I'm getting error while running ZS, It says 'Load Map 0 Fail'. I've changed the map index, replaced the map 0 file but still not able to get rid of this error.

With some different server files i'm getting 'ConnectDB Error'. I've already checked DB owner for A3ItemEvent in the security login for a3serial.

 

[kb1991]

Ash you using SQL 2008 if not which version?

 

[ash.blackdevil]

I'm using SQL 2005. I tried to install the server again on Win XP, Still got same error. I managed to remove it by deleting the key and ODBC entries and then remaking them again. I've tried same for Win 7 but it didn't work.

 

[kb1991]

For windows 7 64 bit you got to make changes in ODBC entries a bit as odbc entries gets saved in some syswow folder in windows folder.
http://forum.ragezone.com/f98/borland-database-engine-win-7-a-755548/

Search! is the keyword.