|
I hate having a problem, and being stuck on it for awhile, making a post, and right after making the post for help I find the solution.
The solution is to adjust the properites of the ASP page in Web Services under "file security", and select a user that has administrator access rights to login as. Pretty simple to do, but it took awhile to find.
|
|
|
|
|
Nice, good to know, I will need it too soon 
Philip Patrick
Web-site: www.stpworks.com
"Two beer or not two beer?" Shakesbeer
Need Web-based database administrator? You already have it!
|
|
|
|
|
Excellant, I am glad my post could help!
|
|
|
|
|
i have a parent window.from that i move to a child window(a popup).then i add records to database.the child window has two textfields to enter the data.After the data is entered,the user clicks the submit button and the page is taken to a page where database is updated and after updation the user is redirected to the child window.
what i want is as soon as updation takes place in the database,the parent window should be refreshed and changes shud be shown in parent window.i don't want to use <meta> tag.
please reply soon.
|
|
|
|
|
<script>
window.opener.location.reload();
</script>
--
David Wengier
Sonork ID: 100.14177 - Ch00k
|
|
|
|
|
 I have the TreeView Menu in which there are branches and leaves and when i click on the branch the menu will be unfolded to leaves and in that i want some leaves to be DISABLED and the remaining to remain ENABLE How to DO IT ANY BODY PLEASE HELP ME OUT . the demo version is available at http://www.codeproject.com/useritems/dhtml_treeview.asp
B.Rama Kanth
balina@pun.cmc.net.in
|
|
|
|
|
Hi guys. This morning before work I fired up VS7 and threw a SqlConnection onto a webform and tried to open a connection to a database. I got a SqlClient error stating that "Login failed for user mydevmachinename\aspnet".
Where does this come from? And why am I able to do the exact same thing on a Windows Form without an error?
And yes, it is my first foray into the world of web and database programming 
Regards
Senkwe
Just another wannabe code junky
|
|
|
|
|
By default all ASP.NET web applications run under the username ASPNET. Also by default you attempt to connect to SQL Server using the current windows login, since you are running it from ASP.NET you are trying to login from the mydevmachinename\aspnet account.
On a Windows Form you don't have the problem because the application runs in the context of the current user (ie you).
James
Sonork: Hasaki
"I left there in the morning
with their God tucked underneath my arm
their half-assed smiles and the book of rules.
So I asked this God a question
and by way of firm reply,
He said - I'm not the kind you have to wind up on Sundays."
"Wind Up" from Aqualung, Jethro Tull 1971
|
|
|
|
|
Thanks James, so must I create a username called ASPNET with rights to the database?
Just another wannabe code junky
|
|
|
|
|
Yep
James
Simplicity Rules!
|
|
|
|
|
Gotcha, thanks again James. Oh and by the way, it would REALLY be nice if some day YOU actually ASKED a question as well you know!!
hehe
Regards
Senkwe
Just another wannabe code junky
|
|
|
|
|
Senkwe Chanda wrote:
Oh and by the way, it would REALLY be nice if some day YOU actually ASKED a question as well you know!!
Does this one count? 
You know, its odd that I don't ask questions; I'm certainly stumped enough that I should be :-P
James
Simplicity Rules!
|
|
|
|
|
you can also sign in with UsserName SA and the password blank like this
Myconn = New SqlConnection("server=your server\NetSDK;initial catalog=pubs;user id=SA;password=;") I ran into the same problem as you and this works great
Paul
|
|
|
|
|
Hi there,
What is difference between: CreateObject and Server.CreateObject ???
Both of them can make instance from COM object !
So, what is difference ?
My month article: Game programming by DirectX by Lan Mader.
Please visit in: www.geocities.com/hadi_rezaie/index.html
Hadi Rezaie
|
|
|
|
|
Server assumed and can be skipped. You can use with same effect Server.MapPath and MapPath or other Server methods
Philip Patrick
Web-site: www.stpworks.com
"Two beer or not two beer?" Shakesbeer
Need Web-based database administrator? You already have it!
|
|
|
|
|
You may want to check this out:
http://www.4guysfromrolla.com/webtech/043099-1.shtml
Cheers!
|
|
|
|
|
I am using this statement to return some records. The statement using the ASP variable ActiveID to pull records according to categories.
This works fine, but I can't seem to add further variables (e.g. How would I add an ORDER BY statement to this?)
RS1.Open "SELECT * FROM Table WHERE Cat_ID =" & ActiveID, DB1, adopenstatic
What I really want to do is return records updated in the last seven days or so. I have the last modified value stored in a table in the format DD/MM/YY -- is it possible to do a SQL query that will only return records updated in the past seven days?
|
|
|
|
|
Garth wrote:
How would I add an ORDER BY statement to this?)
RS1.Open "SELECT * FROM Table WHERE Cat_ID =" & ActiveID & " ORDER BY Name", DB1, adopenstatic
--
David Wengier
Sonork ID: 100.14177 - Ch00k
|
|
|
|
|
this should get records updated only in the last seven days as well but I haven't checked this yet as I'm late for work 
strSql = ""
strSql = strSql & "SELECT * FROM Table WHERE Cat_ID =" & ActiveID
strSql = strSql & " AND modifiedDate >= '"& DateAdd("d", now(), -7) &"' ORDER BY modifiedDate "
RS1.Open strSql, DB1, adopenstatic
HTH
|
|
|
|
|
I have a very simple ASP.NET application that just displays a form.
I can debug it through the IDE but if I try to browse it via IE, I get You are not authorized to view this page
This happens even if I attempt to browse from the IIS MMC or just straight http:\\localhost\WebApplication1
Any ideas, straight standard VS.NET installation on Windows XP.
Michael
|
|
|
|
|
Do you get that error if you browse to the page directly instead of letting the webserver pick the page for you?
James
Sonork: Hasaki
"I left there in the morning
with their God tucked underneath my arm
their half-assed smiles and the book of rules.
So I asked this God a question
and by way of firm reply,
He said - I'm not the kind you have to wind up on Sundays."
"Wind Up" from Aqualung, Jethro Tull 1971
|
|
|
|
|
I am just shooting here, but when you look at the properties of your wwwroot folder and click on the web sharing tab, you do have the share the folder radio clicked right?
Nick Parker
|
|
|
|
|
My default documents list didn't have the default.aspx page listed, so it couldn't load the start page. If i browsed to any other form directly it worked.
Doh! That's what you get with playing with new toys late at night.
Michael
|
|
|
|
|
Is it posssible to get a filename on the webserver, so that I pass a filename relative to a codebehind page and it gives me the filename relative to the page I am writing (using Response.Write).
For example, I have a code behind page called PageWriter.cs in /mhc/Scripts/CodeBehind. I want a function that will take a filename such as "../Index.xml" (indicating /mhc/Index.xml) and if I am writing the page /mhc/Index.html, give me the original filename relative to /mhc/Index.html, which would be simply "Index.xml". Am I making any sense? I want to give it the filename relative to the codebehind page, and get the filename relative to the page I am writing.
Thanks guys.
-Domenic Denicola- [CPUA 0x1337]
MadHamster Creations
"I was born human. But this was an accident of fate - a condition merely of time and place. I believe it's something we have the power to change..."
|
|
|
|
|
Come on people, this must be a fairly common thing? Or should I just use some horrible hack like analyzing the filename of the page I'm writing for how many "../"s should go in front of every filename I want to write on the page? That doesn't sound fun at all.
-Domenic Denicola- [CPUA 0x1337]
MadHamster Creations
"I was born human. But this was an accident of fate - a condition merely of time and place. I believe it's something we have the power to change..."
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
