db connection failed!

01/30/2015 02:42 R4dioactive™#1
can anyone solve it for me?
screenshot ::> [Only registered and activated users can see links. Click Here To Register...]
dbconnect/shard (ini files) and server.cfg 100% right.
so, where is the problem?
01/30/2015 08:22 ​Exo#2
Maybe the webserver isn't on?
01/30/2015 08:34 asanoftw#3
bro if you told me it's 200% right,

THE PROBLEM CAMES FROM [ini files] [server.cfg]

check them well,
01/30/2015 11:14 Dunarsund#4
it can be the billing server too. Check the DBConnect file in iis.
01/30/2015 12:13 Zodiao#5
Quote:
Originally Posted by Dunarsund View Post
it can be the billing server too. Check the DBConnect file in iis.
Quote:
Originally Posted by xExorcist View Post
Maybe the webserver isn't on?
Quote:
Originally Posted by asanoftw View Post
bro if you told me it's 200% right,

THE PROBLEM CAMES FROM [ini files] [server.cfg]

check them well,
Nope, it can't be
it's srShard.ini ONLY.


server.cfg is the certifier ONLY, whatever you put in there as long as it's the right IP won't cause any error.
and we all know what billing server does(DBConnect.asp)
01/30/2015 13:40 R4dioactive™#6
srGlobalService.ini
PHP Code:
[global]
count=1
[entry0]
operation_type=22
name=Syndicate
query=DRIVER={SQL Server};SERVER=SYNTHETICAL-PC\SQLEXPRESS;DSN=SRO_VT_ACCOUNT;UID=sa;PWD=123456;DATABASE=SRO_VT_ACCOUNT
global_manager_node_id=697 
srShard.ini
PHP Code:
[global]
count=1
[entry0]
id=64
global_operation_id=20
operation_type=22
name=Syndicate
query=DRIVER={SQL Server};SERVER=SYNTHETICAL\SQLEXPRESS;DSN=SRO_VT_SHARD;UID=sa;PWD=123456;DATABASE=SRO_VT_SHARD
query_log=DRIVER={SQL Server};SERVER=SYNTHETICAL\SQLEXPRESS;DSN=SRO_VT_LOG;UID=sa;PWD=123456;DATABASE=SRO_VT_LOG
capacity=100
shard_manager_node_id=705
u1=240
u2=208
u3=17
u4=1
u5=0
u6=0
u7=0 
DBConnect.asp
PHP Code:
<%
Dim DBConnA, strConnectA
Set DBConnA = Server.CreateObject("ADODB.Connection")
strConnectA = "Provider=SQLOLEDB;Data Source=SYNTHETICAL-PC\SQLEXPRESS;Initial Catalog=SRO_VT_ACCOUNT;user ID=sa;password=123456;"
DBConnA.Open strConnectA

%> 
so, where is the problem?
01/30/2015 16:08 Justin1337*#7
Quote:
Originally Posted by R4dioactive™ View Post
srGlobalService.ini
PHP Code:
[global]
count=1
[entry0]
operation_type=22
name=Syndicate
query=DRIVER={SQL Server};SERVER=SYNTHETICAL-PC\SQLEXPRESS;DSN=SRO_VT_ACCOUNT;UID=sa;PWD=123456;DATABASE=SRO_VT_ACCOUNT
global_manager_node_id=697 
srShard.ini
PHP Code:
[global]
count=1
[entry0]
id=64
global_operation_id=20
operation_type=22
name=Syndicate
query=DRIVER={SQL Server};SERVER=SYNTHETICAL\SQLEXPRESS;DSN=SRO_VT_SHARD;UID=sa;PWD=123456;DATABASE=SRO_VT_SHARD
query_log=DRIVER={SQL Server};SERVER=SYNTHETICAL\SQLEXPRESS;DSN=SRO_VT_LOG;UID=sa;PWD=123456;DATABASE=SRO_VT_LOG
capacity=100
shard_manager_node_id=705
u1=240
u2=208
u3=17
u4=1
u5=0
u6=0
u7=0 
DBConnect.asp
PHP Code:
<%
Dim DBConnA, strConnectA
Set DBConnA = Server.CreateObject("ADODB.Connection")
strConnectA = "Provider=SQLOLEDB;Data Source=SYNTHETICAL-PC\SQLEXPRESS;Initial Catalog=SRO_VT_ACCOUNT;user ID=sa;password=123456;"
DBConnA.Open strConnectA

%> 
so, where is the problem?
Add me on skype, i'll take a look. justinbw1990
01/30/2015 20:58 asanoftw#8
gimme your Database names, i bet it's different than ini's