.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Sharon Maxwell
Post New Web Links

how to connect to Remote mySql Server?

Posted By:      Posted Date: November 29, 2010    Points: 0   Category :ASP.Net
 

Hi there,

i have installed mysql server on linux on remote server.

now i want to connect it from my local mysql server which is on windows.

whenever i connect to mysql server i get the error 

Error No: 1130

Host '192.168.15.222' is not allowed to connect to this mysql server.

this= my remote server which is on linux...

please help how to connect it?

Error No. 1130
Host '192.168.15.222' is not allowed to connect to this MySQL server






View Complete Post


More Related Resource Links

need help about "Unable to connect to remote server." using HttpWebRequest

  


Hello friends 
I am creating an application where I want to store an html page from one of my websites into another web site. 
For the same purpose I am taking the url of the html pages 
for example if I want to copy this page "http://mydomain.com/html/page1.html" then i take this url from a text box which user enters.

SSRS 2008 - report manager: System.Net.WebException: Unable to connect to the remote server

  
I have an instance of Reporting Services 2008 running on Windows 2003 server.  So, the webservice URL is running on port 801, and runs fine (I can browse reports from that directory, and upload / deploy new reports and overwrite existing reports. Report manager is set to use port 800 (IIS is also on that machine running port 80).  When I attempt to connect to report manager, I get the following error, with a link to "Home" in report manager (which brings me back to the existing error page):    Unable to connect to the remote server  In the logfiles for reporting services, the following error is there: " System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it.   Any ideas? Windows Firewall is NOT running on this machine.   Thanks, Chrisrjp

(XP Professional sp3) Cannot connect vs 2008 professional edition to remote sql server 2008 on hosti

  

Hi,

I can  successfully connect Sql Server Management Studio 2008 express with remote sql server 2008 on hosting machine but when I try to add connection in vs 2008 professional edition by following the same procedure which i did in ssms to connect with remote sql 2008 I cannot connect, no dialog box appear in select a database list is empty but when i click test connection it says connection successful. However vs 2008 is  connected sucessfully on local sql 2008 express.

I would appreciate if some one could give useful suggestion.



System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketExcept

  

I have a scenario where there is a web service (WS2) which resides behind WSLX authentication. There is another web service (WS1) which is outside of this WSLX authentication. Now we have blackberry application which calls WS1 & send its login credentials which gets passed to WS2 & token is returned back to the blackberry app. For subsequent request the same token is passed in order to ensure that it is the same session. I have seen the similar error as mentioned below earlier in the log but now after migration to SQL 2005 from SQL 2000 this has become more frequent. The error is:

 

System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: 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     at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)     at System.Net.Sockets.Socket.InternalConnect(EndPoint remoteEP)     at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception& exception)    

MySQL: can't connect from remote client code

  

Hi
I have a MySQL data at a web hotel. I can connect to the database from my web application hosted at the hotel . But trying to connect from a client application running on my PC fails using the same ConnetionString. The error is: Unable to connect to any of the specified MySQL hosts

In fact the method below (the method is protected in the web application) fails in my client application but works in my web application.

private void button8_Click(object sender, EventArgs e)
{
string MyConString = "server=db.MYSITE.dk;user;" +
"pwd=PASSWORD;database=DATABASE" ;

label1.Text = label1.Text + MyConString;

MySqlConnection connection = new MySqlConnection();
connection.ConnectionString = MyConString;

try
{
connection.Open();
}
catch (MySqlException ex)
{
label7.Text = ex.Message;
}

}

I just tried to download WorkBench 5.2 and HeidiSQL, both connects to the database from my PC when supplying server and password information.

Any help that will allow me to connect to the database from my client application I much appreciated. I use connector 6.2.4

Lars-Bo

 


Error : Unable to connect to the remote server, When using web service in window service

  
Hi All,

          I want to consume a web service in windows service but in windows service I am not able to access  web service. I have tried it in windows application and web application it is working fine but in windows service  it is not accessible.

 

