.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

Getting Error in Sql coding when i use it in Remote Server

Posted By:      Posted Date: September 20, 2010    Points: 0   Category :ASP.Net
 

Hai

I am getting Error in this code. I mention my ERROR in BOLD Letter in my Coding.. And i show u the Connectionstring Too.

BUt this code is working Perfectly in My local "Connectionstring"

Plz Help Me to solve this error.

Conn = New SqlConnection("Data Source=xxx.xxx.xxx.xx;Initial Catalog=xxxxxxxxxxxxx;Persist Security Info=True;User ID=xxxxxxxxxx;pwd=xxxxxxxx;MultipleActiveResultSets=True")

If (Conn.State = ConnectionState.Closed) Then
                Conn.Open()
 End If
            ErrMsg = ""
            StrQry = ""
            StrQry = " select * from MO_users where({ fn LCASE(username) } = { fn LCASE('" & Username & "') }) " & _
                      " and (CAST(password AS binary) = CAST('" & Password & "' AS binary)) and status='1'"
            Cmd = New Sql


View Complete Post


More Related Resource Links

The remote server returned an error: (405) Method Not Allowed.

  

Error:

{System.Net.WebException: The remote server returned an error: (405) Method Not Allowed.
   at System.Net.WebClient.UploadFile(Uri address, String method, String fileName)
   at System.Net.WebClient.UploadFile(Uri address, String fileName)
   at System.Net.WebClient.UploadFile(String address, String fileName)
   at Test.Page_Load(Object sender, EventArgs e) in c:\Inetpub\wwwroot\WebSite1\Test.aspx.cs:line 35}

Windows application, automated process will run on local user system...
trying to upload a file to website folder. website address: http://1.1.1.1/test/files

System.Net.WebClient wc = new WebClient();
wc.UploadFile(website address, "c:/1.pdf");

Getting error from above line.. Am doing something wrong??
I dont want to use ftp or share folder logic..
is there any other way to upload the files to server??


[SSRS 2008 R2]Report Builder Access error-The remote server returned an error: (401) Unauthorized.

  
Hello,        I am able to login Web Service URL and report manager using computer name and report builder is also working fine.  http://RPTSRV/reportserver   (RPTSRV is report server name. web service url working fine. all accessible) http://RPTSRV/reports  (report manager working fine and all accessible ,report builder too) It means I am able to access everything locally right? http://rs.test.abc.com/reportserver  (web service url working fine. all accessible)  http://rs.test.abc.com/reports    (Report manager working fine and all accessible accept report builder)(I carefully checked the link and its taking rs.test.abc.com/reportserver.....)     when I click on reportbuilder button in report manager it shows me error dialog box with following error log!! I tried from local and remote computer too but gives the same error both side. I am not sure but I am just thinking is this double hop kerberos security issue? Please help me to solve this problem. I am finding solution from last 4 days. Reporting Service configuratin tool settings Web Serivice URL -  all set to default Report Manager URL - all set to default Environment - Distributed deployment Server1(report_srv) --Windows server 2003, Installed sql server 2008R2 reporting service,

The remote server returned an error: (550) File unavailable (e.g., file not found, no access).

  
Hi.   I have read the other threads regarding this but they do not solve my problem. All i am trying to do is upload a file from the webserver onto another server via FTP. But i get the above error and am at my wits end as to why.   below is the code:   Dim fs As New FileStream("H:\Visual Studio 2005\Websites\Website1\testfile.txt", FileMode.Open) Dim filecontents(fs.Length) As Byte fs.Read(filecontents, 0, fs.Length)   Dim remotePath As String = "ftp://elonwactd.uk.ml.com/apps/files/IPBHVGTRADE/QA5/in/testfile.txt" Dim ftp As FtpWebRequest = FtpWebRequest.Create(remotePath) ftp.Credentials = New System.Net.NetworkCredential("user1", "passwd1") ftp.KeepAlive = False ftp.UseBinary = True   ' (have tried UploadFile as well instead of UploadFileWithUniqueName) ftp.Method = WebRequestMethods.Ftp.UploadFileWithUniqueName     fs.Close()   ftp.GetRequestStream.Write(filecontents, 0, filecontents.Length) ftp.GetRequestStream.Close() ftp.GetResponse.Close()     Below is the stack trace that i get. [WebException: The remote server returned an error: (550) File unavailable (e.g., file not found, no access).]   System.Net.FtpWebRequest.SyncRequestCallback(Object obj) +321   System.Net.FtpWebRequest.RequestCallback(Object obj) +19   System.Net.CommandStream.Abort(Exception e) +163   System.Net.FtpWebRequest.FinishRequestStage(RequestStage stage) +45

