Linda,
>UPDATE:
>
>I figured it out. I needed to change the connection string to use Windows Authentication. It is connecting correctly now.
Glad you figured it out! In the past, this problem had been caused by an invalid connection string, so that's why I was looking to see how you were connecting.
Best Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com