Accessing Remote Database

Question

0.00/5 (No votes)

See more:

C#

ASP.NET

SQL-Server

, +

Dear All,

I have a web service as....

C#

[WebMethod]
 public DataTable DataShow()
    {
        SqlConnection cn = new SqlConnection("Server=xxx.xxx.xxx.xxx;Network Library=DBMSSOCN;Initial Catalog=xxx;uid=xxx;pwd=xxxxxxxx");
        SqlDataAdapter da = new SqlDataAdapter("Select * from xxxx", cn);
        DataSet ds = new DataSet();
        da.Fill(ds, "xxxxx");
        DataTable dt = ds.Tables[0];
        return dt;

    }

As you see it will return me a data table.. But here I am dealing with the Database server which is not local to me, Its on remote location. Because of it I am not able to connect with it.
What should I do for retrieving data from that server, I know the username and password of that server. Is my connection string correct. Please help me out.

thanks....

Posted 10-Jan-12 23:07pm

comred

Updated 10-Jan-12 23:08pm

Add a Solution

Comments

anushripatil 11-Jan-12 5:24am

can you post the error that you are getting ??

anushripatil 11-Jan-12 5:26am

connectionString="Data Source=*****;Initial Catalog=****;User ID=**;Password=****"

comred 11-Jan-12 5:58am

Error is like this:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.)

comred 11-Jan-12 6:00am

**** showing that it contains value but I cant mention here... you can consider any string right??

4 solutions

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)

Rajesh Anuhya · Answer 1 · 2012-01-11T19:44:00

Use the below connection string to connect to your remote sql server db

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

Here
Remote Sql Server Public IP: 190.190.200.100
Remote Sql server Port number : 1433

** make sure that your SSMS is connecting to this remote server or not.

Jαved · Answer 2 · 2012-01-11T19:46:00

Solution 4

This may help you-

http://www.connectionstrings.com/sql-server-2008[^]

Posted 11-Jan-12 19:46pm

Jαved

comred · Answer 3 · 2012-01-11T17:34:00

Solution 1

Any Expert Comments???? Please....

Posted 11-Jan-12 17:34pm

comred

comred · Answer 4 · 2012-01-11T19:36:00

My FTP server is not here its in USA... and I my Database is in India.. So my .aspx and .asmx files are on ftp. The web service is trying to retrieve data from from database server. and in that scene I am getting the error.

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.)

Accessing Remote Database

4 solutions

Solution 3

Solution 4

Solution 1

Solution 2

Add your solution here

Preview 0