Thanks alot for the answer.
I now get another error message saying that the connection was closed. But I think our firewall is blocking my request. I'll try tonight at home.
Thanks again.
Good day,
I am using the following code to get the HTML from a web page. But I get a proxy authentication error.
How would I set up the proxy details (server, port, username and password) for our proxy server to get past it?
// Setup our Web request
System.Net.WebRequest request =...
Very True, M1ke!
I have in the mean time re-thought my situation and decided that I will not be going to america.
A couple of other countries are in scope though.
Thanks for the help, and sorry for the late response.
Sorry about my post. I got the answer. What I did was write this function :
CREATE FUNCTION fnSeconds (@CallTime nVARCHAR(50))
RETURNS DECIMAL(18,2) AS
BEGIN
DECLARE @CallSeconds DECIMAL(18,2)
DECLARE @CallMinutes DECIMAL(18,2)
DECLARE @CallHours DECIMAL(18,2)
SELECT @CallSeconds =...
Good day,
How would I add nVarChar fields with values "00:00:02", "00:00:05", etc, etc, simulating the duration of a telephone call together?
I tried using SUM(field) but it cannot add up a nVarChar field.
I also tried using SUM(CONVERT(datetime, field)) but that does not work either, saying...
Well, that was the problem.
I want to just thank everyone that was involved in this, as the problem is now resolved. It seems that the anonymous logon just did not have the access to write a file.
Now, obviously I cannot give this user ID (anonymous login) admin access. So what kind of access...
Hmmm, This is what I thought.
Ok, thanks for the help. I will now start researching into the CommandBuilder Object, as I have never seen this.
Will ask again if I cannot figure it out.
Thanks again.
oh. Thanks.
I have used sqldataadapter before, byut never knew what the diffirence was.
I am however free to use SQLDataAdapter at any time, am I not? Whether I am updating, I can still just call my stored procedure, or write inline sql statements?
Am I correct in doing it this way?
Also...
ok, the persmissions that is set on my web site virtual directory is as follows.
I have anonymous access enabled, with a user called "IUSR_AT007359" with access to the guests group. Also, I am allowing IIS to control the password.
Then I also have digest authentication for windows domain...
Good day all,
I have been playing around with diffirent ways of getting data from DB's.
I have this code:
SqlConnection mySQLConn = new SqlConnection("workstation id=AT007359;packet size=4096;user id=sa;data source=AT007359;persist security info=True;initial...
I would presume so. ASPNET has admin rights to my machine. Do I use the ASPNET account to run the code? I think so. How do I check?
Well, if it is the ASPNET account, then I don't think it is permissions based.
I am really giving up with this now. I just don't know what to do...
Could it...
Ok, what I tried now, is to create and empty file, called summary.html in the correct directory, and then ran the program again.
Now the message it gets is:
"Cannot access read-only document 'Summary.html'."
And I checked, it is NOT read-only. Why would it do this?
thanks for all the help. However, I am still getting the same problem.
I just don't know what I am doing here. I copied your (obislavu) code for saving and I am still getting the same problem. It seems that the only diffirence is in the way the path is created/set up. The rest of my code looks...
Well, the problem is that there is no such file. I searched my whole HDD for it, and I cannot find it. It has not been saved yet, as it crashes with this error message before it can get saved.
On a sidenote. How do you get those nifty "Quote" and "Code" blocks?
Thanks alot ChipH! Really good stuff. Just a "fairly" stupid question...
After what you typed in there, after this
"fileExists = File.Exists(filePath);
if (fileExists)
{
FileAttributes fileAttr = File.GetAttributes(filePath);
fileReadOnly = (fileAttr & FileAttributes.ReadOnly) ==...
Sorry, maybe I should just point out that I am trying to create this file, and overwrite it if it exists.
I want to redirect to this page once it is saved. Because of this, the page is saved in my inetpub\wwwroot\applicatation dir on the HDD.
Any ideas?
Good day,
I am creating a file with this statement...
xlApp.ActiveWorkbook.SaveAs(FilePath + "\\Summary.html",
Excel.XlFileFormat.xlHtml, Type.Missing,
Type.Missing, Type.Missing, Type.Missing,
Excel.XlSaveAsAccessMode.xlNoChange, Type.Missing,
Type.Missing, Type.Missing, Type.Missing...
Thanks. It really makes sence. I always knew this (in other programming languages) and alwasy done it, just never knew that it was the same as a property get and set.
Thanks alot for clearing it all up for me. Did the courses and they just never explained it to me like this.
Ahh, ok. I understand the get/set thing now. So it is basically only to get nice structure to your code and make it more amintainable, but in effect does the same job as using variables and using functions or inline code to check for data.
That makes sence then. Thanks for the explanation...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.