primary key constraint violation RRS feed

  • Question

  • i have a table with two fields, they are the PK...
    i write data from firebird to sql....

    there ARE NO duplicates in the firebird data...
    when i write to sql i get:

    Violation of PRIMARY KEY constraint 'PK_ACCESSLEVELS'. Cannot insert duplicate key in object 'dbo.ACCESSLEVELS'.  
    The statement has been terminated. 

    why is this?

    thank you
    • Moved by Peter Ritchie Thursday, September 4, 2008 3:16 PM SQL question (Moved from Visual C# Language to Off-Topic Posts (Do Not Post Here))
    Wednesday, September 3, 2008 2:08 PM


  • not to worry i found the problem. firebird is case sensitive and sql not....
    • Marked as answer by blattiebla Wednesday, September 3, 2008 2:40 PM
    Wednesday, September 3, 2008 2:39 PM