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

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
westcloxAsked:
Who is Participating?
 
pratap_rConnect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.