I agree with Mika. Give ADO.NET a try. It is by far a breath of fresh air compared to ADO.
Take a look at this sample application. I feel like there is less hoops to jump through to get what I want done.
ADO.NET Sample Application[
^]
Also, I have found this resource a big help.
Connection Strings[
^]