I am supposed tocreate an data transfer utility that isto take data from an external source. in this case it's another database, and import/update data into an asp.net website database.
Now, the database and the site were created by another party and they already have an API/framework to access the database.
I've tried to write code on the site that imports the data but it sometimes times out and the app pool recycles.
How do I run a data transfer without timeouts andusing the third part API so I don't have to re-write a ton of code?
Probably not enough information to answer your question.
1) Explain how you have tried your export/import.
Ex: Run a query, collect the data, save it to a text file.
Run a program which calls the API to import the data line by line.
2) Do you have local access to both databases?
3) What is the nature of the API ? Is this a webservice? Are your sure you are using the API as recommended by the vendor? I have a vendor supplied API which uses tons of memory if I try to load data with it. I had to break my program into chunks so that their library could free up memory in between my data load sessions. This makes me believe that they are doing some sloppy memory management (not disposing of objects)
4) You might want to check with the vendor about the proper use of their API.
5) Maybe post a code snipet here.
The folks here will try to give you an answer, but I think more details are needed.
Depending on how big your images are, and which browsers you need to support, you might be able to use a data URI[^]. (If you're using IE8, you're limited to 32Kb; earlier versions of IE aren't supported at all.)
If you need to support older versions of IE, you'll need to pass a query-string to your handler. If the image is more than 32Kb, it'll be too large for a query-string, so you'll need to pass some kind of ID to allow the handler to retrieve the image.
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
I am a total noob to ASP, so I hope you can bear with me while I get the stupid questions out of the way.
I have an .ASP registration popup form on my webpage that is being attacked by bots. They can't get in because each user must be activated on the server side first, but they are starting to get annoying due to the number of false registrations I have to delete.
I know there is CAPCHA code available, but I want to make it very simple for my customers when they register so I was wondering if I could just add a yes/no type question to my "If/then/else function", for example "is the sky blue", or "are you from Mars", "are you a human", etc. then have a field that has to be filled in with the correct answer, have the answer checked by the statement and if it is incorrect the form is closed or cleared, if it is correct the form stays active and they can submit it.
I don't like the random word images with all the scribbles, some of them are too long or are hard to read, and I'm not very good at coding ASP yet that I could find the right place to put all that code. Also, a humanizer question can be changed at any time very quickly by me if any bot figured it out - IF it would work.