远程服务器的SQL Server Compact连接字符串 [英] SQL Server Compact Connection string for remote server

问题描述

大家好！

我真的很想知道什么是连接到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!

推荐答案

您是否检查过文档甚至网站? http://www.connectionstrings.com/sql-server-2005-ce [ ^ ]

基本上只是传递到数据库文件的标准路径，如"\\ server \ share \ path \ dbfile"

Have you checked the docs or even the site; http://www.connectionstrings.com/sql-server-2005-ce[^]

Basically just pass in a fully qualified path to the database file as in "\\server\share\path\dbfile"

这篇关于远程服务器的SQL Server Compact连接字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！