vb-xml-database

[discover]

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

 

[java guru]

You could use ODBC.

- Get ODBC Drivers from Oracle
(http://www.oracle.com/technology/software/tech/windows/odbc/index.html)
- Install them
- Goto Control Panel | Administrative Tools | Data Sources (ODBC)
- Configure datasource with the same information you would have in your
tnsnames.ora file in order to connect to the Oracle database with sqlplus
- I'm not a VB programmer but given the name of the data source you created
you should be able to execute SQL commands for the database.

Good luck