I have an asp script that takes a binary file, and converts it to a hexadecimal string (a very long one) and fires an SQL statement that looks like:
INSERT INTO guide (ID, Blob, DocType) values ('3', '0x6100740061003B002000D00', 'application/x-zip-compressed')
(The hexadecimal string is much longer).
It appears to work with small files (250 ish bytes), but the script hangs and seems to stop with larger ones. However even with the small files the data doesn't seem to make it as far as the database, even though the script completes correctly. The database isn't getting any bigger and if I try to view the content of the field where the file should have been uploaded to, Access says :
A problem occurred while Microsoft Access was communicating with the OLE server or ActiveX Control. Close the OLE Server and restart it outside of Microsoft Access. Then try the original operation again in Microsoft Access.
Any ideas anyone? I have been trying to get this to work for days now. In case it is relevent, the file data is sent from a form to this script, and retrieved using plain old asp without using components, which most people seem to use.
MS reckon that there maybe some problems with antivirus software, and as this server does some mission critical stuff I'm not going to be able to convince anyone to take it off. However I'm not convinced that is where the problem originates, since MS believe this is only with Norton products, and thats not used. I will try running my scripts on my home computer to prove either way some time this week.
Does anyone know of any tutorials on BLOBs specifically dealing with Access? Seen loads on SQL Server, but I'm wondering if I'm missing some settings in Access...
Hmm, would be very handy to get this to work for lots of things.