how to store an attachment from visual basic 6.0 into oracle 8i? I want to store word document into oracle 8i from vb6.0. I have made a screen in vb which ask user to attach word document using browse button. Also screen have other fields like name, address ettc. as well Then i want same word document to go into oracle alongwith other fields. Also after storing the attachment into oracle, how we can retreive it back again into vb? I mean i want to & fro movement into vb & oracle of attachment . If possible kindly elaborate ur answer
2007-04-09 23:18:51 · 2 answers · asked by vohra_sapna 1 in Computers & Internet ➔ Programming & Design
Rather than storing the file on the file system, you will need to create a table to store the file in a column of type BLOB. Then you can use ADO or ODBC to read/write the data from VB to your database table.
There is some sample code here http://forums.devx.com/showthread.php?t=142463 that should get you started.
2007-04-17 15:16:31 · answer #1 · answered by Andy M 2 · 0⤊ 0⤋
I admit that I am not an expert but the usual type of data stored on an SQL database is numbers and text. So in your case you would be looking to store the downloaded file in a directory and then saving the file name (with or without the directory path) in the database.
2007-04-10 09:47:22 · answer #2 · answered by AnalProgrammer 7 · 0⤊ 1⤋