i am getting error:-   at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
   at System.Net.Sockets.Socket.InternalConnect(EndPoint remoteEP)
   at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception& exception)--->   at System.Net.HttpWebRequest.GetRequestStream()
   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
   at Testmachone.MachWebRef.SimCardWS.ProvisionImsiCard(String MsMin, String MsEsn, String CardId, String UserId, String Password, String MscId, String BId, String NewValue, ActionTypes Command, String MDN, String COS, String MIP_KEY, String MEID, String RADIUSPassword, String IMSI, Boolean PrePaid)

 any body can help me what could be issue

 
<

The underlying connection was closed: Unable to connect to the remote server.

  

Hello,

 

I get this error message when i kick off my web service to run. It gathers survey feedback from a database via http soap. Recently i put in a proxy that is required for access to internet. The web service started to fail that day as well. Can anyone tell me how i could hard code the proxy that should be used by the web service? I found this link: http://support.microsoft.com/kb/307220

and tried editing the machine.config file but that didn't fix my issue. Any Ideas?

 

Error:

 

8/2/2007 1:02:25 PM
The underlying connection was closed: Unable to connect to the remote server.
   at System.Net.HttpWebRequest.CheckFinalStatus()
   at Syst

How to connect a remote Sqlserver 2008 r2 server with IP address and port? I use SMO and VS2010.

  

how to write SMO's conn.ConnectionString with IP address and port?


How To connect remote server in windows form application

  

Hi All

i have implementing one Windows application in that i need to get the Forex market quotes values form perticulat server how can i implement this i have some Php Code but i need to in C# application.

This is my Php code to receive the quotes form server;

define('T_HOST','1.1.1.1');  // MetaTrader Server Address  

define('T_PORT',443);                   // MetaTrader Server Port
define('T_TIMEOUT',1);                  // MetaTrader Server Connection Timeout, in sec

define('T_QUOTES','GBPUSD,EURUSD,AUDUSD,NZDUSD,USDCHF,USDJPY,USDCAD,GBPJPY,GBPCHF,EURGBP,EURCHF,EURJPY,EURAUD,EURNZD,EURCAD,CHFJPY,CADJPY,CADCHF,AUDJPY,NZDJPY,'); // symbols list for publication

define('T_CACHEDIR','cache/');         // cache files directory
define('T_CACHETIME',1);               // cache expiration time, in sec

define('T_CLEAR_DELNUMBER',1);        // limit of deleted files, after which process of cache clearing should be stopped

$MQ_CLEAR_STARTTIME = 0; // time
$MQ_CLEAR_NUMBER = 0;    // deleted files counter


// query quotes and parse result
$q = "QUOTES-".T_QUOTES;
                          // $re=MQ_Query($q);
