Register for your free account! | Forgot your password?

Go Back   elitepvpers > Popular Games > Silkroad Online > SRO Private Server
You last visited: Today at 12:27

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



Can't connect to account DB

Discussion on Can't connect to account DB within the SRO Private Server forum part of the Silkroad Online category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Oct 2010
Posts: 8
Received Thanks: 0
Exclamation Can't connect to account DB

I have this really annoying problem with GlobalManager. If u have any suggestions, please help

cannot occupy db session : select * from SK_SilkChange_BY_Web
cannot occupy db session : update _Shard set nStatus = 0, nCurrentUserRatio = 0 where nID = 64




DBConnect
PHP Code:
<%
Dim DBConnAstrConnectA
Set DBConnA 
Server.CreateObject("ADODB.Connection")
strConnectA "Provider=SQLOLEDB;Data Source=MOTAZ-HP\SQLEXPRESS;Initial Catalog=SRO_VT_ACCOUNT;user ID=sa;password=pw123;"
DBConnA.Open strConnectA

%> 

srGlobalService
PHP Code:
[global]
count=1
[entry0]
operation_type=22
name
=SRO_Vietnam_TestLocal
query
=DRIVER={SQL Server};SERVER=MOTAZ-HP\SQLEXPRESS;DSN=SRO_VT_ACCOUNT;UID=sa;PWD=pw123;DATABASE=SRO_VT_ACCOUNT
global_manager_node_id
=697 

srNodeType
PHP Code:
[global]
count=1
[entry0]
id=335
operation_type
=22
name
=SRO Vietnam TestLocal
wip
=192.168.0.14
nip
=192.168.0.14
machine_manager_node_id
=699 

srShard
PHP Code:
[global]
count=1
[entry0]
id=64
global_operation_id
=20
operation_type
=22
name
=SROinfo
query
=DRIVER={SQL Server};SERVER=MOTAZ-HP\SQLEXPRESS;DSN=SRO_VT_SHARD;UID=sa;PWD=pw123;DATABASE=SRO_VT_SHARD
query_log
=DRIVER={SQL Server};SERVER=MOTAZ-HP\SQLEXPRESS;DSN=SRO_VT_LOG;UID=sa;PWD=pw123;DATABASE=SRO_VT_LOG
capacity
=1000
shard_manager_node_id
=705
u1
=240
u2
=208
u3
=17
u4
=1
u5
=0
u6
=0
u7
=
Zarlex is offline  
Old 05/17/2013, 07:54   #2
 
zikor1337's Avatar
 
elite*gold: 0
Join Date: Mar 2010
Posts: 2,667
Received Thanks: 1,886
So simple, so obvious .

The mistake is on "srGlobalService" and "srShard".

Replace "SERVER=MOTAZ-HPSQLEXPRESS" with "SERVER=MOTAZ-HP\SQLEXPRESS"

Recompile your certification and start it .

Enjoy .
zikor1337 is offline  
Old 05/18/2013, 00:46   #3
 
elite*gold: 0
Join Date: Oct 2010
Posts: 8
Received Thanks: 0
Quote:
Originally Posted by zikor1337 View Post
So simple, so obvious .

The mistake is on "srGlobalService" and "srShard".

Replace "SERVER=MOTAZ-HPSQLEXPRESS" with "SERVER=MOTAZ-HP\SQLEXPRESS"

Recompile your certification and start it .

Enjoy .
They actually are "SERVER=MOTAZ-HP\SQLEXPRESS". I have no idea why the slashes weren't copied. I'll fix them in the post.


.. for some reason I can't fix them, like when I press edit they are in the text! Just ignore the [\]'s, they're in the ini
Zarlex is offline  
Old 05/18/2013, 10:30   #4
 
zikor1337's Avatar
 
elite*gold: 0
Join Date: Mar 2010
Posts: 2,667
Received Thanks: 1,886
Anyway, the problem is in there, somewhere . And it is something simple .. a mistake .
zikor1337 is offline  
Old 05/18/2013, 21:53   #5
 
elite*gold: 0
Join Date: Oct 2010
Posts: 8
Received Thanks: 0
I doubt it's in any of the ini files, I checked them several times!
Zarlex is offline  
Reply


Similar Threads Similar Threads
Can't Connect to Account DB NEED HELP ;/
05/25/2012 - SRO Private Server - 3 Replies
Dudes, help me. I lounch Global and i got error like in this picture... I checked my ini files and i think its good:// Pls help me abit detailed how to fix it. p.s who had that problem? and how did ya fixed.... http://i40.tinypic.com/1z6dys6.png http://i44.tinypic.com/260albd.jpg Help me guys :///
Help| When im try to connect my account
04/18/2012 - Grand Chase - 2 Replies
When im try to connect my account its write me Wrong Password or Server is off how i can fix that? and no 1 hacked my account cus my last connection write on my guild.
Can't Connect to Account DB - NEED HELP!!!@!
01/10/2012 - SRO Private Server - 5 Replies
Dudes, help me. I lounch Global and i got error like in this picture... I checked my ini files and i think its good:// Pls help me abit detailed how to fix it. p.s who had that problem? and how did ya fixed.... http://i40.tinypic.com/1z6dys6.png Guys sorry for the second theard it was an missclick. Delete one my theard. http://i44.tinypic.com/260albd.jpg
Connect DB connect connection refused HILFE!
02/27/2011 - Metin2 Private Server - 4 Replies
Ich habe mir einen server mit 2 Channels erstellt und beim starten kommt immer dieser fehler -.- in navicat hab ich versucht alle tabellen zu reparieren, aber bei information_shema kommt acces diened Bild: http://img825.imageshack.us/i/picturers.jpg/ Server startet und kann mich auch einloggen



All times are GMT +1. The time now is 12:27.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.