I figured it out. I was idiotically putting the year as 2 digits instead of 4. No need for the DSN now.
Thank you for making me examine more closely what I was doing. I appreciate it greatly.
-John
