db connection failed!

R4dioactive™ · 01/30/2015, 02:42

can anyone solve it for me?
screenshot ::>

dbconnect/shard (ini files) and server.cfg 100% right.
so, where is the problem?

Exo · 01/30/2015, 08:22

Maybe the webserver isn't on?

~~asanoftw~~ · 01/30/2015, 08:34

bro if you told me it's 200% right,

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

check them well,

Dunarsund · 01/30/2015, 11:14

it can be the billing server too. Check the DBConnect file in iis.

Zodiao · 01/30/2015, 12:13

Quote:

Originally Posted by Dunarsund

it can be the billing server too. Check the DBConnect file in iis.

Quote:

Originally Posted by xExorcist

Maybe the webserver isn't on?

Quote:

Originally Posted by asanoftw

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)

R4dioactive™ · 01/30/2015, 13:40

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?

Justin1337* · 01/30/2015, 16:08

Quote:

Originally Posted by R4dioactive™

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

~~asanoftw~~ · 01/30/2015, 20:58

gimme your Database names, i bet it's different than ini's