blocks|key|4695339|text|1-+Buy+somethihng+like+this.这是一个UPS接收器。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|4695340|2-将其连接到服务器机器。|4695341|3-编写批处理或shell脚本，调用GPS软件并返回当前位置。|4695342|4-使用xp_cmdshell调用此脚本，并通过SQL+Server查询返回当前位置。|style|CODE|4695343|entityMap|0|LINK|mutability|MUTABLE|url|http://www.amazon.com/USGlobalSat-BU-353-WaterProof-Enabled-Receiver/dp/tech-data/B000V5TV22/ref=de_a_smtd^0|3|P|0|0|0|0|4|B|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@$A|U|B|V|1|W]]|C|$]]|$1|D|3|E|5|6|7|X|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|Y|8|@]|9|@]|C|$]]|$1|H|3|I|5|6|7|Z|8|@$A|10|B|11|J|K]]|9|@]|C|$]]|$1|L|3|-4|5|6|7|12|8|@]|9|@]|C|$]]]|M|$N|$5|O|P|Q|C|$R|S]]]]

1 - <a href="http://www.amazon.com/USGlobalSat-BU-353-WaterProof-Enabled-Receiver/dp/tech-data/B000V5TV22/ref=de_a_smtd" rel="noreferrer">Buy somethihng like this.</a> It's a UPS GPS receiver.

2 - Connect it to the server machine.

3 - Write a batch or shell script that will call the GPS software and return the current position.

4 - Use <code>xp_cmdshell</code> to call this script and return the current position via SQL Server query.

blocks|key|4978228|text|买一部iPhone/Android手机，把它贴在装有数据库的机器的顶部。编写一个快速应用程序，让它查看GPS+API，并使用某种基于HTTPS的JSON/SOAP+API+(出于安全目的)将其位置发布到手机连接的数据库中。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4978229|然后，您可以从使用C#的位置访问GPS信息。|4978230|编辑|offset|length|style|BOLD|4978231|在Mono/iPhone上使用全球定位系统：http://drdobbs.com/mobility/222600599|4978232|示例代码，Mono/Android上的GPS：https://github.com/gshackles/Sample-Projects/blob/master/MonoDroid/MonoDroidSamples/MonoDroidSamples/DemoActivities/LocationDemo/LocationActivity.cs|4978233|entityMap|0|LINK|mutability|MUTABLE|url|http://drdobbs.com/mobility/222600599|1|https://github.com/gshackles/Sample-Projects/blob/master/MonoDroid/MonoDroidSamples/MonoDroidSamples/DemoActivities/LocationDemo/LocationActivity.cs^0|0|0|0|2|0|M|11|0|0|N|44|1|0^^$0|@$1|2|3|4|5|6|7|X|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Y|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|Z|8|@$F|10|G|11|H|I]]|9|@]|A|$]]|$1|J|3|K|5|6|7|12|8|@]|9|@$F|13|G|14|1|15]]|A|$]]|$1|L|3|M|5|6|7|16|8|@]|9|@$F|17|G|18|1|19]]|A|$]]|$1|N|3|-4|5|6|7|1A|8|@]|9|@]|A|$]]]|O|$P|$5|Q|R|S|A|$T|U]]|V|$5|Q|R|S|A|$T|W]]]]

Buy an iPhone/Android phone and have it sellotaped to the top of the machine that has the database on it. Write a quick app to have it look at the GPS API and post it's position to the database the phone is connected on using some kind of JSON/SOAP API over HTTPS (for security purposes).

You can then access the GPS information from where you are using C#.

Edit

Working with the GPS on Mono/iPhone: <a href="http://drdobbs.com/mobility/222600599" rel="nofollow">http://drdobbs.com/mobility/222600599</a>

Example code, GPS on Mono/Android: <a href="https://github.com/gshackles/Sample-Projects/blob/master/MonoDroid/MonoDroidSamples/MonoDroidSamples/DemoActivities/LocationDemo/LocationActivity.cs" rel="nofollow">https://github.com/gshackles/Sample-Projects/blob/master/MonoDroid/MonoDroidSamples/MonoDroidSamples/DemoActivities/LocationDemo/LocationActivity.cs</a>

blocks|key|4978355|text|最简单的解决方案是进行DNS查找，然后按照Cody的建议使用IP位置服务。试试这个：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4978356|var+foo+=+Dns.GetHostEntry("database.windows.net");|code-block|syntax|javascript|4978357|一旦你得到了你的IP地址，你就需要使用HttpWebRequest加载http://www.iplocationfinder.com/65.55.23.107之类的东西，除非你想为IP位置数据库付费。获得对HttpWebRequest的响应后，可以使用正则表达式来解析位置名称，如果需要的话，可以使用正则表达式来解析纬度和经度。|offset|length|4978358|entityMap|0|LINK|mutability|MUTABLE|url|http://www.iplocationfinder.com/65.55.23.107^0|0|0|Z|18|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@$I|V|J|W|1|X]]|A|$]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]]]

