Michael,
>I'm thinking about using both VistaDB and MSSQL in a project. If you are using a database with out stored procedures should you just resolve yourself to not using stored proceduures on both databases or has someone figured out a neat way to wrap up your database calls to use either or?
I don't think there's a clean way to accomplish this other than using dynamic SQL for both databases. That said, why not use SQL Server and SQL Server Express instead?
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