Solved

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

Posted on 2004-10-07
1
286 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
Comment Utility
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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
dividesSelf challange 15 77
countHi challenge 25 84
C# code editing and collaboration 3 39
SUM 2 INTEGER ARRAYS INTO 1 10 56
This article will show, step by step, how to integrate R code into a R Sweave document
A short article about problems I had with the new location API and permissions in Marshmallow
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 fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

743 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

17 Experts available now in Live!

Get 1:1 Help Now