Solved

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

Posted on 2004-10-07
1
288 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
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Exe program is not a valid Win 32 application 15 103
firstswap challenge 20 65
base64 decode encode 12 119
C Programming - If Statement 8 72
This article is meant to give a basic understanding of how to use R Sweave as a way to merge LaTeX and R code seamlessly into one presentable document.
A short article about a problem I had getting the GPS LocationListener working.
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 …
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

932 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now