使用移动应用程序连接远程数据库 [英] Connect Remote Database using Mobile Application

问题描述

Hi Friends

如何使用移动应用程序连接远程Sql Server 2000/2005.
我有RemoteServerIp，DatabaseName，用户名和密码.

Hi Friends

How to Connect Remote Sql Server 2000/2005 using Mobile Application.
I have RemoteServerIp, DatabaseName,Username and Password.

This is working fine with Desktop Application.

推荐答案

连接字符串为;

The connection string is;

Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;

如果您尝试从本地网络外部(例如，通过Internet)进行连接，则IP地址必须是网络的公共IP，并为端口1433设置了转发设置，以便该端口上收到的所有请求都被转发到数据库服务器.

此处 [ ^ ]是连接字符串的列表(将其添加为书签).

If you are trying to connect from outside of the local network i.e. via the internet, the IP address will have to be the public IP of the network with forwarding setup for port 1433 so that any requests that come in on that port are forwarded to the database server.

Here[^] is a list of connection strings (bookmark it).

这篇关于使用移动应用程序连接远程数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！