Solved

Developing a client server application to access non-ODBC compliant database

Posted on 2004-10-07
1
293 Views
Last Modified: 2010-04-17
Hi!
I have a situation where the customer is using a non-ODBC compliant database on Windows 2000 platform.  They have an ActiveX component to develop VB application to access the database records from Win2K system. However, i will need to access the ActiveX application from Solaris system over TCP/IP.

+----------+                                 +--------------------------------+                 +--------------------+
+ Solaris  +===>TCP/IP=====>+ Winn2K ActiveX Application +======> Database Resource
+----------+                                 +---------------------------------+                +--------------------+

I will need to submit the stored procedures/queries from Solaris and retrieve records from the databse. I will also need to keep track of each request made, so that responses received will match that instance of query.

Any ideas on the design concept or code structure will be highly appreciated.
westclox
0
Comment
Question by:westclox
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 11

Accepted Solution

by:
pratap_r earned 500 total points
ID: 12260617
this is a typical client server model application. interfacing with a legacy system? :)

anyways here is what you could do. create a server or stub in vb or some language you are comfortable with. make it listen on some port (i am going with the server client model). now in solaris make a client which will send the requests to this port. basically you need to write wrappers. not that hard once you get the hang of it.

we used MQ instead of directly dealing with socket or pipe based approach. ease of implementation.

I guess I can help you if you need more information on the design :-)

Enjoy!
Pratap
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
This article will inform Clients about common and important expectations from the freelancers (Experts) who are looking at your Gig.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question