Code:
'Dim strConn As String
gderosa
Last Activity: Mar 17 '08, 08:08 PM
Joined: Nov 21 '06
Location:
-
Nope, this still does not solve the problem. It has been over a month that I have been trying to figure this out, and I just don't understand! I am creating a new app and am still getting the same error even though I am 100% sure I have everything setup correctly. IIS is impersonated with a superuser account. Identity impersonate is set to true in the web.config file. Here is my SQL Connection code
... -
Extremely Unusual Connection Problem
I have an ASP.NET/VB.NET web application running on Server A (lets say Fred [http://fred/MyApplication/]) flawlessly. The web application is using impersonation to gain access to SQL Server. Server A is also known under another DNS (lets say Bob [http://bob/MyApplication]). If I access the same exact web application using Bob as the DNS instead of Fred (its on the same box, same location, etc., just different DNS) I get a periodic Login failed... -
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
I have been getting that dreaded error in my application:
Login failed for user 'NT AUTHORITY\ANONY MOUS LOGON'.
I have had my application in the test environment, impersonating it using a superuser domain account and setting proper permissions in both IIS and setting up the user in SQL Server.
Now I moved my application to the production enviroment with the same exact settings as my test environment, and I am... -
Thanks very much, it works!Leave a comment:
-
Using Local Variables In A Stored Procedure
Hey guys I need some help with local variables, here is my current code:
...Code:CREATE PROCEDURE CreateFile AS DECLARE @notification int SET @notification = (SELECT NotificationPeriod FROM Notification Where NotificationID = 1) SET NOCOUNT ON --Populate template EXEC sp_makewebtask @outputfile = 'C:\xpsmtp\Test1.html', @query = 'SELECT ContractSequenceNumber,
-
Creating An Advanced Search
I have searched for hours regarding this but I am trying to make an advanced search page for my application that has drop downs for 'Greater Than', 'Equals', 'Less Than'. For example the search page needs to be like this:
ENDDATE: [dropdown with greater than, equals, or less than] [user enters date in this textbox]
How can I manipulate the SQL search string to change the value when the user selects a search criteria... -
Thanks for your help I actually found the code..here it is if others need it:
Code:<asp:TemplateColumn><ItemTemplate> <%#MyDataGrid.PageSize * MyDataGrid.CurrentPageIndex + Container.ItemIndex + 1 %> </ItemTemplate> </asp:TemplateColumn>
Leave a comment:
-
Great thanks very much for your help I got it to work!Leave a comment:
-
Comparing Dates In VB.NET
I searched before posting and followed instructions but it still did not work for me. I need to compare 2 dates but regardless of what the dates are they always return the same value on comparison. Here is my code:
...Code:Dim EndDate As DateTime Dim Current As DateTime = Today If DateTime.Compare(Current, EndDate) < 0 Then Label6.Text = "CONTRACT EXPIRED LESS THAN" End If -
Line Numbering In DataGrid
Hey everyone...I'm trying to figure out how to create a template column in a datagrid to automatically display the line number of the data.
EX:
Search Results
1 Bla
2 Bla2
3 Bla3
4 Bla4
5 Bla5
I dont mind if the line numbers restart if paging is implemented and the user clicks onto the next page in the datagrid.
Thanks in advance!! -
Comparing Date to SQL Server Date
Hey everyone...I need to create a job which occurs once monthly that is based on a stored procedure that contains as a rough example:
CREATE PROCEDURE CompareDate
@CurrentDate datetime
AS
SELECT * FROM Contracts WHERE EndDate LIKE (CURRENT SERVER DATE)
GO
How do I declare a parameter to automatically get the current server date in the stored procedure? Also,... -
I appreciate all of your help but I actually found code after searching for a couple of days that will accomplish what I wanted to do. Thanks again for all your help!Leave a comment:
-
Autocomplete in textbox on ASP
Hey, I've searched for a couple of days and have not found an answer. I have a textbox that needs the autocomplete/autofill feature. There are dozens of scripts out there that do this from a predefined list of values (ie: states are hard-coded in either XML or an array). I need the autocomplete to connect to a database instead of pulling the data from hard-coded values or XML. Does anyone know of such a script to do this? Keep in mind that the... -
Oops, I forgot to include the full code..here it is:
Hey everyone, I have a function that reads XML data and converts it into a string, is there anyway to convert this to read from a SQL database while keeping the same functionality? This code is part of an Autofill user control. Here is the code:
...Code:Private Function GetFilteredData(ByVal filter As String) As DataTable Dim users As String = _Leave a comment:
-
Converting XML Reader to SQL Reader
Hey everyone, I have a function that reads XML data and converts it into a string, is there anyway to convert this to read from a SQL database while keeping the same functionality? This code is part of an Autofill user control. Here is the code:
...Code:Private Function GetFilteredData(ByVal filter As String) As DataTable Dim users As String = _ "<users>" & _ "<usertable><userid>1</userid><username>John -
wow I cant believe I got it to work all it needed was a space in place of the first %:
WHERE ([last] LIKE ' ' + ? + '%')...Leave a comment:
-
I tried the LIKE '"& ? & "' and it still doesnt work, it says poorly formed expression. Thanks for your help though!...Leave a comment:
-
Thanks very much for your help but it turned out that I had to register IIS with ASP.NET 2.0....Leave a comment:
-
Help With Deployment!
I am trying to deploy an application to a test server on my company's intranet. This application runs just fine locally, and I used the 'Copy Project' option in VS 2003. I set the destination project folder to http://ncgc-webdb/NEWGDLocator2/ and selected the File Share Web Access Method. When I access the application at http://ncgc-webdb/NEWGDLocator2/WebForm1.aspx I get this error:
Server Error in '/NEWGDLocator2' Application.... -
Yup it works by hardcoding it like that but it brings me all results that have 's' in them wheras I want all results that start with 's' as an example. If all worked correctly I would like the results to start with the stored session variable, which it is not doing. It is returning results that include the session variable but not the ones that start with the session variable. I really appreciate ur help!
For example I currently...Leave a comment:
No activity results to display
Leave a comment: