如何制作在线软件? [英] How can I make online software?
问题描述
如果Clint在其他城市，而服务器在其他城市，那么连接字符串将是什么
这是本地计算机的连接字符串.
< pre lang ="vb">
公共函数connection()作为SqlConnection
con =新的SqlConnection(&"server =(local); database = info; uid = sa; pwd =& quot;)
返回con
最终功能
请任何人告诉我连接字符串会出现什么
我觉得好像
公共函数connnection()作为SqlConnection
con =新的SqlConnection(&服务器= ipaddress/192.168.1.1;数据库=信息; uid = sa; pwd =& quot;)
返回con
结束功能</pre>
如果他正在使用DSL Internet连接，那么我如何知道他的IP以及如何与他的计算机连接?
If a Clint is in other city and server is other city then what will be connection string
This is connection string fro local machine.
<pre lang="vb">
Public Function connection() As SqlConnection
con = New SqlConnection("server=(local);database=info;uid=sa;pwd=")
Return con
End Function
Please any one tell me what will be there CONNECTION string
I think it seems like
Public Function connnection() As SqlConnection
con = New SqlConnection("server=ipaddress/192.168.1.1;database=info;uid=sa;pwd=")
Return con
End Function</pre>
If he is using dsl internet connection so how I can know his ip and how I connect with his computer?
推荐答案
首先，您需要在自己的计算机上设置端口转发DSL调制解调器和任何路由器，您都必须将来自Internet的任何请求从端口1433转发到您的计算机，还要在任何防火墙中打开端口1433，然后需要为Clint提供您的公共IP地址，而不是由ISP分配的192.168.1.1 ，如果您的调制解调器重置，或者您的ISP未分配静态地址，则可能会更改.
连接字符串变为；
First you need to set-up Port Forwarding in your DSL modem and any routers you have to forward any requests from the internet on port 1433 to your computer, also open port 1433 in any firewalls, then you need to give Clint your public IP address, NOT 192.168.1.1 it is assigned by your ISP, which may change if your modem resets, if your ISP doesn''t assign static addresses.
Connection string becomes;
Data Source=Your Public IP Address,1433;Network Library=DBMSSOCN;Initial Catalog=YouDataBase;User ID=myUsername;Password=myPassword;
这假定Clint需要连接到您计算机上的数据库，具有数据库的计算机不会启动连接.
This assumes that Clint needs to connect to the database on your computer, the computer with the database does not initiate the connection.
一些建议
1.不要公开您的SQL Server
2.使用其他选项访问诸如Web服务之类的数据.
3.您需要在服务器端使用静态IP.
Some advice
1. Don’t expose your SQL Server
2. Use some other option to access data like web service.
3. You need a static IP at your server end.
这篇关于如何制作在线软件?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
