在线连接vb.net到SQL Server 2008 [英] connect vb.net to SQL server 2008 at online

问题描述

我有两台电脑上的项目，我家的一台电脑和我工作的其他电脑（我的工作远离我的家），如何通过使用SQL server 2008将我家工作的PC连接到PC？请给我建议..

I have project on the two PCs , one PC at my home and other at my work (my work far from my home), how can i connect PC at home to PC at my work by using SQL server 2008 ??? please, advice me ..

推荐答案

从理论上讲，这只是一个获取连接字符串的情况 - 如果您知道IP / URL，服务器就非常简单名称，并有适当的用户凭据。



在现实世界中，它不太可能成功。问题是大多数数据库服务器都配置为出于安全原因而禁止远程访问（例如，您不希望竞争对手访问您的公司数据）。



首先，请与您的数据库管理员交谈，并询问是否可行。如果是，他将能够为您提供所需的所有信息。

In theory, it's just a case of getting the connection string right - which is pretty trivial if you know the IP / URL, server name, and have appropriate user credentials.

In the real world, it's unlikely to be a success. The problem is that most database servers are configured to disallow remote access for security reasons (like you don't want your competitors to have access to your company data for example).

So start by talking to your DB administrator, and ask if it's possible. If it is, he will be able to give you all the info you need.

这篇关于在线连接vb.net到SQL Server 2008的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！