Shard Manager Error :/ Help!

11/10/2011 05:01 takeshix16#1

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

If u can see when I start shard manager fot that error :P DB error :/ I checked codes and they're all good see:

[global]
count=1
[entry0]
id=64
global_operation_id=20
operation_type=22
name=FantasySilroad
query=DRIVER={SQL Server};TAKESHI-PC\SQLEXPRESS;DSN=SRO_VT_SHARD;UID=***;PWD=******; DATABASE=SRO_VT_SHARD
query_log=DRIVER={SQL Server};TAKESHI-PC\SQLEXPRESS;DSN=Log_DB;UID=***;PWD=******;DATABA SE=Log_DB
capacity=1000
shard_manager_node_id=705
u1=240
u2=208
u3=17
u4=1
u5=0
u6=0
u7=0

any solution?

02/23/2012 10:46 abadedoao#2

i have same proplem :(

02/23/2012 11:04 Dr.Abdelfattah#3

look again at those lines

PHP Code:


			
query=DRIVER={SQL Server};TAKESHI-PC\SQLEXPRESS;DSN=SRO_VT_SHARD;UID=***;PWD=******;  DATABASE=SRO_VT_SHARD
query_log=DRIVER={SQL Server};TAKESHI-PC\SQLEXPRESS;DSN=Log_DB;UID=***;PWD=******;DATABA  SE=Log_DB

completely wrong
change them to

PHP Code:


			
query=DRIVER={SQL Server};SERVER=TAKESHI-PC\SQLEXPRESS;DSN=SRO_VT_SHARD;UID=***;PWD=******;DATABASE=SRO_VT_SHARD
query_log=DRIVER={SQL Server};SERVER=TAKESHI-PC\SQLEXPRESS;DSN=Log_DB;UID=***;PWD=******;DATABASE=Log_DB

and i suggest to change ur Log_DB name to SRO_VT_SHARDLOG or change SRO_VT_SHARDLOG at stored procedures .
Edit : i think this thread is outdated !

02/27/2012 18:05 Trabto#4

[global]
count=1
[entry0]
id=64
global_operation_id=20
operation_type=22
name=FantasySilroad
query=DRIVER={SQL Server};SERVER=TAKESHI-PC\SQLEXPRESS;DSN=SRO_VT_SHARD;UID=***;PWD=******; DATABASE=SRO_VT_SHARD
query_log=DRIVER={SQL Server};SERVER=TAKESHI-PC\SQLEXPRESS;DSN=Log_DB;UID=***;PWD=******;DATABA SE=Log_DB
capacity=1000
shard_manager_node_id=705
u1=240
u2=208
u3=17
u4=1
u5=0
u6=0
u7=0