[GUIDE] Setup a server without errors [1x GameServer]

10/10/2011 15:33 _HouseMusicx3#451
Quote:
Originally Posted by Striker900 View Post
almost there guys one more thing XD

What's

Now edit DBConnect.asp like this:
Quote:
<%
Dim DBConnA, strConnectA
Set DBConnA = Server.CreateObject("ADODB.Connection")
strConnectA = "Provider=SQLOLEDB;Data Source=YOURPCNAME\SQLEXPRESS;Initial Catalog=SRO_VT_ACCOUNT;user ID=sa;password=your password;"
DBConnA.Open strConnectA

%>

Where can I find DBconnect? in internet information ISS Manager?
[Only registered and activated users can see links. Click Here To Register...]

its located in the folder as u can see on the screen
10/10/2011 15:44 Striker900#452
Somehow I cant get my yourip:8080 working but is it important to install firezilla? What do I gonna do with that? I dont wanna open a reg page or something.
10/10/2011 15:47 _HouseMusicx3#453
Quote:
Originally Posted by Striker900 View Post
Somehow I cant get my yourip:8080 working but is it important to install firezilla? What do I gonna do with that?
use the IP that u get via cmd (IPv4)
10/10/2011 15:56 Striker900#454
Quote:
Originally Posted by _HouseMusicx3 View Post
use the IP that u get via cmd (IPv4)
I did it still doesnt work did everything as on the pictures.

But is it a important step to make the server work or?

ATM I did EVERYTHING except to get that host working, do you think I could still open the game?
10/10/2011 17:27 xFlyer#455
Why GM doesn't work with Hamachi? Can't even log-in. Tried both ip's 192.168.x.x and hamachi, didn't worked.
10/10/2011 17:54 playboll#456
2011-10-10 18:43:42 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-10-10 18:43:42 [FarmManager] server cord established : 11 (5.168.10.99:60006)
2011-10-10 18:43:42 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-10-10 18:43:42 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-10-10 18:43:42 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-10-10 18:43:42 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-10-10 18:43:42 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-10-10 18:43:42 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-10-10 18:43:42 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-10-10 18:43:42 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-10-10 18:43:42 [SR_ShardManager] server cord established : 1 (5.168.10.99:15882)
2011-10-10 18:45:35 [SR_ShardManager] SR_ShardManager is initialized successfully
2011-10-10 18:45:36 [SR_ShardManager] BillingServer is Dead!!

SR_SHARDMANAGER closing help me guys,
10/10/2011 19:00 xFlyer#457
Your billing is dead. If I can remember well you have to fix your IIS DB config.
10/10/2011 19:03 playboll#458
My pc home basic win7 64 bit. i cant using IIS .s
10/10/2011 19:25 katour#459
SROLAN SERVER CHECK HELP ME :rtfm:
10/10/2011 20:01 pakkux#460
How to change machine manager connecting ip or something.
10/10/2011 20:06 bO_#461
Could someone help me?
[Only registered and activated users can see links. Click Here To Register...]

It appears when I try to restore the DB.
10/10/2011 21:36 omegalugia#462
nvm, fixed it :)
10/10/2011 22:02 bO_#463
got a new problem :-/
[Only registered and activated users can see links. Click Here To Register...]
10/10/2011 22:07 octage#464
Any solution: :confused:

[Only registered and activated users can see links. Click Here To Register...]

PS: The server worked very good with hamachi, now I changed the server.cfg, and ini IP to my router IP ( 192.168.xx.x ), and at the sro, I patched the division info to connect to my Ext. IP: 188.xx.xxx.xx and than to 192.168.xx.xxx and than to 127.0.0.1, non of them worked.... the sro starts, acsually look at the printscreen, that's my problem.
I get this in the SR_ShardManager window:
Query Error!!! Query Result : -1, Query : {?=CALL _AddNewChar (1417, 1911,'Test',51,25256,960.000000,20.000000,420.0000 00,2094,3643,3644,3645,3632,10886,39,39,39,62,46,0 )}
SQL Error State:23000, Native Error Code: 223, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The INSERT statement conflicted with the FOREIGN KEY constraint "FK__Inventory__Items". The conflict occurred in database "SRO_VT_SHARD", table "dbo._Ite
{?=CALL _AddNewChar (1417, 1911,'Test',51,25256,960.000000,20.000000,420.0000 00,2094,3643,3644,3645,3632,10886,39,39,39,62,46,0 )}
SQL Error State:01000, Native Error Code: E25, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
{?=CALL _AddNewChar (1417, 1911,'Test',51,25256,960.000000,20.000000,420.0000 00,2094,3643,3644,3645,3632,10886,39,39,39,62,46,0 )}
Failed To execute _AddNewChar ! [jid: 1417, odbc err: -1]
Failed To create new character! [jid: 1417, error code: 0]


And I have 1more question: how can I loggin with the luncher, not with the edx loader? Cuz when I start the luncher, it says: "The server is undergoing inspection, etc.... ".

Thx for anyone who helps me with my problems.
10/11/2011 04:50 kontroversy#465
Hello,

Good guide, and instructions. I am having a few issues however. I have set everything up, everything starts. But some of the servers are gray? And I have red lights in SMC. When I launch client and connect I get offline error. Do you know what it could be?

[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]