Discussion Locked

VB-Java Interaction?

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

I have got a legacy application in VB.
I have got a portal in Java.
My VB application needs to be network enabled.That means,whatever changes I make to my VB database(MS-Access) should be reflected to my website database(SQL Server) and vice-versa.
What it essentially means that clients who log in to my VB application should get current database information.

What could be the solution?How to connect my VB and Java applications so that they would be updating databases on client side as well as web?
Can CORBA be a solution?Or something else?

5 replies

by jooehrlein

No matter what, it seems like you've committed to make some coding changes. Since you'll have to make changes, my vote would be to change the VB application to use the same database as the website (SQL Server is a better choice than MS Access for this situation.). All communication can be done through the database.

Is your website currently using a middle tier application server? If so, then the simplest thing may be to interface from VB to the middle tier. It'll depend on what that tier is and what it supports, but yes, CORBA could be the answer.

IF you keep two databases, then either both applications will have to update 2 databases (it seems silly to modify both apps), or you'll have to accept some amount of disagreement and have periodic synching (a quick & dirty way, but in the long term probably a bad solution).

This discussion is closed to new replies.