Cetin,

You are the other one :-)!

I'm actually a bit ashamed about asking the question in the first place, instead of looking up the USE command.

I have not tried it yet, but if it does not require exclusive access to the VFP DB, it's a workable solution.

I've never had any reason to use connection strings, so I've always used defined connections line Connection1 in the DB.

How does one handle userid and password in connectionstrings?

>>Sergey,
>>
>>Might as well ask you directly, since you're the one that answers most of my questions anyway :-)
>>
>>Assume two SQL Server DB's, DB1 & DB2 that are 100% identical.
>>
>>Also assume one VFP DB, containing remote views only.
>>
>>Is it possible to let these views point to DB1 or DB2 respectively, or must I redo the whole thing and use SQLPT?
>>
>>TIA
>>
>>Regards
>>
>>Peter
>Indirect answer :)
>Use command has a CONNSTRING clause in VFP7 and up.
>Cetin