winform connection to hosted database

Question

0.00/5 (No votes)

See more:

VS2012

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

Posted 11-Feb-14 1:25am

dash2020

Updated 11-Feb-14 1:26am

v2

Add a Solution

Comments

Richard chiu 13-Feb-14 5:54am

what is the error message you get ?? check to see that required port is configured to allow access to the database (default port for mssql = 1433)

3 solutions

Solution 3

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

Posted 13-Feb-14 17:21pm

dash2020

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abhinav S · Accepted Answer · 2014-02-13T16:32:00

Solution 2

Try http://connectionstrings.com for help.

Posted 13-Feb-14 16:32pm

Abhinav S

dash2020 · Accepted Answer · 2014-02-13T16:28:00

Solution 1

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.

Posted 13-Feb-14 16:28pm

dash2020

Comments

[no name] 13-Feb-14 22:53pm

Could you please advise the error message that you get? Are you sure that you have input correct connection string? Please just advise the error message, so we will close to the problem. :)

dash2020 13-Feb-14 23:22pm

yes ..I've found the solution..thanks