Click here to Skip to main content
15,897,891 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: memorystream Pin
Guffa22-Aug-07 4:57
Guffa22-Aug-07 4:57 
GeneralRe: memorystream Pin
WhiteGirl2322-Aug-07 9:01
WhiteGirl2322-Aug-07 9:01 
QuestionFile Association Pin
Kschuler21-Aug-07 7:34
Kschuler21-Aug-07 7:34 
Questionhandshaking through a subdirectory Pin
MartyK200721-Aug-07 6:55
MartyK200721-Aug-07 6:55 
AnswerRe: handshaking through a subdirectory Pin
Dave Kreskowiak21-Aug-07 7:34
mveDave Kreskowiak21-Aug-07 7:34 
GeneralRe: handshaking through a subdirectory Pin
MartyK200721-Aug-07 8:00
MartyK200721-Aug-07 8:00 
GeneralRe: handshaking through a subdirectory Pin
Dave Kreskowiak21-Aug-07 8:53
mveDave Kreskowiak21-Aug-07 8:53 
AnswerRe: handshaking through a subdirectory Pin
andyharman21-Aug-07 8:45
professionalandyharman21-Aug-07 8:45 
Hi Martin

We get our mainframe to follow a strict protocol:
  • FTP (or file-copy) the big data file into the folder (e.g. "MyData20070821_1.dta").
  • FTP a zero-sized flag file with the same basename (e.g. "MyData20070821_1.flg").
Our reeeeally cutting-edge VbScript program then periodically looks for flag files in the input folder. It can then safely assume that the associated data file(s) have been successfully uploaded.

I would recommend that the file names should be uniquely-named. Ours weren't so we appended a unique ID number into each data file's name (and we tagged any resulting database records with that id too). We move all processed files into an "archive" folder as an audit trail - and also so we can potentially rerun files if we need to restore our database for any reason.

We prototyped an alternate mechanism a couple of years. We found that FTP placed an exclusive-write lock on the uploading data file - so we added some logic to obtain a read-lock on the file. If our lock failed then we could assume that FTP was still manfully trying to upload the file.

Hope that helps.
Andy

If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message".

GeneralRe: handshaking through a subdirectory Pin
MartyK200721-Aug-07 21:05
MartyK200721-Aug-07 21:05 
AnswerRe: handshaking through a subdirectory Pin
Luc Pattyn21-Aug-07 12:30
sitebuilderLuc Pattyn21-Aug-07 12:30 
GeneralRe: handshaking through a subdirectory Pin
MartyK200721-Aug-07 21:07
MartyK200721-Aug-07 21:07 
QuestionCrystal Reports and Queries Pin
Dreamer200721-Aug-07 5:35
Dreamer200721-Aug-07 5:35 
AnswerRe: Crystal Reports and Queries Pin
TomGarth21-Aug-07 12:40
TomGarth21-Aug-07 12:40 
QuestionInstalling a font from setup Pin
dptalt21-Aug-07 5:30
dptalt21-Aug-07 5:30 
Questionregistering a library through regasm Pin
sheth.mital21-Aug-07 4:32
sheth.mital21-Aug-07 4:32 
AnswerRe: registering a library through regasm Pin
Dave Kreskowiak21-Aug-07 5:08
mveDave Kreskowiak21-Aug-07 5:08 
QuestionForm's Title Pin
ejaz_pk21-Aug-07 4:18
ejaz_pk21-Aug-07 4:18 
AnswerRe: Form's Title Pin
Dave Kreskowiak21-Aug-07 5:11
mveDave Kreskowiak21-Aug-07 5:11 
AnswerRe: Form's Title Pin
nlarson1121-Aug-07 5:41
nlarson1121-Aug-07 5:41 
QuestionImport Pics on project and reDel it .. problem ? Pin
kindman_nb21-Aug-07 3:36
kindman_nb21-Aug-07 3:36 
AnswerRe: Import Pics on project and reDel it .. problem ? Pin
leckey21-Aug-07 3:58
leckey21-Aug-07 3:58 
GeneralRe: Import Pics on project and reDel it .. problem ? Pin
kindman_nb21-Aug-07 9:39
kindman_nb21-Aug-07 9:39 
GeneralRe: Import Pics on project and reDel it .. problem ? Pin
Dave Kreskowiak21-Aug-07 10:28
mveDave Kreskowiak21-Aug-07 10:28 
QuestionMulti Language Interface ... Problem Pin
kindman_nb21-Aug-07 3:33
kindman_nb21-Aug-07 3:33 
QuestionMessage box results.... Pin
Joey Picerno21-Aug-07 3:06
Joey Picerno21-Aug-07 3:06 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.