Access database from live IP

Question

1.00/5 (2 votes)

See more:

Hi,
I have asp.net website. Where I am making a payment. After payment I am inserting IPN data into database. My code is working fine when I am accessing my database from local pc or in network. I have configured my application in IIS from my pc which is live IP. I can access my all pages. But when I am accessing from live url, I can not access my database.

I have mysql database
I have a database in my local server.
I want to access database from live.
How can i get connectionstring for live.

Please anyone help me....

Posted 22-Aug-12 21:28pm

ravi sharma11

Add a Solution

Comments

[no name] 24-Aug-12 9:26am

You already have a connection string otherwise it would not work from your local machine. Change your connection string to point to where your server is.

ravi sharma11 25-Aug-12 1:38am

Actually I am also new developer and trying to make a payment from paypal and webservice. No senier is available to tell me atleast 1 word. So please help me

ravi sharma11 25-Aug-12 1:42am

Actually I have removed connection string and all code for insertion in database and kept a code to generate log in web service but still web service not calling.
In local machine, Web service working well....

1 solution

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)

I.explore.code · Answer 1 · 2012-08-22T21:55:00

Solution 1

may be your MySQL server is not allowing remote connections. I m not sure which setting thats under but in SQL Server Configuration you just have to check "Allow remote TCP/IP connections" or something like that and you are done. See if MySQL has similar settings.

Posted 22-Aug-12 21:55pm

I.explore.code

Comments

ravi sharma11 23-Aug-12 5:43am

Actually when I am running programme from local database, It is working but from remote, It is not working. Is it codding problem ????????

I.explore.code 23-Aug-12 5:48am

my guess is your database server hasn't been set to allow remote connections from a URL other than localhost. When you access your external URL, your connection request comes as a TCP/IP request which is probably getting kicked-off. So do check in your server settings if it allows remote connections. If that all alright then post your code that deals with connections and we can look at it.

ravi sharma11 24-Aug-12 0:22am

We have to set it from database or IIS?????????

ravi sharma11 24-Aug-12 0:42am

The actual problem is that my client is saying that anyone makes payment from Paypal.com. It should send IPN data from paypal. I have enabled my page paypal so whenever anyone makes payment, It redirects to my page, where I am getting the value and post all the data in web service using ajax, But I can not access my web service.

In a web service I have set my connection string and database connection..
I think I can not access database or web service.

From local everything working properly.

ravi sharma11 24-Aug-12 0:55am

One more thing is that I can not access my web service from live, I think this.

I.explore.code 24-Aug-12 6:54am

Need to look into the code mate! can you post your code?

ravi sharma11 24-Aug-12 7:53am

This is paypal.aspx code where ipn data comes.

protected void Page_Load(object sender, EventArgs e)
{
string strSandbox = "https://www.sandbox.paypal.com/cgi-bin/webscr";
HttpWebRequest req = (HttpWebRequest)WebRequest.Create(strSandbox);
req.Method = "POST";
req.ContentType = "application/x-www-form-urlencoded";
byte[] param = Request.BinaryRead(HttpContext.Current.Request.ContentLength);
string strRequest = Encoding.ASCII.GetString(param);
strRequest += "&cmd=_notify-validate";
req.ContentLength = strRequest.Length;

StreamWriter streamOut = new StreamWriter(req.GetRequestStream(), System.Text.Encoding.ASCII);
streamOut.Write(strRequest);
streamOut.Close();
StreamReader streamIn = new StreamReader(req.GetResponse().GetResponseStream());
string strResponse = streamIn.ReadToEnd();
streamIn.Close();

if (strResponse == "VERIFIED")
{
lbllast_name.Text = Request["last_name"].ToString();
lblfirst_name.Text = Request["first_name"].ToString();
StreamWriter log;

if (!File.Exists(Server.MapPath("log1.txt")))
{
log = new StreamWriter(Server.MapPath("log1.txt"));
}
else
{
log = File.AppendText(Server.MapPath("log1.txt"));
}
log.WriteLine(DateTime.Now);
//PPH.State = HttpContext.Current.Request["address_state"];
lblverify_sign.Text = "verify";
lblmc_gross.Text = Request["mc_gross"].ToString();
lblprotection_eligibility.Text = "Dummy";
lbladdress_status.Text = Request["address_status"].ToString();

lblpayer_id.Text = Request["payer_id"].ToString();
lbltax.Text = Request["tax"].ToString();
lbladdress_street.Text = Request["address_street"].ToString();

lblpayment_date.Text = Request["payment_date"].ToString();
lblpayment_status.Text = Request["payment_status"].ToString();
lblcharset.Text = Request["charset"].ToString();

lbladdress_zip.Text = Request["address_zip"].ToString();
lblmc_fee.Text = Request["mc_fee"].ToString();
lbladdress_country_code.Text = Request["address_country_code"].ToString();

lbladdress_name.Text = Request["address_name"].ToString();
lblnotify_version.Text = Request["notify_version"].ToString();
lblpayer_status.Text = Request["payer_status"].ToString();

lblbusiness.Text = Request["business"].ToString();
lbladdress_country.Text = Request["address_country"].ToString();
lbladdress_city.Text = Request["address_city"].ToString();

lblpayer_email.Text = Request["payer_email"].ToString();
lbltxn_id.Text = Request["txn_id"].ToString();
lblpayment_type.Text = Request["payment_type"].ToString();

lbladdress_state.Text = Request["address_state"].ToString();
lblreceiver_email.Text = Request["receiver_email"].ToString();
lblpayment_fee.Text = "0";

lblreceiver_id.Text = Request["receiver_id"].ToString();
lbltxn_type.Text = Request["txn_type"].ToString();
lblitem_name.Text = Request["item_name"].ToString();

lblmc_currency.Text = Request["mc_currency"].ToString();
lblitem_number.Text = Request["item_number"].ToString();
lblresidence_country.Text = Request["residence_country"].ToString();

lbltest_ipn.Text = Request["test_ipn"].ToString();
log.Close();

}
else if (strResponse == "INVALID")
{
}
else
{
}
}

