A question regarding the .ini files in the cerstification folder

09/25/2012 19:53 fadyi#1

Certification* -___-
So I just want to know what do i type(replace) exactly in the ini files i am having trouble getting my server to work cause of a lost db connection (Cannot connect to the account DB) and a crap load of "cannot occupy dc stuff" that i have no idea how to fix... i have googled the error and searched here but found nothing useful..
P.S.
I donno if it matters but i am using SQL 2005

09/25/2012 20:10 A new hope#2

SRGlobalService.ini:
query=DRIVER={SQL Server};SERVER=SQLSERVERNAME or IP,port;DSN=ODBCNAME;UID=SQLUSERNAME;PWD=SQLPW;DATABASE=ACCOUNTDBNAME

Example:

Code:

[global]
count=1
[entry0]
operation_type=18
name=SRO_Global_TestBed
query=DRIVER={SQL Server};SERVER=10.10.111.2,14331;DSN=SilkroadOnline;UID=jmx_sro_acc_web;PWD=dlwpqkRnfEorkehlwldksgdkssk~?;DATABASE=SilkroadOnline
global_manager_node_id=1100

Code:

[global]
count=1
[entry0]
operation_type=38
name=SRO_Thailand_Official
query=DRIVER={SQL Server};SERVER=.\SQLEXPRESS;DSN=Account;UID=sa;PWD=1234qwe;DATABASE=BR_AccountTest_new
global_manager_node_id=994

09/25/2012 20:14 fadyi#3

Quote:

Originally Posted by A new hope

SRGlobalService.ini:
query=DRIVER={SQL Server};SERVER=.\SQLExpress;DSN=ODBCNAME;UID=SQLUSERNAME;PWD=SQLPW;DATABASE=ACCOUNTDBNAME

Well my friend set up the server for me soo whats the ODBCNAME :( and the Account DB name is the one i connect w/ in the SQL :$ ? or the SRO_VT_ACCOUNT ? or what ?

09/25/2012 20:21 A new hope#4

Quote:

Originally Posted by fadyi

Well my friend set up the server for me soo whats the ODBCNAME :( and the Account DB name is the one i connect w/ in the SQL :$ ? or the SRO_VT_ACCOUNT ? or what ?

SRO_VT_ACCOUNT is the account DB name.

Check the ODBC name in Control panel, administrative tools, data sources (ODBC).

09/25/2012 20:30 fadyi#5

Quote:

Originally Posted by A new hope

SRO_VT_ACCOUNT is the account DB name.

Check the ODBC name in Control panel, administrative tools, data sources (ODBC).

I found it,it got like 7 tabs so uhmmm the system DSN is the one that got the name.... which is SRO_VT_ACCOUNT too O_O
here is what i got in globalservice
[global]
count=1
[entry0]
operation_type=22
name=SRO_Vietnam_TestLocal
query=DRIVER={SQL Server};SERVER=*********\****;DSN=SRO_VT_ACCOUNT;U ID=ID;PWD=123456;DATABASE=SRO_VT_ACCOUNT
global_manager_node_id=697

09/25/2012 20:39 A new hope#6

Quote:

Originally Posted by fadyi

I found it,it got like 7 tabs so uhmmm the system DSN is the one that got the name.... which is SRO_VT_ACCOUNT too O_O

Then type DSN=SRO_VT_ACCOUNT in certification.

09/25/2012 20:45 fadyi#7

Quote:

Originally Posted by A new hope

Then type DSN=SRO_VT_ACCOUNT in certification.

I did... what do i exactly type in the SrShard .__.

09/25/2012 20:49 A new hope#8

Quote:

Originally Posted by fadyi

I did... what do i exactly type in the SrShard .__.

Shard and Log DB info. (like in srglobalservice, but shard and log db name and odbc name)

09/26/2012 00:24 fadyi#9

Quote:

Originally Posted by A new hope

Shard and Log DB info. (like in srglobalservice, but shard and log db name and odbc name)

Thanks. Its fixed now :)
#Request to close.

09/28/2012 23:21 youngvegas#10

Dude fady ask me in skype these douches don't know anything >.>