{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 兄弟一词,经得起流年. 的问题《how to connect to another sql server database(serv》','https://www.manongdao.com/q-924993.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
i m creating an application, inwhich client has to acces a database stored in a remote location connnected through a live ip. how can i connect simply with a database server placed in LAN. both using sql server 2005 express edition. please refer me or help me on this
相关问题
- keeping one connection to DB or opening closing pe
- Quickest method for matching nested XML data again
- What are IN and OUT parameter in SQL Server
- How to migrate a database from SQL Server 2005 to
- Cannot insert NULL values into column 'USERNAM
相关文章
- Convert column to string in SQL Select
- Why not “Invalid column name XYZ” error in subquer
- Create @TableVariable based on an existing databas
- Convert bit type to Yes or No by query Sql Server
- Best Isolation Level to avoid deadlocks using an U
- How can i use pivot?
- Update and insert to one table from another
- Storing SSN/CC data
Also, make sure to configure your SQL Server Express to allow remote connections! Those are disabled by default after installation.
Check out the SQL Server Surface Configuration tool (if I'm not mistaken) to configure these settings.
Marc
This not about programming. You have forward the port which Sql Server uses on modem.
Set in your connection string IP address of remote server. E.g.
where 192.168.0.13 is your remote server IP and MyDb is your database name.