ravi sharma11 24-Aug-12 7:57am

This is ajax code which is post from this paypal.aspx page

<script type="text/javascript">
$(document).ready(function () {
//function CallValues() {
var mc_gross = "";
var protection_eligibility = "";
var address_status = "";
var payer_id = "";
var tax = "";
var address_street = "";
var payment_date = "";
var payment_status = "";
var charset = "";
var address_zip = "";
var first_name = "";
var mc_fee = "";
var address_country_code = "";
var address_name = "";
var notify_version = "";
var payer_status = "";
var business = "";
var address_country = "";
var address_city = "";
var payer_email = "";
var verify_sign = "";
var txn_id = "";
var payment_type = "";
var last_name = "";
var address_state = "";
var receiver_email = "";
var payment_fee = "";
var receiver_id = "";
var txn_type = "";
var item_name = "";
var mc_currency = "";
var item_number = "";
var residence_country = "";
var test_ipn = "";
var handling_amount = "";
var transaction_subject = "";
var payment_gross = "";
var shipping = "";

mc_gross = document.getElementById("lblmc_gross").innerHTML;
protection_eligibility = document.getElementById("lblprotection_eligibility").innerHTML;
address_status = document.getElementById("lbladdress_status").innerHTML;
payer_id = document.getElementById("lblpayer_id").innerHTML;
tax = document.getElementById("lbltax").innerHTML;
address_street = document.getElementById("lbladdress_street").innerHTML;
payment_date = document.getElementById("lblpayment_date").innerHTML;
payment_status = document.getElementById("lblpayment_status").innerHTML;
charset = document.getElementById("lblcharset").innerHTML;
address_zip = document.getElementById("lbladdress_zip").innerHTML;
first_name = document.getElementById("lblfirst_name").innerHTML;
mc_fee = document.getElementById("lblmc_fee").innerHTML;
address_country_code = document.getElementById("lbladdress_country_code").innerHTML;
address_name = document.getElementById("lbladdress_name").innerHTML;
notify_version = document.getElementById("lblnotify_version").innerHTML;
payer_status = document.getElementById("lblpayer_status").innerHTML;
business = document.getElementById("lblbusiness").innerHTML;
address_country = document.getElementById("lbladdress_country").innerHTML;
address_city = document.getElementById("lbladdress_city").innerHTML;
payer_email = document.getElementById("lblpayer_email").innerHTML;
verify_sign = document.getElementById("lblverify_sign").innerHTML;
txn_id = document.getElementById("lbltxn_id").innerHTML;
payment_type = document.getElementById("lblpayment_type").innerHTML;
last_name = document.getElementById("lbllast_name").innerHTML;
address_state = document.getElementById("lbladdress_state").innerHTML;
receiver_email = document.getElementById("lblreceiver_email").innerHTML;
payment_fee = document.getElementById("lblpayment_fee").innerHTML;
receiver_id = document.getElementById("lblreceiver_id").innerHTML;
txn_type = document.getElementById("lbltxn_type").innerHTML;
item_name = document.getElementById("lblitem_name").innerHTML;
mc_currency = document.getElementById("lblmc_currency").innerHTML;

ravi sharma11 24-Aug-12 8:00am

item_number = document.getElementById("lblitem_number").innerHTML;
residence_country = document.getElementById("lblresidence_country").innerHTML;
test_ipn = document.getElementById("lbltest_ipn").innerHTML;
handling_amount = document.getElementById("lblhandling_amount").innerHTML;
transaction_subject = document.getElementById("lbltransaction_subject").innerHTML;
payment_gross = document.getElementById("lblpayment_gross").innerHTML;
shipping = document.getElementById("lblshipping").innerHTML;
//alert("this is ajax");
$.ajax({
type: "POST",
url: "WebService.asmx/GetData",
data: "mc_gross='" + mc_gross + "'&protection_eligibility='" + protection_eligibility + "'&address_status='" + address_status + "'&payer_id='" + payer_id + "'&tax='" + tax + "'&address_street='" + address_street + "'&payment_date='" + payment_date + "'&payment_status='" + payment_status + "'&charset='" + charset + "'&address_zip='" + address_zip + "'&first_name='" + first_name + "'&mc_fee='" + mc_fee + "'&address_country_code='" + address_country_code + "'&address_name='" + address_name + "'¬ify_version='" + notify_version + "'&payer_status='" + payer_status + "'&business='" + business + "'&address_country='" + address_country + "'&address_city='" + address_city + "'&payer_email='" + payer_email + "'&verify_sign='" + verify_sign + "'&txn_id='" + txn_id + "'&payment_type='" + payment_type + "'&last_name='" + last_name + "'&address_state='" + address_state + "'&receiver_email='" + receiver_email + "'&payment_fee='" + payment_fee + "'&receiver_id='" + receiver_id + "'&txn_type='" + txn_type + "'&item_name='" + item_name + "'&mc_currency='" + mc_currency + "'&item_number='" + item_number + "'&residence_country='" + residence_country + "'&test_ipn='" + test_ipn + "'&handling_amount='" + handling_amount + "'&transaction_subject='" + transaction_subject + "'&payment_gross='" + payment_gross + "'&shipping='" + shipping + "'",
success: function (msg) {
//alert("You have done...");
}
});

});

