Welcome to Tom's Hardware Forums!
If the card works in another camera and not in the Canon, then the problem is in the 'Canon + Card' combination. Use a magnifying glass and ensure that the lock is indeed in the open position, and that there is nothing sticking or impeding the 'open'.
You can also try using a different memory card in the Canon and see how that functions. This will help isolate the problem.