Error connecting to Remote report server database in SQL Server 2008 R2 DataCenter Edition

  
I am trying to configure my report server installed on Server A to point to a reporting services DB on Server B. I am able provide the name and test the connection. However, when i click next on the configuration wizard after providing the Server A name I am receiving the below error: The feature: "Remote access to report data sources and/or the report server database" is not supported in this edition of Reporting Services I have SQL Server 2008 R2 DataCenter Edition on both the servers.    

The remote server returned an unexpected response: (400) Bad Request ERROR

  
Hello I have windows application that proccess and reply to user SMS. I use a web service to send and recieve SMS.I have no access to sever and service setting and only add its reference in my application via "add Service Reference". When i call test method i get following error: "The remote server returned an unexpected response: (400) Bad Request" public void TestMethod() { OutputMessage newMessage = new OutputMessage("YYYYYYY", "XXXXXXX", MessagePriority.Medium); for (int i = 0; i < 10; i++) { ThreadStart starter = delegate() { AnotherTestMethod(newMessage); }; Thread newthread = new Thread(starter); newthread.Start(); } } private void AnotherTestMethod(OutputMessage messageToSend) { smsSoapClient _client = new smsSoapClient(); _client.Open(); string resultOfdoSendSMSCall = _client.doSendSMS("dpardazesh", "dpardazesh", "XXXXXXXX", "XXXXXXXXX", "SMS Text", true); Regex expression = new Regex("Send OK."); if (expression.IsMatch(resultOfdoSendSMSCall)) { resultOfdoSendSMSCall = resultOfdoSendSMSCall.Replace("Send OK.", string.Empty).Trim(); XDocument XmlDocument = XDocument.Parse(resultOfdoSendSMSCall); var AllMessages = from message in XmlDocument.Elements("

The remote server returned an unexpected response: (400) Bad Request ERROR

  
Hello I have windows application that proccess and reply to user SMS. I use a web service to send and recieve SMS.I have no access to sever and service setting and only add its reference in my application via "add Service Reference". When i call test method i get following error: "The remote server returned an unexpected response: (400) Bad Request" public void TestMethod() { OutputMessage newMessage = new OutputMessage("YYYYYYY", "XXXXXXX", MessagePriority.Medium); for (int i = 0; i < 10; i++) { ThreadStart starter = delegate() { AnotherTestMethod(newMessage); }; Thread newthread = new Thread(starter); newthread.Start(); } } private void AnotherTestMethod(OutputMessage messageToSend) { smsSoapClient _client = new smsSoapClient(); _client.Open(); string resultOfdoSendSMSCall = _client.doSendSMS("dpardazesh", "dpardazesh", "XXXXXXXX", "XXXXXXXXX", "SMS Text", true); } Only 2 SMS send by service. I maxReceivedMessageSize  in my app.config file but get same error again. Can anyone help me?

Error rendering "*************" web part: [The remote server returned an error: (400) Bad Request.]

  
Hi There I am implementing a WCF based solution and all was working fine until I started to process larger quantities of data. The Solution worked well in DEV where we added large quantities of daata when we restored the site to QA we got this error . Error rendering Councillors Online web part: [The remote server returned an error: (400) Bad Request.] Can anyone propose a solution to this problem? Thank you My WCF web.config looks as follows : ======================================================== <system.serviceModel>  <bindings>   <webHttpBinding>   </webHttpBinding>  </bindings>  <behaviors>   <serviceBehaviors>    <behavior name="serviceBehavior" >     <serviceMetadata httpGetEnabled="true" />    </behavior>   </serviceBehaviors>   <endpointBehaviors>    <behavior name="web">     <webHttp/>    </behavior>   </endpointBehaviors>  </behaviors>  <services>   <service name="CouncillorsOnline.Service.CouncilMasterDataService" behaviorConfiguration=

sqlcmd - linkedserver - ALL queries fails after FIRST error from remote server - ANONYMOUS LOGON

  
Hello, I have very strange problem with sqlcmd , it stop working after first error returned from remote sql server (like permission denied), lets try show what I'm doing, configuration is quite simple C- client (windows 2003 x64, standalone sqlcmd client sp3) S1 - server1(windows 2003 x64, sql 2005 sp3) S2 - server2 (windows 2003 x64, sql 2005 sp3) I need connect via middle Linked Server (S1) from C to to S2, each machines have the same LOCAL Windows account C\LSUser, S1\LSUser, S2\LSUser with the same password, LSUser is not domain account, linked server is configured for Windows Account Impersonation (checked Impersonate) Example, query executed from client C: 1>exec [LS1].[DB].[dbo ].[ListTab1]; - works well, no problem 1>exec [LS1].[DB].[dbo ].[ListTab2]; - works well, no problem ok , now try modify permission on S2, I explicitly deny execute procedure [DB].[dbo ].[ListTab1] on S2 to S2\LSUser, 1>exec [LS1].[DB].[dbo ].[ListTab1]; Msg 229, Level 14, State 5, Server S2, Procedure ListTab1, Line 1 The EXECUTE permission was denied on the object 'ListTab1', database 'DB', schema 'dbo'. expected message :), but look now: 1> exec [LS1].[DB].[dbo ].[ListTab2]; Msg 18456, Level 14, State 1, Server S2, Line 1 Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. all remote queries STOP working from client C 1> select top 10 * from [L

Remote server returned an error: (400) bad request

  
Hi, I am using IIS 6.0. I have a server, in which i have a web application, which was in http. The report manager(SSRS 2005) was also in http. I moved the web application to https. After moving, i am not able to access the report manager, but i am able to access the web application. I am getting the error as "The remote server returned an error: (400) Bad Request.". How to open the report manager. Thank you

WCF HTTP POST - The remote server returned an error: (400) Bad Request. - URGENT

  
client & sever code below-------------------------------------------- [ServiceContract(Namespace = "http://test.mydomain.com")] public interface IMyService{[WebInvoke(UriTemplate = "", BodyStyle = WebMessageBodyStyle.Bare, Method = "POST")] Stream SaveXML(Stream input); } ----------------------[AspNetCompatibilityRequirements(RequirementsMode = AspNetCompatibilityRequirementsMode.Allowed)] [ServiceBehavior(Namespace = "http://test.mydomain.com")] public class MyService : IMyService{  public Stream SaveXML(Stream input)   {              StreamReader streamReader = new StreamReader(input);       string rawString = streamReader.ReadToEnd();       streamReader.Dispose();        // here need to save the input stream to xml format file          //       Encoding encoding = Encoding.GetEncoding("ISO-8859-1");       WebOperationContext.Current.OutgoingResponse.ContentType = "text/xml";         byte[] returnBytes = encoding.GetBytes(rawString);       return new MemoryStream(returnBytes);   } } --------------------------------------------------Client Code         string postData = GetXmlString("d:\\text.xml"); // user function        WebRequest request = WebRequest.Create("http://test.mydomain.com/myservice.svc");        request.Method = "POST";        byte[] byteArray = Encoding.UTF8.GetBytes(p

Error while Deploying WebMatrix Beta Application having SQL Database on Remote Server

  

Hello All,


I have created "DotNetNuke SQL Database Application" from the WebMatrix Gallery.

Now I want to deploy it on the remote server using Web Deploy method.

Without selecting SQL database, application is deployed successfully but when I select SQL database it gives following error:

Publish : Error - Make sure the database connection string for the server is correct and that you have appropriate permission to access the database. (Web Deploy provider is dbFullSql).

Can anyone have the solution of this error?

Thanks in advance....



Linked Server Mapping Error "Access to the remote server is denied because no login-mapping exists"

  

SQL Server 2005 SP3 32bit server
Connecting to an Oracle 10g server
Loaded OracleClient 10g

I'm able to ping the Oracle Server, and ODBC connect and able to run an open query with a single remote user id.

Issue: When I use the security context "Be made using this security context" it connects.
When I choose the "Not Be Made" WITH THE SAME USER ID & PASSWORD, I get the mapping error.


The remote server returned an error: (401) Unauthorized. Failed to execute web request for the speci

  

Hi,

I am creating reports using SQL business intelligence 2008.

Connection string 'http://<SharepointServer>/_vti_bin/lists.asmx '.

And i have created a data set using the below xml query.

<Query>
   <SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems </SoapAction>
   <Method Namespace="http://schemas.microsoft.com/sharepoint/soap/ " Name="GetListItems">
      <Parameters>
         <Parameter Name="listName">
            <DefaultValue>{GUID of the list}</DefaultValue>      
         </Parameter>      
      </Parameters>
   </Method>
   <ElementPath IgnoreNamespaces="True">*</ElementPath>
</Query>

 

When I try to execute th

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 remote server returned an error: (530) Not logged in

  
Hi,

I have below code for deleting the file from ftp, i am getting a error.

"The remote server returned an error: (530) Not logged in. " what could be reason.

public
static void DeleteFile(string serverUri, string userid, string password)

{

FtpWebRequest request = (FtpWebRequest)WebRequest.Create(serverUri);

request.Credentials =new NetworkCredential("userid", "password");

 

request.Method = WebRequestMethods.Ftp.DeleteFile;

 

FtpWebResponse response = (FtpWebResponse)request.GetResponse();

response.Close();

}


The remote server returned an error: (405) Method Not Allowed.

  
hi i declared,
 
 [OperationContract]
      [WebInvoke(     
      UriTemplate = "/CreateCustomer/cNo/{cNo}/cName/{cName}",
      Method = "POST")]
    bool InsertCustomer(string cNo, string cName);


/*service call*/


 public bool InsertCustomer(string cNo, string cName)
    {
      bool Inserted;
      String connString = ConfigurationManager.ConnectionStrings["connectionstr"].ConnectionString;
      SqlConnection Conn = new SqlConnection(connString);
      Conn.Open();
      SqlCommand Cmd = new SqlCommand();
      Cmd.Connection = Conn;
      Cmd.CommandText = "Insert into Customer Values(cid,cname)";
      Cmd.Parameters.AddWithValue("cid", Convert.ToInt32(cNo));
      Cmd.Parameters.AddWithValue("cname", cName);
      Inserted = Convert.ToBoolean(Cmd.ExecuteNonQuery());
      Conn.Close();
      return Inserted;
    }



/*client code */

  string ServiceUri = "http://localhost:portno/Service.svc/CreateCustomer/" + "cNo" + "/" + TextBox1.Text + "/" + "cName";
      WebRequest addRequest = WebRequest.Create(ServiceUri);
      addRequest.Method = "POST";
      addRequest.ContentType = "application/xml; charset=utf-8";
      addReques

webinvoke method=Post..throws error "The remote server returned an error: (405) Method Not Allowed."

  

hi,

my service defn

 [OperationContract]
      [WebInvoke(     
      UriTemplate = "/CreateCustomer/cNo/{cNo}/cName/{cName}",
      Method = "POST")]
    bool InsertCustomer(string cNo, string cName);


/*service call*/


 public bool InsertCustomer(string cNo, string cName)
    {
      bool Inserted;
      String connString = ConfigurationManager.ConnectionStrings["connectionstr"].ConnectionString;
      SqlConnection Conn = new SqlConnection(connString);
      Conn.Open();
      SqlCommand Cmd = new SqlCommand();
      Cmd.Connection = Conn;
      Cmd.CommandText = "Insert into Customer Values(cid,cname)";
      Cmd.Parameters.AddWithValue("cid", Convert.ToInt32(cNo));
      Cmd.Parameters.AddWithValue("cname", cName);
      Inserted = Convert.ToBoolean(Cmd.ExecuteNonQuery());
      Conn.Close();
      return Inserted;
    }



/*client code */

  string ServiceUri = "http://localhost:portno/Service.svc/CreateCustomer/" + "cNo" + "/" + TextBox1.Text + "/" + "cName";
      WebRequest addRequest = WebRequest.Create(ServiceUri);
      addRequest.Method = "POST";
      addRequest.ContentType = "application/xml; charset=utf-8";
      addRequest.ContentLength = 0;
      WebResponse addResponse = addRequest.GetRespo
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