I agree with Green Tea. You may not be completely shut out from nursing altogether. It all depends on the school, thier policies and who may or may not be sympathetic to your past. I have been on admissions committees, and I have seen many people who are like you. I'm assuming you are "older", and not a 22 year old, who had these poor grades 3 years ago
What I would be looking at it, what have you done since then to try to rectify your not-so-stellar record/transcript. If there has not been a lot of time, and/or improvement in your GPA since then, they may feel you are not ready for the challenge of a nursing program.