store a text file to a central databse ?

[prgm]

Hi all,

I have created an applicaiton in VB6.0 in this appln. i load data from a text file (its like-reading and writing to a text file) I want the content of thsi text file to store it in a central databse -on the server side.

I dont know how can i do this..which technololgy to use. the oracle is running ona linux OS and vb is in windows...hence different platform how do i connect them.can someone plz. give suggestions.

thanks

 

[fredericofonseca]

Depends on what you wish to do.

You can either have each line of the file as an independent record on the database or have the whole file as one record/field on the DB.

The first one you deal with a plain insert, the second one you use the appendchunk method (if using ADO) to add the file into a single field on individual record.



Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com