?
Solved

VB application calling DB2 on mainframe using mdi gateways

Posted on 2005-04-15
6
Medium Priority
?
388 Views
Last Modified: 2013-12-25
 How does one call a DB2 database from VB code? I am trying to use the method SqlOpenConnection(server , loginId , password , workstation ,application ) method but the arguments used in it are not very clear to me.
Can you please give me the significance of the arguments used in the above method?

We are using a MDI gateway for connecting to DB2.

How does a VB application gets connected to a DB2 via a gateway?
0
Comment
Question by:AmitSaxena
  • 3
  • 2
5 Comments
 
LVL 29

Expert Comment

by:leonstryker
ID: 13793230
0
 

Author Comment

by:AmitSaxena
ID: 13793332

  I am using VB6 , sorry forgot to mention that :)
0
 
LVL 29

Expert Comment

by:leonstryker
ID: 13793357
Then look at eh 2nd link.  What will give you the connection string you need.  Are you familiar with ADO?

Leon
0
 

Author Comment

by:AmitSaxena
ID: 13793391

   The issue is i have a already coded snippet which is using SqlOpenConnection(server , loginId , password , workstation ,application ) method.

 I am unable to interpret the arguments of this method. The code connects to the DB2 via a MDI gateway. I need to understand at the architecture level how is the method working?

 
0
 
LVL 29

Accepted Solution

by:
leonstryker earned 1500 total points
ID: 13793450
Well, take alook here (about 2/3 down the page):

http://www.webbasedprogramming.com/Web-Database-Developers-Guide-with-Visual-Basic-5/htm/ch18.htm

But I think you should recode this. It look like a leftover from VB5.

Leon
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
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…
Suggested Courses

850 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