?
Solved

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

Posted on 2004-10-07
1
Medium Priority
?
302 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 1500 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
Starting up a Project

649 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