</script>

I.explore.code 24-Aug-12 8:38am

Ridiculous! downvoting my suggestion without putting forth a better one or even caring to tell what was wrong with mine, is just awful!

[no name] 24-Aug-12 9:27am

Countered lackwit vote

I.explore.code 24-Aug-12 9:48am

Thanks Wes! I really appreciate a good debate and I am not afraid of being proven wrong. The OP's spaghetting commenting in solution boxes has just thrown off my brain circuits so I have decided not to answer any more of his questions today. Feel free to take the baton ahead though! :)

[no name] 24-Aug-12 9:51am

I don't blame you. I don't spoon feed people that do not show the least bit of effort. His problem is perfectly clear and I do not have the patience to teach someone how to perform basic programming tasks most days. :-)

ravi sharma11 24-Aug-12 8:40am

This is a code in web service

public void GetData(string mc_gross, string protection_eligibility, string address_status, string payer_id, string tax, string address_street, string payment_date, string payment_status, string charset, string address_zip, string first_name, string mc_fee, string address_country_code, string address_name, string notify_version, string payer_status, string business, string address_country, string address_city, string payer_email, string verify_sign, string txn_id, string payment_type, string last_name, string address_state, string receiver_email, string payment_fee, string receiver_id, string txn_type, string item_name, string mc_currency, string item_number, string residence_country, string test_ipn, string handling_amount, string transaction_subject, string payment_gross, string shipping)
{

StreamWriter log;
if (!File.Exists(Server.MapPath("log.txt")))
{
log = new StreamWriter(Server.MapPath("log.txt"));
}
else
{
log = File.AppendText(Server.MapPath("log.txt"));
}

log.WriteLine("******************This is web service Data******************");

log.WriteLine("Inserte Complete");
log.Close();
}

Actually I am getting all data into logfile but can not access web service