Ranking.dbo Problem help!

Results 1 to 16 of 16
  1. #1
    Valued Member kellybang is offline
    MemberRank
    Oct 2008 Join Date
    192.168.1.1Location
    112Posts

    Ranking.dbo Problem help!

    hello ragezoners currently having problem with this...

    any ideas on how to fix this?


    2012/03/01 18:57:47
    query:RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01'
    SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]OLE DB provider "SQLNCLI" for linked server "RANKING" returned message "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.".


  2. #2
    Apprentice Softbank is offline
    MemberRank
    Feb 2012 Join Date
    23Posts

    Re: Ranking.dbo Problem help!

    query:RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01'
    SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]OLE DB provider "SQLNCLI" for linked server "RANKING" returned message "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.".
    Any fix for this guys? I also have the same. :/

  3. #3
    Valued Member kellybang is offline
    MemberRank
    Oct 2008 Join Date
    192.168.1.1Location
    112Posts

    Re: Ranking.dbo Problem help!

    still no reply? :(

  4. #4
    ~FlyFF DeV~ Jomex is offline
    MemberRank
    Mar 2009 Join Date
    PolandLocation
    588Posts

    Re: Ranking.dbo Problem help!

    If you don't have source just leave it because you won't do anything with it.

  5. #5
    Valued Member kellybang is offline
    MemberRank
    Oct 2008 Join Date
    192.168.1.1Location
    112Posts

    Re: Ranking.dbo Problem help!

    every time i create guild it vanishes when i restart my servers >_< soo i think this error has something to do with the guild... hmmm

  6. #6
    ~FlyFF DeV~ Jomex is offline
    MemberRank
    Mar 2009 Join Date
    PolandLocation
    588Posts

    Re: Ranking.dbo Problem help!

    Quote Originally Posted by kellybang View Post
    every time i create guild it vanishes when i restart my servers >_< soo i think this error has something to do with the guild... hmmm
    Nah it's just database Server(Transserver) which gets rankings of guilds from MSSQL.

  7. #7
    [R8]ℓσℓ32 caja is offline
    MemberRank
    Oct 2008 Join Date
    Here!Location
    1,502Posts

    Re: Ranking.dbo Problem help!

    The server name for the linked server is wrong.

  8. #8
    Flyff Developer ShadowDragon is offline
    MemberRank
    Apr 2009 Join Date
    1,915Posts

    Re: Ranking.dbo Problem help!

    Quote Originally Posted by kellybang View Post
    every time i create guild it vanishes when i restart my servers >_< soo i think this error has something to do with the guild... hmmm
    Your guilds disappear because of a different problem. After logging in and finding your guild gone, did you ever restart only the world server? If you did, did the guilds come back?

    If you can answer yes to both of those questions, then you're simply opening the server programs in the wrong order.

  9. #9
    Valued Member kellybang is offline
    MemberRank
    Oct 2008 Join Date
    192.168.1.1Location
    112Posts

    Re: Ranking.dbo Problem help!

    Quote Originally Posted by ShadowDragon42 View Post
    Your guilds disappear because of a different problem. After logging in and finding your guild gone, did you ever restart only the world server? If you did, did the guilds come back?

    If you can answer yes to both of those questions, then you're simply opening the server programs in the wrong order.


    thats my sequence of my server sir..

    actually it disappear when i shutdown the server then when i turn on it back the guild name above my name vanishes but in the DB it says i still have Guild.. i still need to /dg so that i can create a new one even though i dont have a guild anymore ingame =)) hmmmm

  10. #10
    Flyff Developer ShadowDragon is offline
    MemberRank
    Apr 2009 Join Date
    1,915Posts

    Re: Ranking.dbo Problem help!

    Hm, you are opening them in the right order. Well then, you might be opening then too fast. Only other thing I can think of. After opening database server, wait 15-20 seconds before continuing with the others.

  11. #11
    i <3 C++ Deviant is offline
    MemberRank
    Jun 2005 Join Date
    Little GardenLocation
    527Posts

    Re: Ranking.dbo Problem help!

    Quote Originally Posted by ShadowDragon42 View Post
    Hm, you are opening them in the right order. Well then, you might be opening then too fast. Only other thing I can think of. After opening database server, wait 15-20 seconds before continuing with the others.
    agree with this.

  12. #12
    ~FlyFF DeV~ Jomex is offline
    MemberRank
    Mar 2009 Join Date
    PolandLocation
    588Posts

    Re: Ranking.dbo Problem help!

    Hmmm I have different order O_o

  13. #13
    Flyff Developer Intelligence is offline
    MemberRank
    Oct 2011 Join Date
    United KingdomLocation
    1,401Posts

    Re: Ranking.dbo Problem help!

    I have different order either.

    Try Account, Database, Core, Certifer, Login, Cache and World.

  14. #14
    Flyff Developer ShadowDragon is offline
    MemberRank
    Apr 2009 Join Date
    1,915Posts

    Re: Ranking.dbo Problem help!

    Quote Originally Posted by Intelligence View Post
    I have different order either.

    Try Account, Database, Core, Certifer, Login, Cache and World.
    Like everyone else, I'm starting to be really annoyed by your comments. Have you ever had a server running with many players that had an issue of guilds disappearing? Or do you have any clue about the question in the first post? If you can't say yes to either of my 2 questions, then you really shouldn't have said anything.

  15. #15
    Valued Member kellybang is offline
    MemberRank
    Oct 2008 Join Date
    192.168.1.1Location
    112Posts

    Re: Ranking.dbo Problem help!

    i really appreciate your comments and suggestion guys.

    Intelligence sequence made the guild bug fixed but i still get the query error i posted above...

    @ShadowDragon42 my friend also said that this kind of sequence is not good for many players.. it might cause problem... what will i do to make the sequence right? like the one i posted above..


    i really appreciate the helps.. :D

  16. #16
    ~FlyFF DeV~ Jomex is offline
    MemberRank
    Mar 2009 Join Date
    PolandLocation
    588Posts

    Re: Ranking.dbo Problem help!

    Quote Originally Posted by kellybang View Post
    Intelligence sequence made the guild bug fixed but i still get the query error i posted above...
    If you do not have source of your files just ignore it told ya fixing it is too complicated to fix an error which does absolutely nothing.



Advertisement