Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[Help] ERROR:SQLConnect Failed

Newbie Spellweaver
Joined
Mar 3, 2007
Messages
49
Reaction score
0
Help How To Solve This

Service Provider:CHINA
INFO:nProtect GameGuard server DLL load failed
CreateIoCompletionPort OK
INFO:SQL_ATTR_CONNECTION_POOLING OK
INFO:SQLAllocHandle OK
User DB Open OK
ERROR:SQLConnect Failed
ERROR:Game DB Open Error
== Please wait until server stop
== Update Thread end
INFO:CAgentServer::SessionCloseConnect SessionCloseConnect already offline
== Client Manager closed
== Message Manager closed
== Database Manager closed OK
=======================================================
Server Stop OK
=======================================================
INFO:SQL_ATTR_CONNECTION_POOLING OK
INFO:SQLAllocHandle OK


THE Thread of Resolve issue is not working / i dont have permission to view this
http://forum.ragezone.com/f248/guide-odbc-settings-creating-gmaccount-306396/#post2664942

ANY ONE CAN HELP ME?

IM USING EP4 Korean
 
Newbie Spellweaver
Joined
Mar 3, 2007
Messages
49
Reaction score
0
Re: ERROR:SQLConnect Failed

Sir i already check the CFG can you help me ?

can you share your possible solution in my CFG
or share your CFG thank you
 
Upvote 0
http://ranengine.ddns.net
Joined
Nov 16, 2009
Messages
450
Reaction score
87
Re: ERROR:SQLConnect Failed

like this

-----------------------------------------------------------------

// ////////////////////////////////////////////////////////////////////////////
// Field server 0 Reconfigured By IaNz
//
// ////////////////////////////////////////////////////////////////////////////
// server setting value
server_version 1
patch_version 1
server_name Field0
server_max_client 200
server_ip your ip address
//IP
server_service_port 5103
server_control_port 6002
// ////////////////////////////////////////////////////////////////////////////
// Field Server PK Setting
// pk [on/off]
// 1 on
// 0 off
pk 1
//
service_provider 3
heartbeat 1
max_thread 5
//
// server type [type]
// [type]
// 1 : login server
// 2 : session server
// 3 : field server
// 4 : agent server
server_type 3
server_group 0 // game server group
server_number 1 // game server number
server_channel 0 // Channel number
server_field 0 // field number
//
// ////////////////////////////////////////////////////////////////////////////
// Session server
// session_server [server_name] [ip] [port] [userid] [userpass]
session_server Session your ip address 5003 ran ran
//
// ////////////////////////////////////////////////////////////////////////////
// Agent server
// agent_server [server_name] [ip]
agent_server Agent your ip address
//
// ////////////////////////////////////////////////////////////////////////////
// user database setting value
user_odbc_name RanUser
user_odbc_user sa
user_odbc_pass your SQL pass
user_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 your SQL pass
game_odbc_database RanGame1
game_odbc_pool_size 5
game_odbc_response_time 10
//
// ////////////////////////////////////////////////////////////////////////////
// log database setting value
log_odbc_name RanLog
log_odbc_user sa
log_odbc_pass your SQL pass
log_odbc_database RanLog
log_odbc_pool_size 5
log_odbc_response_time 10
//
// ////////////////////////////////////////////////////////////////////////////
// Shop database setting value
shop_odbc_name RanShop
shop_odbc_user sa
shop_odbc_pass your SQL pass
shop_odbc_database RanShop
shop_odbc_pool_size 5
shop_odbc_response_time 10
 
Last edited:
Upvote 0
Skilled Illusionist
Joined
Sep 20, 2009
Messages
315
Reaction score
68
Re: ERROR:SQLConnect Failed

Also Check Your Ran Database if korea.. not TW
 
Upvote 0
Newbie Spellweaver
Joined
Aug 3, 2010
Messages
10
Reaction score
0
Re: ERROR:SQLConnect Failed

greetingS!! anybody can help me plsss...

Service Provider:CHINA
CreateIoCompletionPort OK
INFO:SQL_ATTR_CONNECTION_POOLING OK
INFO:SQLAllocHandle OK
User DB Open OK
Game DB Open OK
Log DB Open OK
Shop DB Open OK
Database Thread Create OK
Log Database Thread Create OK
User Database Thread Create OK
--------------- System Information -------------------
Microsoft Windows XP
Pentium III processor 1803 Mhz
2 System Processor Detected
------------------------------------------------------
2 Worker Thread
1 st Worker Thread Create OK
2 st Worker Thread Create OK
nProtect GameGuard server DLL load failed
[Gaea Server] Start
 
Upvote 0
Back
Top