If I have SQL 2005 Standard installed on a server and I log on locally to that server. Can I connect to other machines through Management Studio-->Object Explorer that have SQLCE installed and manage the CE DB?
I think you can only connect to either local .sdf files or ones located on a device attached by USB to the local machine, but I have had some difficulty finding a definitive statement on that.
Thanks
SQL CE is in process database (a bunch of DLLs loaded by your application) , it has no remote connectivity. There’s a very special remote provider which allows you to access files on device from desktop.
You also might be able to “connect” (quoted because you’re not really connecting to anything – SQL CE is within your process) to the database located on a file shares though it might have some issues like sharing.
No comments:
Post a Comment