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.

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).

Originally I queried the MSSQL table for its columns, created the proper string, and fed that string to the VFP OLEDB provider and made a table with the same structure as the MSSQL table. Then I used the GetRows method on the MSSQL table to put the result set into an array, but I got stuck because I never know what kind of data will be in the array, so I can't tell the provider

Insert into table (col1,col2,col3) values (array(0,0),array(1,0),array(2,0))

because of the data typing.

Then I thought I could use the VFP OLEDB provider to create an ODBC connection in the DBC, then a Remote View, then I could copy that to a table and add it to the database. No go on that one.

So what kind of method can I use to automatedly(sp) copy MSSQL tables into VFP tables?

Thanks.