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 Mike Lewis 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: dougancil
  • Order by date
  1. dougancil

    Line 1: Incorrect syntax near ','. Unclosed quotation mark before the

    I'm not able to type anything in the name column. I put the breakpoint on this line of code: cmd.ExecuteNonQuery() and when I open the watch window, I am unable to type anything into the name column.
  2. dougancil

    Line 1: Incorrect syntax near ','. Unclosed quotation mark before the

    I've looked in the watch tab and there's no data there.
  3. dougancil

    Line 1: Incorrect syntax near ','. Unclosed quotation mark before the

    I set the breakpoint and looked through all of the tabs under the breakpoint and don't see any errors. Here's what I see in my call stack: App_Web_vt3jqd7q.dll!_Default.SaveToDatabase(String SavePath = "L:\wwwroot\Webfile1\Data\upload.txt'") Line 75 Basic >...
  4. dougancil

    Line 1: Incorrect syntax near ','. Unclosed quotation mark before the

    Ok I inserted a break point at that line. I looked at the output of the code and I looked at the output of the breakpoint. What I see is that where it says "condition" that it says no condition and then at hit count it says break always (currently 0).
  5. dougancil

    Line 1: Incorrect syntax near ','. Unclosed quotation mark before the

    Jbenson, I'm new to debugging and really don't know how to do that. I know that I can insert breakpoints, but I'm sure that's not what you're telling me to do here.
  6. dougancil

    Line 1: Incorrect syntax near ','. Unclosed quotation mark before the

    Mark, The SQL that you see there: bulk insert dialerresults from '" & SavePath & "' " & _ "with ( fieldterminator = ',', rowterminator = '\n' )" Is the only SQL that I have (besides the connection string) If you strip out the SavePath statement, the command is simply...
  7. dougancil

    Line 1: Incorrect syntax near ','. Unclosed quotation mark before the

    Can someone please review my code and see where I can be missing information. I get the following error: Line 1: Incorrect syntax near ','. Unclosed quotation mark before the character string ' )'. at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception, Boolean breakConnection)...
  8. dougancil

    Operating system error code 3(The system cannot find the path ...)

    Mark, You are right, it's not a permissions issue. I modified the machine.config file on the web server and impersonated the admin account to be able to work through this error and was confronted with another error about another line written within the .vb codebehind. That's my next issue. I'm...
  9. dougancil

    Operating system error code 3(The system cannot find the path ...)

    I have a page that I've built that does a bulk insert from a file that is stored on a web server. When the user clicks on the submit button, they receive the following error: Operating system error code 3(The system cannot find the path specified.). I have made sure that the SQL server has...
  10. dougancil

    File not being uploaded but also not receiving any errors

    I was told this by another developer (via another forum) but as I cant find it, I'm now assuming that that may not be the cause.
  11. dougancil

    File not being uploaded but also not receiving any errors

    Jason, What I'm asking is ... where is the updatepanel? I was told that the reason that my files weren't uploading is because my "file1" is within an updatepanel. I've looked through my code and don't see where that's located. I'd gladly remove the code if I knew where it was.
  12. dougancil

    File not being uploaded but also not receiving any errors

    Can you identify that to me? I had that pointed it out to me by someone else but they didn't identify where that was.
  13. dougancil

    File not being uploaded but also not receiving any errors

    Is there an easy workaround for that kind of issue? I don't want to go back and have to re-write my code to get that to work.
  14. dougancil

    File not being uploaded but also not receiving any errors

    Jason, it appears that the problem is related to UpdatePanel that I have put File1 within. I have to look at that for the answer.
  15. dougancil

    File not being uploaded but also not receiving any errors

    I just tried to upload a file that was not in the correct format (the page is only supposed to accept .txt files and I tried to upload a .pdf) and I'm not getting any return errors for that either.
  16. dougancil

    File not being uploaded but also not receiving any errors

    I have verified that both the uploaded file and the sql table are both empty.
  17. dougancil

    File not being uploaded but also not receiving any errors

    Jason, Thank you for your response but the reason that I'm displaying the error to the user is that this is going to be used by medical offices and they are known for just sending e mails stating "this web page/link/whatever is broken or not working." The error message I'm giving them is so...
  18. dougancil

    File not being uploaded but also not receiving any errors

    I have a site that I've almost completed and while testing it today noticed that it's not uploading any files or doing the bulk insert in SQL that I need it to. Here is my codebehind: Imports System.IO Imports System.Data Imports System.Data.SqlClient Partial Class _Default Inherits...
  19. dougancil

    Database connection string attached to an upload onclick

    J, So after I call the connection string in the .vb file, I can add the rest of the bulk insert in the TRY correct?

Part and Inventory Search

Back
Top