>Uh oh. I finally found a reference at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/fox7help/html/dglrfunsupportedvisualfoxprocommandsfunctions.asp that says "Create Connection" is not supported with the VFP7 OLEDB provider. This is a bad thing.

Umm, why on earth would you want to do CREATE CONN via the provider?

>Maybe if I say what I am doing someone can give me a better way. I am trying to create a local DBC version of several tables that lie on different MSSQL servers. This all has to get done in ADO (forced to use VBScript for this exercise).

I'm easily confused, so bear with me when I ask why a VFP COM server wouldn't do what you want. I've read and reread your message, and I don't see why this wouldn't work.