data server ODBC

Results 1 to 3 of 3
  1. #1
    Valued Member bedna is offline
    MemberRank
    Dec 2008 Join Date
    WorthLocation
    106Posts

    data server ODBC

    sup, i use windows server 2003 86x (32bit) with sql 2000+titans tech files 1.07.65, i used odbc for windows 32 bit, server works fine but each time i run it i see this on data server 1 and 2 anyone can help me figure out how do i fix this error??
    Code:
    data server 05:25:44p exec WZ_CreateCharacter_GetVersion
    05:25:44p INSERT INTO DefaultClassType (Level, Class, Strength, Dexterity, Vitality, Energy, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, DbVersion, LevelUpPoint,Leadership)  VALUES (1,0,18,18,15, 30, 60.000000,60.000000,60.000000,60.000000, 0,182,128, 3, 0, 0)
    05:25:44p (2) SQLSTATE:23000, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK_DefaultClassType'. Cannot insert duplicate key in object 'DefaultClassType'.
    05:25:44p (2) SQLSTATE:01000, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
    05:25:44p INSERT INTO DefaultClassType (Level, Class, Strength, Dexterity, Vitality, Energy, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, DbVersion, LevelUpPoint,Leadership)  VALUES (1,16,28,20,25, 10, 110.000000,110.000000,20.000000,20.000000, 0,182,128, 3, 0, 0)
    05:25:44p (2) SQLSTATE:23000, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK_DefaultClassType'. Cannot insert duplicate key in object 'DefaultClassType'.
    05:25:44p (2) SQLSTATE:01000, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
    05:25:44p INSERT INTO DefaultClassType (Level, Class, Strength, Dexterity, Vitality, Energy, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, DbVersion, LevelUpPoint,Leadership)  VALUES (1,32,22,25,20, 15, 80.000000,80.000000,30.000000,30.000000, 0,182,128, 3, 0, 0)
    05:25:44p (2) SQLSTATE:23000, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK_DefaultClassType'. Cannot insert duplicate key in object 'DefaultClassType'.
    05:25:44p (2) SQLSTATE:01000, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
    05:25:44p INSERT INTO DefaultClassType (Level, Class, Strength, Dexterity, Vitality, Energy, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, DbVersion, LevelUpPoint,Leadership)  VALUES (1,48,26,26,26, 26, 110.000000,110.000000,60.000000,60.000000, 0,182,128, 3, 0, 0)
    05:25:44p (2) SQLSTATE:23000, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK_DefaultClassType'. Cannot insert duplicate key in object 'DefaultClassType'.
    05:25:44p (2) SQLSTATE:01000, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
    05:25:44p INSERT INTO DefaultClassType (Level, Class, Strength, Dexterity, Vitality, Energy, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, DbVersion, LevelUpPoint,Leadership)  VALUES (1,64,26,20,20, 15, 90.000000,90.000000,40.000000,40.000000, 0,182,128, 3, 0, 25)
    05:25:44p (2) SQLSTATE:23000, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK_DefaultClassType'. Cannot insert duplicate key in object 'DefaultClassType'.
    05:25:44p (2) SQLSTATE:01000, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
    05:25:45p exec WZ_Get_DBID
    05:25:45p SELECT ItemCount, Number from GameServerInfo where Number=0
    05:25:45p [ANTI-HACKING][IP LIST] IP : [127.0.0.0] Length : 255
    [IP List Load ] - AllowableIPList.txt file is Loaded
    DataServer Run
    05:26:07p UserIndex [0] Connected IP : 127.0.0.1 
    Socket number 992 connected


  2. #2
    High'nLows 19871986 is offline
    MemberRank
    Sep 2010 Join Date
    istanbulLocation
    802Posts

    Re: data server ODBC

    this isn't error ( i think )

  3. #3
    BadsBunny Design & Dev. DndY23 is offline
    MemberRank
    Jan 2011 Join Date
    Santolan PasigLocation
    268Posts

    Re: data server ODBC

    Reconfigure your ODBC..
    It also happen to me but now it succesfuly running..
    I just have the problem ..
    i Cant Run my server :(



Advertisement