The simplest solution is to do a DNS lookup, then use an IP location service as Cody suggested. Try this:

<pre><code>var foo = Dns.GetHostEntry("database.windows.net");
</code></pre>

Once you've got your IP address, you'll need to load something like <a href="http://www.iplocationfinder.com/65.55.23.107" rel="nofollow">http://www.iplocationfinder.com/65.55.23.107</a> using an HttpWebRequest, unless you want to pay for an IP location database. Once you've got the response to the HttpWebRequest, you can use a regular expression to parse the location name, or latitude and longitude if you need that instead.

blocks|key|4978261|text|您的公司是否有这么多服务器在一夜之间移动，或者这是为了云数据库设置？IP地址可能是一个基本的错误--总比什么都没有好。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4978262|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Do you have so many servers which are moved around overnight in your company or is this for a cloud db setup? the IP address is probably a basic inaccurate-better than nothing starting point.

blocks|key|3079937|text|正如Davide+Piras提到的，例如，您可以使用这个站点：http://ip-lookup.net/来跟踪您的DB服务器的IP地址，并且您可以使用常规表达式或http://htmlagilitypack.codeplex.com/来获取输出。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3079938|但是，只有当你可以得到你的数据库服务器的IP地址时才能工作，我认为这不应该是问题，因为你需要连接字符串的IP。|3079939|要使用WebBrowser控件来实现此目的，请执行webbrowser1.navigate("http://ip-lookup.net/");操作，而不是：|style|CODE|3079940|HtmlElementCollection+elc+=+this.webBrowser1.Document.GetElementsByTagName("input");
++++++++++++foreach+(HtmlElement+el+in+elc)
++++++++++++{
++++++++++++++++if+(el.GetAttribute("type").Equals("text")+&&+el.GetAttribute("name").Equals("ip"))
++++++++++++++++{
++++++++++++++++++++el.InnerText+=+"Server+IP";
++++++++++++++++}
++++++++++++}|code-block|syntax|javascript|3079941|接下来：|3079942|HtmlElement+form+=+webBrowser1.Document.GetElementById("form_single_IP");
++++++++++++if+(form+!=+null)
++++++++++++++++form.InvokeMember("submit");
+++++++++++++//Submit+the+form|3079943|并尝试过滤输出，因为我不太擅长使用正则表达式.You可以通过使用webbrowser1.DocumentText;捕获输出|3079944|entityMap|0|LINK|mutability|MUTABLE|url|http://ip-lookup.net/|1|http://htmlagilitypack.codeplex.com/^0|V|L|0|29|10|1|0|0|P|1A|0|0|0|0|W|P|0^^$0|@$1|2|3|4|5|6|7|14|8|@]|9|@$A|15|B|16|1|17]|$A|18|B|19|1|1A]]|C|$]]|$1|D|3|E|5|6|7|1B|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|1C|8|@$A|1D|B|1E|H|I]]|9|@]|C|$]]|$1|J|3|K|5|L|7|1F|8|@]|9|@]|C|$M|N]]|$1|O|3|P|5|6|7|1G|8|@]|9|@]|C|$]]|$1|Q|3|R|5|L|7|1H|8|@]|9|@]|C|$M|N]]|$1|S|3|T|5|6|7|1I|8|@$A|1J|B|1K|H|I]]|9|@]|C|$]]|$1|U|3|-4|5|6|7|1L|8|@]|9|@]|C|$]]]|V|$W|$5|X|Y|Z|C|$10|11]]|12|$5|X|Y|Z|C|$10|13]]]]

As Davide Piras mentioned you can use for example this site : <a href="http://ip-lookup.net/" rel="nofollow">http://ip-lookup.net/</a> to trace the IP Address of you're DB Server and you can grab the Output maybe using Regular Expresion's or <a href="http://htmlagilitypack.codeplex.com/" rel="nofollow">http://htmlagilitypack.codeplex.com/</a> .

Bu that works only if you can get you're DB Server IP Address ,which i think shouldn't be an Issue because you need the IP for the Connection String .

To achieve that use a WebBrowser Control ,do <code>webbrowser1.navigate("http://ip-lookup.net/");</code> 
than :

<pre><code>HtmlElementCollection elc = this.webBrowser1.Document.GetElementsByTagName("input");
 foreach (HtmlElement el in elc)
 {
 if (el.GetAttribute("type").Equals("text") &amp;&amp; el.GetAttribute("name").Equals("ip"))
 {
 el.InnerText = "Server IP";
 }
 }
</code></pre>

next : 

<pre><code>HtmlElement form = webBrowser1.Document.GetElementById("form_single_IP");
 if (form != null)
 form.InvokeMember("submit");
 //Submit the form
</code></pre>

and try to filter the output because im not very good using Regex .You can capture the Output by using <code>webbrowser1.DocumentText;</code>

