Solved

Clear Communications Between VB , UNIX, and Oracle

Posted on 2002-06-26
5
139 Views
Last Modified: 2010-05-02
I need to create a VB application that will:

1) execute commands in UNIX.
2) retrieve messages/responses from UNIX to show on the VB client
3) execute Oracle commands (including using a SQL loader)
4) retrieve responses including error messages generated to show on the client.

This will probably take some time to provide the detail needed for both Oracle and Unix solutions.  If you need me to explain what I know to help you write a helpful answer just ask.  

I am experienced in VB, UNIX and with SQL in Oracle but have never needed to create such an "interactive" connection as this.  I have just connected to recordsets and run shells looking for no response back.

Thanks in advance!

0
Comment
Question by:Randy2001
5 Comments
 
LVL 28

Accepted Solution

by:
vinnyd79 earned 300 total points
ID: 7111421
0
 

Expert Comment

by:jisc
ID: 7112765
Have you heard IPWorks Controls? Its a third party components which handles communication between IPs including UNIX.
0
 
LVL 28

Expert Comment

by:vinnyd79
ID: 7113229
jisc,Welcome to EE. Comments can be accepted as answers so it is recommended that you post comments unless you are 300% sure that your answer is what the asker is looking for.By proposing an answer the question gets locked and alot of experts will not look at the question.So,to ensure that the asker gets the most out of his question it is recommended to submit comments instead of answers.
0
 

Author Comment

by:Randy2001
ID: 7113348
Using third party controls that are not already provided in the Microsoft or UNIX env. are somewhat of a last resort if solutions that we have already paid for are not available.  If we come around to looking at third party tools yours is the first on the list for review.

Thanks!
0
 
LVL 49

Expert Comment

by:DanRollins
ID: 7964506
Hi Randy2001,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:

    Accept vinnyd79's comment(s) as an answer.

Randy2001, if you think your question was not answered at all or if you need help, just post a new comment here; Community Support will help you.  DO NOT accept this comment as an answer.

EXPERTS: If you disagree with that recommendation, please post an explanatory comment.
==========
DanRollins -- EE database cleanup volunteer
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

Introduction I needed to skip over some file processing within a For...Next loop in some old production code and wished that VB (classic) had a statement that would drop down to the end of the current iteration, bypassing the statements that were c…
Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

895 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

12 Experts available now in Live!

Get 1:1 Help Now