How to connect to the mainframe database thru Visual Basic

ARUN.A.NAIR · Posted: Sat May 12, 2007 3:07 pm

Hi,

I am on the process of developing a tool using Visual Basic which will run on windows platform. The tool is basically handling SQL queries. I am sending queries through the tool to DB2. Can anyone guide me how to connect to the mainframe database through Visual Basic as this is the first time I am trying to connect to Mainframes through windows!

Thanks and regards,
Arun.A

dick scherrer · Posted: Mon May 14, 2007 9:39 am

Hello,

Your best bet is to talk with the network and/or the DB2 support people and have them tell you how this is done at your location.

Organizations that support remote connectivity usually have standard practices and they should be followed.

deepak.vl · New User Joined: 17 Feb 2007 Posts: 38 Location: Hyderabad

You can do it by using DB2CONNECT entreprise version software. Before this, you need to have a port opened by your DB2 DBA for this tool to access the database.
You can use a ODBC:JDBC driver to connect to DB2 from a Java applicarion. I am not sure about VB.

dick scherrer · Posted: Wed May 23, 2007 6:58 pm

Hello,

The connection is not necessarily language dependent - it is all up to what connection(s) have been /will be defined and the rules for using them.

As suggested previously, check with your network and database people for how this should be done on your system.

Good luck and we're here if there are questions after you've actually begun using the connection on your system.

ARUN.A.NAIR · Posted: Wed May 23, 2007 7:07 pm

Thanks a lot Scherrer and Deepak for your inputs!
I will get in touch with my DBA for assistance further on the connection.

Regards,
Arun

dick scherrer · Posted: Wed May 23, 2007 9:49 pm

You're welcome

Once you have it working, and if you have a few minutes to post your solution, it may help others with a similar question later.