Search results for query: *

  1. C

    SQL Server error: Timeout expired

    Yeah, I am fully aware of the problem(and more), Luckily this is just a "favour" I am doing for someone and not my day-job. With the delay its running quite slow but we are almost 10% there, so I am positive.
  2. C

    SQL Server error: Timeout expired

    Ok here is what I THINK is happening, on the faster computer, SQL server can load the records fast enough so that every time the SQLReader wants a new Document there is one available, but on the actual database I need to work on, SQL Server is much slower. This is also visible if you just...
  3. C

    SQL Server error: Timeout expired

    Yeah you are absolutely right, I made a huge database on my machine and it all worked. So it could be something with the machine I am executing it on.
  4. C

    SQL Server error: Timeout expired

    Unfortunately I am running an old .NET framework where this is not yet implemented. Sadly.
  5. C

    SQL Server error: Timeout expired

    Thank you for the response, Yeah I know my code is not super great. (No excuses there. - it was supposed to be a super small tool that should have been done by now) I cleaned it up with same result. Here is what makes this so tricky, the PDF's that I am extracting is very confidential, so the...
  6. C

    SQL Server error: Timeout expired

    Any ideas?
  7. C

    SQL Server error: Timeout expired

    I was almost happy... it ran through once then I made a small code adjustment, just naming the files differently(Changing it back makes no difference). And now the error is back....sigh! Here is the code that saves the PDF PS. it now breaks very quickly after around +- 150 PDF's String...
  8. C

    SQL Server error: Timeout expired

    @Sheepings Arent we all? programmers are after all the laborers of the 21st century.... @Skydiver Your comments gave me an idea about how I was saving the files, I changed method and it seems to be running smooth now. If all works ill post what I learned. Thank you
  9. C

    SQL Server error: Timeout expired

    I think you misunderstood my problem, I am reading from the blob in the Database and saving PDF files on the harddrive. But thank you for the advice, I hope someone else have a good idea, I am out of them.
  10. C

    SQL Server error: Timeout expired

    I set an execution timeout, But I realized now that would not have made a different since it was set on infinite when I found it. I just set it back to default then. 1. I added the command.CommandTimeout = 60; code as per the link above, no difference. 2. I have run a query that gets some...
  11. C

    SQL Server error: Timeout expired

    Hi all, I am connecting to a SQL server 2005 using C#. All running on Windows server 2003. I have to read 270 000 PDF files and save them in a folder. A random time into the reading and saving the PDF files I get this error. I have changed timeout settings and so fourth, But I am not sure what...
  12. C

    Reading Objects to PDF from SQL server DB

    EDIT, It works, The problem came with some idiot(Me) copy and pasting like a lunatic. Thanks for the help
  13. C

    Reading Objects to PDF from SQL server DB

    Thank you for the help, I have around 270 000 PDF's in a 170GB databse, so under 1mb per PDF. I implemented your suggestion, and the output from this is the same as before, Same size pdf's but they are not readable. I am starting to think that there could have been something done to the PDF's...
  14. C

    Reading Objects to PDF from SQL server DB

    I have some PDF files saved as an object in SQL Server(I did not put them there, my job is just to retrieve them), and I would like to save those back as PDF's. I currently have this. It is saving PDF's but they cannot be opened. They are of appropriate size so there are bytes read into them. I...
  15. C

    Drawing 2D regions on a Map

    I have points that defines the outlines, but the problem is that there are holes in the shapes. So I need to tell the library that I am drawing a hole in the shape. In the current configuration it basically is not a shape with a hole but rather a shape that wraps around itself
  16. C

    Drawing 2D regions on a Map

    Yes I am aware, but if you look below, here is an example of exactly the problem, the region has "holes" in it. This creates a problem with the current library, So what I need is some way to make complex shapes with holes in it.
  17. C

    Drawing 2D regions on a Map

    This should be much easier than what I am experiencing. I think I'm being dumb. Anyway I need to draw complex 2D regions (with holes and may consist of a few areas not physically connected) on a world map in C# winforms, then also get an event triggered when one is clicked(also need to know...
Back
Top Bottom