blocks|key|772697|text|为什么不用数据库告诉你位置呢？为了澄清我的意思：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|772698|Using+SQL+CLR+Stored+Procedure+To+Track+IP+Address+-但是让CLR存储过程返回托管它的服务器的on地址。|offset|length|772699|我看到了您向Cody提到的azure连接字符串，并认为这将是一个很方便的链接：http://blogs.msdn.com/b/windowsazure/archive/2011/07/06/windows-azure-deployments-and-the-virtual-ip-address.aspx|772700|Get+Azure+public+IP+address+from+deployed+app|772701|entityMap|0|LINK|mutability|MUTABLE|url|http://midnightprogrammer.net/post/2010/04/24/Using-SQL-CLR-Stored-Procedure-Track-IP-Address.aspx|1|http://blogs.msdn.com/b/windowsazure/archive/2011/07/06/windows-azure-deployments-and-the-virtual-ip-address.aspx|2|https://stackoverflow.com/questions/5329118/get-azure-public-ip-address-from-deployed-app^0|0|0|1E|0|0|13|35|1|0|0|19|2|0^^$0|@$1|2|3|4|5|6|7|V|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|W|8|@]|9|@$D|X|E|Y|1|Z]]|A|$]]|$1|F|3|G|5|6|7|10|8|@]|9|@$D|11|E|12|1|13]]|A|$]]|$1|H|3|I|5|6|7|14|8|@]|9|@$D|15|E|16|1|17]]|A|$]]|$1|J|3|-4|5|6|7|18|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q]]|R|$5|M|N|O|A|$P|S]]|T|$5|M|N|O|A|$P|U]]]]

Why not use the database to tell you the location? To clarify what I mean:

<a href="http://midnightprogrammer.net/post/2010/04/24/Using-SQL-CLR-Stored-Procedure-Track-IP-Address.aspx" rel="nofollow noreferrer">Using SQL CLR Stored Procedure To Track IP Address</a> - but make the CLR sproc return the ipaddress of the server its hosted on.

I saw the azure connection string you mentioned to Cody and thought these would be a handy links:
<a href="http://blogs.msdn.com/b/windowsazure/archive/2011/07/06/windows-azure-deployments-and-the-virtual-ip-address.aspx" rel="nofollow noreferrer">http://blogs.msdn.com/b/windowsazure/archive/2011/07/06/windows-azure-deployments-and-the-virtual-ip-address.aspx</a>

<a href="https://stackoverflow.com/questions/5329118/get-azure-public-ip-address-from-deployed-app">Get Azure public IP address from deployed app</a>

blocks|key|4978434|text|确定时区可能是您在SQL+Server中所能做的最好的工作，但根据您的描述，这可能就足够了。您可以使用此查询获取服务器所在时区的GMT偏移量：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4978435|SELECT+DATEDIFF(hh,+GETUTCDATE(),+GETDATE())+AS+ServerTimeZone|code-block|syntax|javascript|4978436|从这个结果中，您可以很容易地添加一些逻辑来返回时区缩写，例如EST、CST等。我知道这不是很多，但希望它能有所帮助。|offset|length|style|CODE|4978437|entityMap^0|0|0|U|3|Y|3|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@$I|R|J|S|K|L]|$I|T|J|U|K|L]]|9|@]|A|$]]|$1|M|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|N|$]]

Determining the time zone is probably the best you can do from SQL Server, but that could be enough for you based on your description. You can use this query to get the GMT offset of the time zone where the server is located:

<pre><code>SELECT DATEDIFF(hh, GETUTCDATE(), GETDATE()) AS ServerTimeZone
</code></pre>

From this result, you can easily add some logic to return the time zone abbreviation, i.e. <code>EST</code>, <code>CST</code>, etc. I know this isn't much, but hopefully it helps.

blocks|key|4695350|text|如果有人已经物理地移动了服务器，为什么不编写一些脚本将相应的位置写到DB中呢？当机器启动时，自动启动该工具，并让"mover“选择一个位置。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4695351|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

If someone already physically moves the server, why not write some script that writes the corresponding location to DB? When the machine starts up, auto-start that tool and have the "mover" select a location.

I am tasked to get the location where our SQL Server database is geographically located via C# code because it may vary time to time due to frequent relocation of our database to protect it from physical and cyber harm. Is this possible or another dream of my boss thanks in advance.

How can i know the actual geographical location of a database?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云AI代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

功能1上新10个字符

功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符。

功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符。

功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符

功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符

功能4上新

文章&问答评论现已支持表情

全新交互，全新视觉，新增快捷键、悬浮工具栏、高亮块等功能并同时优化现有功能，全面提升创作效率和体验

社区富文本编辑器全新改版！诚邀体验～ 

精选全网热门MCP server，让你的AI更好用 🚀

💥开发者 MCP广场重磅上线！

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我的任务是通过C#代码获取我们的SQL Server数据库的地理位置，因为为了保护数据库免受物理和网络危害，它可能会随时间而变化。这是不是有可能，或者是另一个我的老板提前感谢的梦。

问我如何知道数据库的实际地理位置？
EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问我如何知道数据库的实际地理位置？EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问我如何知道数据库的实际地理位置？
EN