Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mavalon
  • Order by date
  1. mavalon

    Procedure or function sProcName has too many arguments specified

    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...
  2. mavalon

    Procedure or function sProcName has too many arguments specified

    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...
  3. mavalon

    Procedure or function sProcName has too many arguments specified

    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...
  4. mavalon

    How To Connect to MS Access Database in ASP.NET

    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...
  5. mavalon

    How To Connect to MS Access Database in ASP.NET

    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...
  6. mavalon

    How To Connect to MS Access Database in ASP.NET

    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...
  7. mavalon

    How To Connect to MS Access Database in ASP.NET

    I gave Full Control to Everyone. I still get the same error.
  8. mavalon

    How To Connect to MS Access Database in ASP.NET

    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...
  9. mavalon

    How To Connect to MS Access Database in ASP.NET

    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...
  10. mavalon

    In desperate need of Threading/Queueing Help

    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.
  11. mavalon

    In desperate need of Threading/Queueing Help

    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...
  12. mavalon

    In desperate need of Threading/Queueing Help

    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!
  13. mavalon

    In desperate need of Threading/Queueing Help

    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...
  14. mavalon

    In desperate need of Threading/Queueing Help

    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()...
  15. mavalon

    AxWebBrowser unable to Navigate

    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...
  16. mavalon

    "Unspecified Error" filling DataSet with data from Excel Worksheet

    You're absolutely right! (My bad.) I removed EVERYONE, added ASPNET, and it works. Thanks again.
  17. mavalon

    "Unspecified Error" filling DataSet with data from Excel Worksheet

    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...
  18. mavalon

    "Unspecified Error" filling DataSet with data from Excel Worksheet

    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...
  19. mavalon

    Code Blocks Not Consistently Rendering

    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...
  20. mavalon

    Code Blocks Not Consistently Rendering

    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"...

Part and Inventory Search

Back
Top