Discussion Locked

VB-JAVA Communication

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

hi dear friends,
there is one application in VB 6.0 having a database (SQL Server 7) on a local m/c.
there is a online portal in Java - JSP having a different database(SQL Server 7).
i want to integrate the two i.e. any changes in thedatabase of online portal should be reflected in the database of VB application (giving a popup mesg also) and vice versa.

in short i have to communicate between VB & Java. Is it possible?
i'm confused ....
plz tell me the solution ASAP bcoz of strict deadlines

thanks...

3 replies

by zblore

There are lots of ways to do it.

One way would be to use stored procedures in one SQL server to update the other one, thus keeping them in sync.

Another way would be to have either a jsp or vb component which reads from the other database and updates it

Another way would be to for one app to email the other app the details of the change...

The easiest would probably be a stored procedure but that would imply the two servers can access each other.

The popup message could be generated from whereever is necesseary.

This discussion is closed to new replies.