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


Top 5 Contributors of the Month
david stephan
Asad Ali
Post New Web Links

want to connect with remote sql server to mobile pocket pc

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :Windows Application
 

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();
               


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)    

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 = 

Cannot connect 2010 Access 2010 Excel or PowerPivot to Mobile SQL(SQL Server Compact) - SDF files

  
I've believe I've installed everything to read Mobile SQL .SDF files.  I've insalled Sql Server Management Studio, Sql Server 2008 R2, .NET 4.0 Framework and just about everything else I've read to see the contents of an .SDF file created for what I read directly from these product sources as this DotNet Compact Framework is the greatest new SQL stuff on the planet.  I can connect using the Management Studio and see the TABLE Stucture easy enough and I can query using some simple SQL Commands from the Management Studio but what really bugs me is if this is all so wonderful, how come I cannot connect to what the SQL Server 2008 R2 Server type "SQL Server Compact" Authentication: "SQL Server Compact Authentication in Office 2010 Access, Excel or even "WOW" PowerPivot!  I've run across a couple 3rd party .SDF Readers - one that exports to Excel such as flyhoward.com  I'm growing old with all the work around import export stuff and just want to use PowerPivot to  excersise the data......or should I use something that actually works like Tableau??

SQL Server Mobile 2005 Merge replication failing over SSL, but can browse through pocket IE.

  

Hi All, this system is scheduled to go live in near to a day... but i have hit an issue when switching on SSL.  Any help would be greatly appreciated.

 

Device Env:

Windows Mobile 5.0 + Messaging and Security Feature Pack

SQL Server Mobile 2005.

 

Merge replication works fine without SSL.  After running the Configure Web Sync wizzard to setup SSL merge replication no longer works.  Note i checked using pocket IE by browsing to https://mycompany.com/pub/sqlcesa30.dll?diag and all worked fine.  There was no prompt saying the cert was bad etc.

 

The certificate is a:

Equifax secure global ebusiness CA-1 cert.

Signature algorithm md5RSA

public key RSA(1024 bits)

thumbprint algorithm sha1

 

Stacktrace given is:

-  ex {"A request to send data to the computer running IIS has failed. For more information, see HRESULT."} System.Data.SqlServerCe.SqlCeException
-  Errors {System.Data.SqlServerCe.SqlCeErrorCollection} System.Data.SqlServerCe.SqlCeErrorCollection
  Count 1 Integer
  

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>)");

  

how to connect to Remote mySql Server?

  

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




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.


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