[Request] Need help Client error on start

09/28/2012 15:06 terra006#1
Client problem finxed but...now i got another one -.-" after i'm online i got DC after 5-10 sec...what can be the problem?

i got this in GameServer : [Only registered and activated users can see links. Click Here To Register...]

DBConnect :
Quote:
<%
Dim DBConnA, strConnectA
Set DBConnA = Server.CreateObject("ADODB.Connection")
strConnectA = "Provider=SQLOLEDB;Data Source=5.112.93.62;Initial Catalog=SRO_VT_ACCOUNT;user ID=sa;password=112233;"
DBConnA.Open strConnectA

%>
09/28/2012 17:43 turkplaya76#2
can you connect to DBConnect thru your browser ?
it should show a blank page
"yourip/DBConnect.asp"
09/28/2012 18:07 terra006#3
i get an white page when i do what you say ....... i use now hamachi it can be problem?
09/28/2012 23:15 youngvegas#4
Solution :

YOyoyo broski

The issue is your DBconnect and your ODBC and your DB itself

go into ur DB ur ODBC and your DBconnect

MAKE SURE ALL THE NAMES ARE MATCHING you will say they are but they're not

i'll help u step by step here

1.Go into Database go into security > logins > your login make sure sever roles are all ticked ( i think its sever mapping or roles idk but i think its roles )make sure in general ur default db is SRO_VT_Account go into server mapping tick (SRO_VT_Account SRO_VT_SHARD SRO_VT_SHARDLOG and in the bottom box tick db_owner and public for each of the DBs)
in ur ODBC u know wat to do its common sense if not then go to it and recheck it
09/29/2012 12:53 terra006#5
was a good one to check ODBC ^^ it was setted little wrong :)
but when i go in sql on login and try to make my SRO_VT_ACCOUNT how you said "db_owner and public" i got this error from sql...[Only registered and activated users can see links. Click Here To Register...]

Fixed Thx to Chernobyl <3:pimp: