>I'm able to connect to SQL Server Express with VFP using the CA builder but when I try to call the fields my query would have the tables for the selected database do not show up. What is going on? Do I need a different approach since I'm trying an ADO connection?

Did you install Native SQL client on the PC?