[Help] ERROR:SQLConnect Failed

Results 1 to 12 of 12
  1. #1
    Member tzinpo is offline
    MemberRank
    Mar 2007 Join Date
    Behind SystemLocation
    90Posts

    [Help] ERROR:SQLConnect Failed

    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...6/#post2664942

    ANY ONE CAN HELP ME?

    IM USING EP4 Korean


  2. #2
    Alpha Member starstrokers is offline
    MemberRank
    Jun 2009 Join Date
    PC FRONTLocation
    1,815Posts

    Re: ERROR:SQLConnect Failed

    check cfg ip's

  3. #3
    Member tzinpo is offline
    MemberRank
    Mar 2007 Join Date
    Behind SystemLocation
    90Posts

    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

  4. #4
    http://ranengine.ddns.net Feck is offline
    MemberRank
    Nov 2009 Join Date
    IsabelaLocation
    708Posts

    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 by Feck; 23-12-09 at 02:44 AM.

  5. #5
    Enthusiast khaizer03 is offline
    MemberRank
    Apr 2010 Join Date
    49Posts

    Re: ERROR:SQLConnect Failed

    check your microsoft Server DSN Configuration

  6. #6
    Newbie [GM]:Glenox is offline
    MemberRank
    Jan 2010 Join Date
    461Posts

    Re: ERROR:SQLConnect Failed

    yes check your CFG server files....

  7. #7
    The Prodigal Explorer Thamodz is offline
    MemberRank
    Apr 2009 Join Date
    Summoners RiftLocation
    1,164Posts

    Re: ERROR:SQLConnect Failed

    dont bump old threads.

  8. #8
    Account Upgraded | Title Enabled! SystemLog is offline
    MemberRank
    Sep 2009 Join Date
    i3Location
    471Posts

    Re: ERROR:SQLConnect Failed

    Also Check Your Ran Database if korea.. not TW

  9. #9
    Apprentice albert is offline
    MemberRank
    Aug 2010 Join Date
    10Posts

    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

  10. #10
    Account Upgraded | Title Enabled! Huang_kaijie is offline
    MemberRank
    Jul 2010 Join Date
    IndonesiaLocation
    301Posts

    Re: ERROR:SQLConnect Failed

    just wait. that's always take a long time . . .
    Posted via Mobile Device

  11. #11
    Novice meena3677 is offline
    MemberRank
    Jun 2011 Join Date
    1Posts

    Re: [Help] ERROR:SQLConnect Failed

    1234567891234567891234567890123456789

  12. #12
    Listed Ervs is offline
    MemberRank
    Jul 2011 Join Date
    /root/Location
    947Posts

    Re: [Help] ERROR:SQLConnect Failed

    Thanks for CFG Ip. Some of my problems running my server already fixed. but there still more error , that's why im here searching and browsing threads. thanks a lot.



Advertisement