Thanks, Sue. I'm afraid I'm just as confused. From the explanation of asymmetrical keys, I was expecting the destination server to send me a public key so that I could...

• This reply was modified 5 years, 7 months ago by  peter 82125.

Thank you 🙂

No, not the quotes. I was using the wrong class, it needed to be SQLCeCnnection since I'm using CE and then my connection string syntax was way off for CE.

Here's the article that finally explained it correctly: https://www.daniweb.com/programming/software-development/threads/340646/newb-connect-sql-server-compact-3-5-in-visual-studio-2010

Thank you all so much for your informative replies! Jacob, you rock, caffeine or none! Really appreciate it 🙂

Duly noted.

Michael, I'm using the AdventureWorks database and the following:

USE AdventureWorks

SELECT Name

FROM Production.Product p

WHERE EXISTS

(SELECT *

FROM Production.ProductSubcategory

...

Thanks, Gail and Drew. Gail, the links don't directly discuss EXISTS vs join, but it looks like one can conclude what Drew is saying that there is really no difference...

Thanks for the reply. Sounds perfectly reasonable, except that when I compare the 2 queries, one written with the EXISTS operator and a correlated subquery and the other as a...

Thanks! Where is that Help option located, please?

OK, that should work. Thanks! Kind of stupid for it to perform an unnecessary task, but c'est la vie, I suppose. Thanks, again.

What do you mean? Compare them against what? What am I looking for?

Oh, I think you are suggesting that I compare the project flies for any differences between them. OK....

Thanks for the reply, Yelena. The answer is 'yes' to all your questions. There is an active connection to the server in both cases. Both machines are imaged identically, so...

Thanks for the reply.

... do they each apply to different things, or are they options for the same thing, and if so, what's the criterion for selecting one over the other?... That type...