远程服务器的SQL Server Compact连接字符串

本文介绍了远程服务器的SQL Server Compact连接字符串的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

大家好！ 我真的很想知道什么是连接到SQL Server Compact的正确连接字符串. 我使用此字符串连接本地文件.SDF，但现在我需要使用远程服务器进行连接，因为我无法在该计算机上安装服务器.可以吗?如果是，请您帮我连接字符串吗?

Hey guys! I''d really like to know what''s the right connection string to connect to SQL Server Compact. I was using this string to connect in the local file .SDF, but now I need to connect using a remote server, because I can''t install the server in this machine.. is that possible? if yes, please could you help me with the connection string?

connectionString="Data Source=test.sdf;Password=test123; Persist Security Info=False;"

因此，我将服务器安装在第二台计算机上，而目前，我现在无法在第二台计算机上使用已安装的服务器进行连接吗?作为服务器必须采取行动... 对不起，我的英语. 我已经尝试过了，但是我知道这是错误的

So, I install the server in the second machine, and in the current, I can''t, now, is that possible connect using the installed server in the second? As a server must act.. Sorry for my english. i''ve tried this, but i know it''s wrong

connectionstring="Data Source=SOMINATRIS\\SQLEXPRESS;Initial Catalog=test.sdf;Persist Security Info=False"

Thanks in adv!

推荐答案

您是否检查过文档甚至网站? www.connectionstrings/sql-server-2005-ce [ ^ ] 基本上只是传递到数据库文件的标准路径，如"\\ server \ share \ path \ dbfile" Have you checked the docs or even the site; www.connectionstrings/sql-server-2005-ce[^] Basically just pass in a fully qualified path to the database file as in "\\server\share\path\dbfile"