API Error.

Results 1 to 15 of 15
  1. #1
    Account Upgraded | Title Enabled! KidJB is offline
    MemberRank
    Oct 2009 Join Date
    Topeka, KansasLocation
    291Posts

    API Error.

    WO_5SQL Connect failed

    I Added all the users to database and configured SQL_Base.cs and dbinfo.inc.php


  2. #2
    Custom Title Enabled GigaToni is offline
    MemberRank
    Aug 2009 Join Date
    GER / FRLocation
    2,329Posts

    Re: API Error.

    that doesn't help at all.. say what you've changed.. look through the SQL_Base.cs..

  3. #3
    Account Upgraded | Title Enabled! KidJB is offline
    MemberRank
    Oct 2009 Join Date
    Topeka, KansasLocation
    291Posts

    Re: API Error.

    Code:
    using System;
    using System.Collections.Generic;
    using System.Collections.Specialized;
    using System.Web;
    using System.Data.SqlClient;
    using System.Diagnostics;
    using System.Configuration;
    
    /// <summary>
    /// Summary description for SQLBase
    /// </summary>
    public class SQLBase
    {
        string server = "127.0.0.1,11433";
        string user = "wz_api_user";
        string pass = "r3n3gad3";
        string workdb = "warZ";
    
        SqlConnection conn_ = null;
    
        public SQLBase()
        {
            /*
            if (ConfigurationManager.AppSettings.Get("WO_Region") == "RU")
            {
                server = "localhost,11433";
                //server = "rudb1.thewarinc.com,11433";
                user = "WOAdmin";
                pass = "r3n3gad3";
            }
            else*/
            {
                server = "127.0.0.1,11433";
                user = "wz_api_user";
                pass = "r3n3gad3";
    Thats all i changed in sqlbase

  4. #4
    Custom Title Enabled GigaToni is offline
    MemberRank
    Aug 2009 Join Date
    GER / FRLocation
    2,329Posts

    Re: API Error.

    Is your MSSQL Server running on port 11433 or 1433?

    Default is 1433

  5. #5
    Account Upgraded | Title Enabled! KidJB is offline
    MemberRank
    Oct 2009 Join Date
    Topeka, KansasLocation
    291Posts

    Re: API Error.

    Port set at 1433 still doesnt connect with either port im not sure i have all database settings right in it lol

  6. #6
    Member Dragonwert is offline
    MemberRank
    Feb 2009 Join Date
    68Posts

    Re: API Error.

    same here

  7. #7
    Custom Title Enabled GigaToni is offline
    MemberRank
    Aug 2009 Join Date
    GER / FRLocation
    2,329Posts

    Re: API Error.

    what MSSQL do you use?

    try instead of 127.0.0.1:
    localhost
    localhost\\SQLEXPRESS

  8. #8
    Account Upgraded | Title Enabled! KidJB is offline
    MemberRank
    Oct 2009 Join Date
    Topeka, KansasLocation
    291Posts

    Re: API Error.

    Quote Originally Posted by GigaToni View Post
    what MSSQL do you use?

    try instead of 127.0.0.1:
    localhost
    localhost\\SQLEXPRESS
    Microsoft SQL Server 2008 is what im using.

    Trying localhost or localhost\\SQLEXPRESS at this minute will edit post.

    EDIT: Still getting WO_5SQL Connect failed with localhost\\SQLEXPRESS and localhost.

  9. #9
    Custom Title Enabled GigaToni is offline
    MemberRank
    Aug 2009 Join Date
    GER / FRLocation
    2,329Posts

    Re: API Error.

    is the MSSQL Server running on the same machine as the server??

  10. #10
    Account Upgraded | Title Enabled! KidJB is offline
    MemberRank
    Oct 2009 Join Date
    Topeka, KansasLocation
    291Posts

    Re: API Error.

    Quote Originally Posted by GigaToni View Post
    is the MSSQL Server running on the same machine as the server??
    Yep same machine

  11. #11
    Banned minusZero is offline
    BannedRank
    Apr 2013 Join Date
    /dev/null/Location
    18Posts

    Re: API Error.

    Open up cmd and type 'netstat -an' and tell me if you have any TCP ports listening on port 11433 or 1433

  12. #12
    Account Upgraded | Title Enabled! KidJB is offline
    MemberRank
    Oct 2009 Join Date
    Topeka, KansasLocation
    291Posts

    Re: API Error.

    Quote Originally Posted by minusZero View Post
    Open up cmd and type 'netstat -an' and tell me if you have any TCP ports listening on port 11433 or 1433
    No i do not have a TCP 1433 or 11433

  13. #13
    Custom Title Enabled GigaToni is offline
    MemberRank
    Aug 2009 Join Date
    GER / FRLocation
    2,329Posts

    Re: API Error.

    Try that:
    look in Services -> SQL Server and start the service if not already running

  14. #14
    Banned minusZero is offline
    BannedRank
    Apr 2013 Join Date
    /dev/null/Location
    18Posts

    Re: API Error.





    Now check to see if the ports are listening.

  15. #15
    Account Upgraded | Title Enabled! KidJB is offline
    MemberRank
    Oct 2009 Join Date
    Topeka, KansasLocation
    291Posts

    Re: API Error.



    This is what i get now.. is this right?



Advertisement