Painful sex

Okay so I'm due June 12 so 38 weeks pregnant and my hubby and I tried to have sex last night and it felt like I'd never had sex before.. Yes that's how painful it was. Is this normal? We haven't had sex in about 6 weeks prior to this and I wanted to try to soften my cervix as I've heard that can help bring on labor. Has this happened to anyone else? We couldn't even continue that's how bad the pain I was feeling was. Please tell me I'm not alone. Thanks all!