[Help] ERROR:SQLConnect Failed ERROR:User db open failed
Anyone can help me this?
Code:
Service Provider:CHINACreateIoCompletionPort OKINFO:SQL_ATTR_CONNECTION_POOLING OKINFO:SQLAllocHandle OKERROR:SQLConnect FailedERROR:User db open failed== Please wait until server stop Stop IOCPStop Message QueueStop DataBaseStop CFG=======================================================Server Stop OK=======================================================INFO:SQL_ATTR_CONNECTION_POOLING OKINFO:SQLAllocHandle OK
correct me if I'm wrong Svr_Session_0
Code:
// //////////////////////////////////////////////////////////////////////////////Session server cfg file// ////////////////////////////////////////////////////////////////////////////server_version 1 patch_version 1 server_name ServerSession server_max_client 200server_ip 127.0.0.1server_service_port 5003 server_control_port 2001 service_provider 3max_thread 3server_type 2server_group 0 server_number 0 //use_event_thread 1// ////////////////////////////////////////////////////////////////////////////// ODBC user database setting value user_odbc_name RanUseruser_odbc_user sauser_odbc_pass peksmanuser_odbc_database RanUser user_odbc_pool_size 5 user_odbc_response_time 10 // ////////////////////////////////////////////////////////////////////////////// log database setting value log_odbc_name RanLog log_odbc_user sa log_odbc_pass peksmanlog_odbc_database RanLog log_odbc_pool_size 5 log_odbc_response_time 10
Svr_login_0
Code:
// //////////////////////////////////////////////////////////////////////////////Login server cfg file//////////////////////////////////////////////////////////////////////////////server_version 1 patch_version 1 server_name ServerLogin server_max_client 200server_ip 127.0.0.1server_service_port 5001server_control_port 2002service_provider 3 //4max_thread 3 server_type 1server_group 0 server_number 0server_field 0//use_event_thread 1// ////////////////////////////////////////////////////////////////////////////// session_server [server_name] [ip] [port] [userid] [userpass]session_server serversession 127.0.0.1 5003 sa peksman
Svr_agent_0
Code:
////////////////////////////////////////////////////////////////////////////// //Agent server cfg file ////////////////////////////////////////////////////////////////////////////// server_version 1 patch_version 1 server_name AgentServer server_max_client 200server_max_channel_client 200 server_ip 127.0.0.1 server_service_port 3003 server_control_port 2003service_provider 3max_thread 3server_type 4 server_group 0 server_number 0server_channel_number 1//heartbeat 1use_event_thread 1// //////////////////////////////////////////////////////////////////////////// // session_server [server_name] [ip] [port] [userid] [userpass] session_server ServerSession 127.0.0.1 5003 sa peksman// //////////////////////////////////////////////////////////////////////////// channel 0 1//channel 1 0// //////////////////////////////////////////////////////////////////////////// //field_server [channel] [field num] [server_name] [ip] [port] field_server 0 0 FieldServer 127.0.0.1 3000//field_server 1 0 FieldServer 46.20.37.161 8000//field_server 0 2 ServerField2 46.20.37.161 6700//field_server 0 3 ServerField2 46.20.37.161 6800// //////////////////////////////////////////////////////////////////////////// // user database setting value user_odbc_name RanUseruser_odbc_user sa user_odbc_pass peksmanuser_odbc_database RanUser user_odbc_pool_size 5 user_odbc_response_time 10 // //////////////////////////////////////////////////////////////////////////// // game database setting value game_odbc_name RanGame1 game_odbc_user sa game_odbc_pass peksmangame_odbc_database RanGame1 game_odbc_pool_size 5 game_odbc_response_time 10 // //////////////////////////////////////////////////////////////////////////// // log database setting value log_odbc_name RanLoglog_odbc_user sa log_odbc_pass peksmanlog_odbc_database RanLog log_odbc_pool_size 5 log_odbc_response_time 10 // //////////////////////////////////////////////////////////////////////////// // Shop database setting value shop_odbc_name RanShopshop_odbc_user sa shop_odbc_pass peksmanshop_odbc_database RanShop shop_odbc_pool_size 5 shop_odbc_response_time 10
Svr_field_0
Code:
////////////////////////////////////////////////////////////////////////////// //Field server cfg file ////////////////////////////////////////////////////////////////////////////// server_version 1 patch_version 1 server_name FieldServer server_max_client 200 server_ip 127.0.0.1 server_service_port 3000 server_control_port 2008service_provider 3 max_thread 4 server_type 3 server_group 0 server_number 0server_field 0 server_channel 0 //heartbeat 1pk 1gameguard 1use_event_thread 1// //////////////////////////////////////////////////////////////////////////// // session_server [server_name] [ip] [port] [userid] [userpass] session_server ServerSession 127.0.0.1 5003 sa peksman// //////////////////////////////////////////////////////////////////////////// // agent_server [server_name] [ip] agent_server ServerAgent 127.0.0.1 // //////////////////////////////////////////////////////////////////////////// // user database setting value user_odbc_name RanUseruser_odbc_user sa user_odbc_pass peksmanuser_odbc_database RanUser user_odbc_pool_size 5 user_odbc_response_time 10 // //////////////////////////////////////////////////////////////////////////// // game database setting value game_odbc_name RanGame1 game_odbc_user sa game_odbc_pass peksmangame_odbc_database RanGame1 game_odbc_pool_size 5 game_odbc_response_time 10 // //////////////////////////////////////////////////////////////////////////// // log database setting value log_odbc_name RanLoglog_odbc_user salog_odbc_pass peksmanlog_odbc_database RanLog log_odbc_pool_size 5 log_odbc_response_time 10 // //////////////////////////////////////////////////////////////////////////// // Shop database setting value shop_odbc_name RanShopshop_odbc_user sa shop_odbc_pass peksmanshop_odbc_database RanShop shop_odbc_pool_size 5 shop_odbc_response_time 10
- - - Updated - - -
my param.ini
Code:
[SERVER SET]LoginAddress = 112.198.70.153HttpAddress = 127.0.0.1strNewsURL =127.0..0.1strConnectionURL = 2046.5u56.combUsePassiveDN = 0nChinaRegion = 4;[GUI OPTION]; FontType = [D3DFONT,D3DXFONT]; LangSet = [def=0, chn_tra=1, jp=2, kr=3, chn_sim=4, th=5, vn=6]; GDIFont = [µ¸¿òü,Fixedsys]strFontType = D3DFONTdwLangSet = 0strGDIFont = Tahoma;[TEXT FILE]; ±¹°¡º° ¿É¼ÇÀº XMLÆÄÀÏÀÇ ÅÂ±× ¿É¼Ç°ú ÀÏÄ¡ÇØ¾ß ÇÑ´Ù.strCountry = pestrLauncherText = Launcher.xmlstrGameInText = gameintext.xmlstrGameExText = gameextext.xmlstrGameWord = gameword.xmlstrServerText = servertext.xmlstrUIOuterCfg = UIOuterCfg.xmlstrUIInnerCfg01 = UIInnerCfg01.xmlstrUIInnerCfg02 = UIInnerCfg02.xmlstrUIInnerCfg03 = UIInnerCfg03.xmlstrUIExtCfg = UIExtCfg.xml;[ETC OPTION]; À¥ ÁÖ¼Ò ¿¹½Ã : http://ran.hicocoon.com/index.jsp; Æú´õ ÁÖ¼Ò ¿¹½Ã : \Data\Help\Help.htmHelpAddress = /data/help/help.htmItemShopAddress = http://rangameshop.e-games.com.ph/shop/item.aspRPFDataPath = /package/data.rpf
Re: [Help] ERROR:SQLConnect Failed ERROR:User db open failed
Double check all the IP Address in CFG and param.ini
Re: [Help] ERROR:SQLConnect Failed ERROR:User db open failed
Service Provider:CHINACreateIoCompletionPort OKINFO:SQL_ATTR_CONNECTION_POOLING OKINFO:SQLAllocHandle OKERROR:SQLConnect FailedERROR:User db open failed== Please wait until server stop Stop IOCPStop Message QueueStop DataBaseStop CFG=======================================================Server Stop OK=======================================================INFO:SQL_ATTR_CONNECTION_POOLING OKINFO:SQLAllocHandle OK
how can i fix this can any one help me ?? please
Re: [Help] ERROR:SQLConnect Failed ERROR:User db open failed
Quote:
Originally Posted by
marvin24ailene
Service Provider:CHINACreateIoCompletionPort OKINFO:SQL_ATTR_CONNECTION_POOLING OKINFO:SQLAllocHandle OKERROR:SQLConnect FailedERROR:User db open failed== Please wait until server stop Stop IOCPStop Message QueueStop DataBaseStop CFG=======================================================Server Stop OK=======================================================INFO:SQL_ATTR_CONNECTION_POOLING OKINFO:SQLAllocHandle OK
how can i fix this can any one help me ?? please
turn off the firewall of your host server where the sql is, did you properly configured obdc?
Re: [Help] ERROR:SQLConnect Failed ERROR:User db open failed
Quote:
Originally Posted by
raverking
turn off the firewall of your host server where the sql is, did you properly configured obdc?
i just install sql in windows i did'nt use Virtual os
do i need to install it in VIrtual os ?
Re: [Help] ERROR:SQLConnect Failed ERROR:User db open failed
Quote:
Originally Posted by
marvin24ailene
i just install sql in windows i did'nt use Virtual os
do i need to install it in VIrtual os ?
there is nothing to install, obdc is a administrative tools
Re: [Help] ERROR:SQLConnect Failed ERROR:User db open failed
