Ref thread705-1703957
I am using code based on 1DMF's method in a database I wrote a number of years ago. This code has been working perfectly ever since for a client company transferring .csv order files created in an access database and then passed to their suppliers for fulfilment. The same FTP routines are also used to transfer summary data to the head office on a weekly basis. Just recently but for some weeks now, some of these transfers have been failing. They do not report any errors and the routines continue past the actual transmission as if all was well. However at the receiving end the files have been truncated and do not contain all the data!
This is happening on just 3 machines of 7, all of which are transmitting to the same place, using the same security and were set up by the same IT people. I have run some tests by amending the domain, logins etc and transmitting using the same database etc from my machine to my personal domain. The files appear to transfer but are truncated consistently, repeating a transfer proves the failure point is always the same. Changing the buffer size changes the point at which the file is truncated. There is nothing in the data which would cause truncation and I am at a loss to explain the issue. The only common factor is that the machines which fail (including mine) are running windows 7, those that work are running XP - and of course the code! Copying the database to one of the 4 working machines and running the transfer again from there results in the files being transmitted correctly.
Does anybody know of any sudden issues with wininet or any upgrades to win7 which might have a bearing? I am running out of ideas? I have watched the code run and all data appears to be processed through the routine and sent correctly! The working machines remain functioning perfectly, it is just the win7 machines which fail.
Hope somebody can help point me in the right direction. I am supposed to have retired but this client is completely stuck and have turned to me as a last resort! I have spent all day looking but so far can't see anything which would explain what it happening.
Thanks
I am using code based on 1DMF's method in a database I wrote a number of years ago. This code has been working perfectly ever since for a client company transferring .csv order files created in an access database and then passed to their suppliers for fulfilment. The same FTP routines are also used to transfer summary data to the head office on a weekly basis. Just recently but for some weeks now, some of these transfers have been failing. They do not report any errors and the routines continue past the actual transmission as if all was well. However at the receiving end the files have been truncated and do not contain all the data!
This is happening on just 3 machines of 7, all of which are transmitting to the same place, using the same security and were set up by the same IT people. I have run some tests by amending the domain, logins etc and transmitting using the same database etc from my machine to my personal domain. The files appear to transfer but are truncated consistently, repeating a transfer proves the failure point is always the same. Changing the buffer size changes the point at which the file is truncated. There is nothing in the data which would cause truncation and I am at a loss to explain the issue. The only common factor is that the machines which fail (including mine) are running windows 7, those that work are running XP - and of course the code! Copying the database to one of the 4 working machines and running the transfer again from there results in the files being transmitted correctly.
Does anybody know of any sudden issues with wininet or any upgrades to win7 which might have a bearing? I am running out of ideas? I have watched the code run and all data appears to be processed through the routine and sent correctly! The working machines remain functioning perfectly, it is just the win7 machines which fail.
Hope somebody can help point me in the right direction. I am supposed to have retired but this client is completely stuck and have turned to me as a last resort! I have spent all day looking but so far can't see anything which would explain what it happening.
Thanks