winform连接到托管数据库 [英] winform connection to hosted database

问题描述

大家好，



我在外面托管了一个数据库。我们有现有的应用程序，可以访问此数据库。 （我不知道它是如何开发的）



我的目标是开发一个自定义的窗体表格来内部访问这个数据库。我正在使用visual studio 2012（vb.net） sql verion是sql2008



目前我可以通过远程桌面连接访问这个数据库。



我有gridview如果我使用本地数据库，它可以加载未付费的发票。但如果我把连接字符串作为托管数据库，它就不起作用。



MY connectionstring如下。



connectionString =数据源= INSTANCE / SQLEXPRESS;初始目录= DBNAME;用户ID = sa;密码= ABC123



请帮我这个

解决方案

尝试 http://connectionstrings.com 寻求帮助。

< blockquote>嗨
感谢您的回复。我可以说我找到了解决方案，因为我可以从托管数据库加载数据

而不是TCP端口我使用过TCP动态端口魔术对我来说..

过去三天我一直在寻找这个解决方案。

谢谢Abhinav S



您能否看看我发布的另一个问题



http://www.codeproject.com/Questions/726854/add-电子邮件地址从 - gridview的到新的电子邮件-BCC

Hi All,

I have a database hosted outside. we have existing application which has access for this database. (I dont how it was developed)

My aim is to develop a customized windows form to access this database internally.I am using visual studio 2012 (vb.net) sql verion is sql2008

currently I can access this database through remote desktop connection.

I have gridview to load unpaid invoice/s, it works if I use local database. but if I put connection string as hosted database it doesnt work.

MY connectionstring is as below.

connectionString="Data Source=INSTANCE/SQLEXPRESS;Initial Catalog=DBNAME;User ID=sa;Password=ABC123

please help me with this

解决方案

Try http://connectionstrings.com for help.

Hi Thanks for your response. I can say that I found solution as I can load data from hosted database
instead of TCP port I have used 'TCP dynamic ports' which worked as magic for me..
I've been searching for this solution for last three days.

Thanks Abhinav S

Can you please have a look at another question posted by me

http://www.codeproject.com/Questions/726854/add-email-address-from-gridview-to-new-emails-bcc

这篇关于winform连接到托管数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！