I just graduated with my degree in physiology and was accepted into a second-degree program. If you believe you can pull your grades up then I would stick with your degree in sociology and then try for a second-degree program. Remember, classes will only become more challenging as you continue college, so work hard and keep your head high. If there is no way you can get your grades up enough then you should start looking at "smaller" colleges that still offer a BSN degree and aren't quite as competitive as the larger schools. My fiancee is looking at a smaller school in Michigan; they require "good" grades, an interview, and a written statement to be accepted and it is a six semester (3 year) program, excluding summers. Good luck in your future endeavours and I hope nursing school eventually works out!