$qRes = MQ_Query($q);
function MQ_Query($query,$cacheDir=T_CACHEDIR,$cacheTime=T_CACHETIME,$cacheDirPrefix='')
  {

   $ret = 

problem to connect mysql remote db

  

hi friends,

i am getting problem to connect to my remote sqlserver database..

i have connection string as follows

<

add name="ConnStr" connectionString="DRIVER={MySQL ODBC 3.51 Driver};SERVER=209.190.85.47;PORT=3306;DATABASE=mydb name;UID=username;PASSWORD=mypasswd;OPTION=3;" />

 

i am giving all information correctly..

mocking we service - Unable to connect to the remote server

  

I wanto to use a mocking web service, mocked with Soapui.But when I close the

main web service(stop the locally created web service in IIS) and try to call the mocked web service from an asp.net

project I got the error "Unable the connect the remote server".

How can I connect a mocked web service when having no connection to the actual web service.

Are anyone have any suggestion.


Unable to connect to the remote server

  
I have this Web Service that was made available on the Internet. Using its WSDL file I created a Web Reference in my VS.NET 2005 project. The problem is that every time I try to invoke any of its web methods I get the same exception: "Unable to connect to the remote server!". Hitting the same ws with XML Spy returns the expected SOAP responses so I am thinking that I have something wrong in my IDE. Can anyone make a suggestion where to look and what else to try?
Any suggestion will be highly appreciated.
Thanks in advance,
Eddie

WebClient.DownloadString(),Unable to connect Remote Server

  

Hi ,

I want to translate from English to Malay using Google API.

I have the following code:

public static string TranslateText(string input, string languagePair, Encoding encoding)
    {
      string url = String.Format("http://www.google.com/translate_t?hl=en&ie=UTF8&text={0}&langpair={1}", input, languagePair);
            
      string result = String.Empty;

      using (WebClient webClient = new WebClient())
      {
        webClient.Encoding = encoding;
        NetworkCredential netcredit = new NetworkCredential("MyNetworkUserID", "MyNetworkPassword", "corp");
        webClient.Credentials = netcredit;
        webClient.Proxy = new System.Net.WebProxy()
        {
            Credentials = new System.Net.NetworkCredential("MyNetworkUserID", "MyNetworkPassword", "corp")
        };
       // webClient.Proxy = null;//if I don't give webClient.Proxy-it returns Error "407-ProxyAuthentication Required!"
        result = webClient.DownloadString(url);
          // result = webClient.DownloadString("http://www.google.com/");//just to check with google itself,still the same error
       
      }

      Match m = Regex.Match(result, "(?<=<div id=result_box dir=\"ltr\">)(.*?)(?=</div>)");

WebClient.DownloadString(),Unable to connect Remote Server

  

Hi ,

I want to translate from English to Malay using Google API.

I have the following code:

public static string TranslateText(string input, string languagePair, Encoding encoding)
    {
      string url = String.Format("http://www.google.com/translate_t?hl=en&ie=UTF8&text={0}&langpair={1}", input, languagePair);
            
      string result = String.Empty;

      using (WebClient webClient = new WebClient())
      {
        webClient.Encoding = encoding;
        NetworkCredential netcredit = new NetworkCredential("MyNetworkUserID", "MyNetworkPassword", "corp");
        webClient.Credentials = netcredit;
        webClient.Proxy = new System.Net.WebProxy()
        {
            Credentials = new System.Net.NetworkCredential("MyNetworkUserID", "MyNetworkPassword", "corp")
        };
       // webClient.Proxy = null;//if I don't give webClient.Proxy-it returns Error "407-ProxyAuthentication Required!"
        result = webClient.DownloadString(url);
          // result = webClient.DownloadString("http://www.google.com/");//just to check with google itself,still the same error
       
      }

      Match m = Regex.Match(result, "(?<=<div id=result_box dir=\"ltr\">)(.*?)(?=</div>)");

  

User failed to connect remote sql server DB

  

Hi,

I have an Prod issue that,sql server user not bale to login from his machine to Remote SQL server DB.

I am getting the below message as an error:

 

Date 11/29/2010 1:09:52 PM

Log SQL Server (Current - 11/29/2010 12:47:00 PM)

Source Logon

Message

Login failed for user 'test'. Reason: Login-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: 10.13.204.6]

 

 

Please provide solution for the above error.

 

Thanks,

Ron.


want to connect with remote sql server to mobile pocket pc

  

hi,

 

I am using mobile 5.0 pocket pc. i have developed one application and its running success fully. Now i want to fetch the data from remote server having sql sever 2008 or sql server 2005. here is the code for it

private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                SqlConnection connection = new SqlConnection("Server=servername;Initial Catalog=dbname;User ID=username;Password=password;Integrated Security=false;");
                SqlCommand command = connection.CreateCommand();
                command.CommandText = "select top 1 id from empinfo";
                connection.Open();
                label1.Text = command.ExecuteScalar().ToString();
               

how to connect remote sql server on non domain network using SQL Server authentication

  

Hai.

i m newbie on sqlserver.I had manage to build a database (MS SQL SERVER 2005 standard) with a vb.net 2008 and tested well with local machine. and wanted to put a software on client. and   some-how manage to stucture a security model on server authentication. but still not clear on user management. and others.

will anybody help me step by step how to connect remote sql server on non domain network using SQL Server authentication

 

Thanking you advance

 


Inaocha
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend