I'm trying to implement a bit of functionality that will behave much like the CustomError pages: if the connection is remote function A() will run; else function B() will run. The only problem I'm having is that I'm not sure the best way to determine a "remote" connection. Does it matter if I'm running my code on a shared web host? Can I rely on just comparing "my" IP to the request's IP?
View 1 RepliesI'm using Visual Studio 2008, and my database is SQL Server 2000.
I want to add a connection to the Server Explorer in VS. The Data source is Microsoft SQL Server (SqlClient). After entering in all my information and I click Test Connection, it is successful.
But when I click OK, I get the error:
Unable to add data connection. ExecuteScalar requires an open and available connection. The connection's current state is closed.
Is it possible to connect to a Remote Desktop from my ASP.net (I easily done it in .net windows application with a 4 line code and"Windows Terminal Service Control")application, If so can you guide me through it. Many thanks in advance.NB:I want to achieve it without using ActiveX control that work in IE, because with that every client would have to use IE and install the control.
View 6 RepliesI've set up a msSQL remote connection on a GoDaddy shared hosting account (known as Direct Database Access).I'm doing some javascript/HTML/css work on the site and don't need/want to have to download/manage a separate database.The remote connection works and the pages load as expected. However, each time I request a DB driven page in my browser it takes about 2-4 minutes before the page is sent/downloaded.Could this be a limitation set by godaddy to discourage connecting to the database remotely?Is there anyway to set up a "proxy" on the production server to get the query results?Are there any alternative methods for connecting to the DB you could suggest?Should I just stop whining about it and setup a local copy of the database?
View 1 RepliesI really don't know were to post this question, so i hope this is the right section.
I would like to create a web application that would be possible for the users to remotely connect to their desktops. In a nutshell, Web-based Remote Desktop.
Ok I created a web app with membership & role, intially I had 2 db but combined data with the default aspnetdb.mdf created to simplify.I then used "copy web" to move all asp files & roles folders to remote server in a sub domain directory.Created a backup of the aspnetdb.mdf and then ftp to sub domain directory which was then loaded by the host as MS SQL db name: aspnetdb3.Now, I know I need to change the web.config connection settings but to what???here is the initial connection setting:
[code]...
I am about to give up debugging SMTP servers to send email... My code is the following
SmtpClient mailClient = new SmtpClient("plus.smtp.mail.yahoo.com", 465);
mailClient.EnableSsl = true;
MailMessage message = new MailMessage();
message.To.Add("aditya15417@hotmail.com");
message.Subject = "permias-tucson-contact-us";
mailClient.Credentials = new NetworkCredential("myemail@yahoo.com", "mypassword");
MailAddress fromAddress = new MailAddress(Email.Text, Name.Text);
message.From = fromAddress;
mailClient.Send(message);
Is there any way to lunch Remote Desktop Connection from web server ?
im using code in below, it's working from my PC but it dose not working from web server.
Dim retval As Object
Dim MyIPAddress as string = "10.10.10.10"
retval = Shell("C:Windowssystem32mstsc.exe /CONSOLE /f /v: " + MyIPAddress , vbMaximizedFocus)
I'm getting a lot of these error messages in my logs on one of my servers and intermittently on two others.Googling didn't reveal very much information, mostly related to file uploads or downloads being interrupted. My pages are basically just text files with "ok" in them that only have .aspx extension for future plans, there's no actual code powering the pages. Servers are all Windows Server 2008 RC2 x64 running IIS7 / ASP.NET 4.Statistically it's happening well under 1% of the time but because of the volume of traffic that still clutters my event log with 2 or 3 of these messages per minute.Edit:tracked down the problem, setting buffering to true stopped it occurring.
View 2 RepliesI am developing an application in which I can connect to the ASPNETDB.MDF if it is on my machine, however, when I want to put it on another machine and try to remote connect it, I get the error:
An error occurred while attempting to initialize a System.Data.SqlClient.SqlConnection object. The value that was provided for the connection string may be wrong, or it may contain an invalid syntax.
Parameter name: connectionString and my connection string is as follows:
<add name ="NewRemoteSqlServer" connectionString="Data Source=P1M1_2-HPSQLEXPRESS; AttachDBFilename=C:ASPNETDB.MDF; Integrated Security=SSPI; Username=P1M1_2-HP; Password=plus1minus1; " providerName="System.Data.SqlClient"/>
just for my testing purpose i know i can define both the connection's outside in a single web config file by different name's and access them in my front end according to it but what if i want to have seprate for both connection's web.config situation is like this see image so i want to access my connections from second web config file how i can do that.
[Code]...
i tired this but its giving error
[Code]....
I previously used a datasource and a connection string to connect to my database on sql server and all orked fine. The connection string was saved in my web.config file and is: ....
View 1 RepliesI am using VS2008 and oracle 10g ODP.Net. The oracle database that I used in the connection is working and tested it using sql plus.The connection string when used in a GriDView works perfectly. Now when I created a new listview control with the same connection it gives an error.Database schema could not be retrieved for this connection. Please make sure connection settings are correct and the database is online
Object reference not set to an instance of an object at VSDataObjectSupport (478,6)
{"Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host."}
I get the above error when sending email...
In my DAL i have more than 100 methods/Function, each and every method am opening the sqlconnection and closing the connection, this is taking too much of time to establish the connection at every time. So what i expect is one common class will create the SqlConnection that will check if the connection is Broken or Closed then create the connection again else return the connection, how to do this(Also i would like to apply ConnectionPooling).
View 7 RepliesIn my application there are 4 connection strings...from that i want one connectionstring should be default connection string.How to do ?
View 1 RepliesI have VS 2010 professional. I am trying to open "ASP.Net Configuration" through Project -> ASP.Net Configuration.
It pops up the Notification about the ASP.Net Development Server localhost but doesn't open ASP.Net Configuration in the default browser.I clicked on the Root Url (by double clicking on the 'development server' at the right bottom from Notification Manager).
It throws following error
"An error was encountered. Please return to the previous page and try again."
Clicking on "How do i use this tool".It opened page with error.
Tool Has Timed Out
I am preparing for an Access2007 db conversion at the beginning of the year and would like to know what the best process would be for connecting to the sqlserver2005 database. I have read about adding the connection string to the web.config file. I have also read about using ADO.NET and put the connection information into a class and not the web.config file.
I would like to hear from others as to what you have used, are using, or plan on using for a webapp (vs2010), and why so I can get an understanding.
I am new in Asp.net with Oracle and not build proper connection in it.
View 2 RepliesI have an ASP.Net website running on IIS7. The Application Pool is set to ASPv4 Classic.
Authentication Mode is set to ASP.Net Authentication & Windows Authentication
My question is, when I want to connect to SQL using a "trusted connection" in the Connection String, what user will actually be passed into SQL?
I thought it would pass my logon details, but it is coming back with an NT AUTHORITYANONYMOUS LOGON error, which seems to point towards it not passing in my logon.
When I open an ASP.NET 3.5 project using VWD2010, I get a prompt error message,"The connection property in the web.config file is missing or incorrect.The connection string from the .dbml file has been used in its place."however, my project works successfully.
View 1 RepliesI have got ssl security for my website.I have written onLoad that [URL] ... Should redirect on [URL] ... it redirects but first the [URL] ....pages loads full and then after a sec it redirects...I want to solve this
function(){
windows.onload = windows.location.href("https://mylifeshades.com")
}
I have a db connection string 'ApplicationServices' defined in the connectionString section of web.config and 3 Entity Framework connection strings which have the provider connection string attribute with the same connection string as the one in 'ApplicationServices'. Is there a way to reference connectionString in 'ApplicationServices' for the provider connection string attribute of the EF connection string in the web.config, rather than providing the connection string all over again?
View 1 RepliesI have created a webservice in 2010. And when I call it from my web application sometimes,It generates the follwoing errors:-1. The underlying connection was closed: A connection that was expected to be kept alive was closed by the server.2. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.I have already tried increasing excutonTimeOut etc.
View 2 RepliesI deployed my MVC app to IIS 7.0 and I keep getting the following error; ExecuteNonQuery requires an open and available Connection. The connection's current state is closed I dont get this with the app locally on my machine. Where could this error be occurring??
View 2 Replies