After only two days of pulling my hair out over this, I found the solution. And, man, is it ugly! Although, in the end, I’ll probably opt against using this control, I feel I should share my findings:
Firstly, since as far as I know SQL Server 2005 Express Edition doesn’t ship with SQL...
Thank you for your quick response. I'm using SQL Server 2005 Express edition as well as Visual Web Developer 2008 Express Edition. Is SQL Profiler a part of either of those?
Also, I just tried to simplify the stored proc and removed output params. Now it's just a simple update (for testing...
I'm trying to learn SQL Server 2005 and ASP.NET 2.0. (I've been working with SQL 2000/.NET 1.1 until now.) I can't get past the following problem and hope one of you gurus can help:
The error I'm struggling with is: Procedure or function editArea has too many arguments specified.
NOte that...
OK, The solution for anyone who might have the same problem was the following:
Even though I am linking tables using a User DSN that specifies the SQL user logon, when my ASP.NET page runs an MS Access Query that links to the SQL Database Tables, it runs as ASPNET user.
Therefore, I added that...
Thanks, but that article seems to be a discussion on Crosstab queries; when in fact my issue is still a connection issue.
Basically, my ASP.NET application connects to MS Access database. That database needs to connect to SQL Server (to get the linked tables). Now, I am able to connect to MS...
OK, apparently, there must have been some process that kept the connection open. I tried to connect to another database and it worked. After I restarted the computer, I was able to connect to the original database. However, I have one more major issue:
I'm able to connect to and query MS...
Actually, I figured out that I needed to give write permission to the internet user account for the "\Documents and Settings\Machine_Name\ASPNET\Local Settings\Temp" directory.
NOW I'VE GOT A NEW ERROR:
Could not use ''; file already in use
Bombs in the same place as before, and when i break...
MY Code is not working. I'm getting an "Unspecified Error" when trying to connect to an MS Access database:
Dim connectionString As String = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\myapp\db2.mdb"
Dim con As OleDbConnection...
FYI: "TimeOut is not a member of System.Net.Webclient" is the error I get with the previous code.
In fact, there do not appear to be many "members" at all.
Your code makes perfect sense. It appears to be working now (for the most part) thanks to your code samples. I modified it to have 5 concurrent downloads. I still have other issues (such as one large file throwing a webclient exception), but that's for another thread if i can't find the...
It's nearly midnight (here in asia), so I'll have to try out your suggestions tomorrow and let you know how it goes. For now let me just thank you for your feedback. It's greatly appreciated!
I'm still using v1.1.
MyFunctionThatTakesForeverToComplete downloads files. Oftentime very large files.
Public Function DownloadFile()
Try
Dim addr As String = lvi.SubItems(1).Text
Dim target As String = lvi.SubItems(2).Text
Dim path As String...
I'm new to threading, and am completely baffled.
Currently I have something like the following:
lbl.Text = "start sending to queue"
for i = 0 to 100
' do some work
SyncLock MyQueue.SyncRoot
MyQueue.Enqueue(MyFunctionThatTakesForeverToComplete)
_waitQueue.Set()...
I'm trying to create an app that navigates and downloads images from web sites. (This is my first Windows App, so perhaps I'm in over my head.)
I have quite a few problems working with AxWebBrowser and mshtml.HTMLDocument. I'll just post one problem here:
Navigation is extremely quirky. I...
I actually did, and the error was "Unspecified Error". Anyway, I got it to work.
I have always had permissions problems in .NET. This is quite odd:
Even though I granted Full Control Permission to the IUSR_SERVERNAME user, and was therefore able to upload the file, I wasn't able to read...
The following code works in one project but not another:
Dim fl As String = Server.MapPath("parser.xls")
If File.Exists(fl) Then
File.Delete(fl)
End If
fileUpload.PostedFile.SaveAs(fl)
Dim strConn As String...
yes, what I meant was that <%= Request.ApplicationPath %> was in the Html and should have rendered as "/VirtualDirectoryName".
Nevertheless, through experimentation i discovered that it was because the table itself had "runat=server". Removing Runat=Server Solved the problem. Instead, I am...
I have the following HTML in my ASPX page:
<table id="tblNewMembers" runat="server" width="98%" border="0" cellspacing="1" cellpadding="3">
<tr>
<td background="<%= Request.ApplicationPath %>/images/admin/h_tab_bg.gif" height='25'>
<img src="<%= Request.ApplicationPath %>/images/c2.gif"...
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.