Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

How to connect to the mainframe database thru Visual Basic

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
View previous topic :: :: View next topic  
Author Message
ARUN.A.NAIR
Warnings : 1

New User


Joined: 07 Mar 2007
Posts: 12
Location: MAHARASHTRA

PostPosted: Sat May 12, 2007 3:07 pm    Post subject: How to connect to the mainframe database thru Visual Basic
Reply with quote

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
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon May 14, 2007 9:39 am    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
deepak.vl

New User


Joined: 17 Feb 2007
Posts: 38
Location: Hyderabad

PostPosted: Wed May 23, 2007 6:52 pm    Post subject: Re: How to connect to the mainframe database thru Visual Bas
Reply with quote

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.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed May 23, 2007 6:58 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
ARUN.A.NAIR
Warnings : 1

New User


Joined: 07 Mar 2007
Posts: 12
Location: MAHARASHTRA

PostPosted: Wed May 23, 2007 7:07 pm    Post subject: Re: How to connect to the mainframe database thru Visual Bas
Reply with quote

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
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed May 23, 2007 9:49 pm    Post subject:
Reply with quote

You're welcome icon_smile.gif

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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Produce Mainframe Dash Board Reports ... sdcarlson53 All Other Mainframe Topics 2 Thu Jan 05, 2017 11:01 pm
This topic is locked: you cannot edit posts or make replies. Urgent Mainframe Requirments (2-10 yr... Shankar779 Mainframe Jobs 0 Sun Nov 27, 2016 1:48 pm
No new posts IMS Database backup info ashek15 IMS DB/DC 14 Wed Nov 16, 2016 5:29 am
This topic is locked: you cannot edit posts or make replies. Mainframe Developer requirement in Ku... capricorn Mainframe Jobs 0 Sun Oct 23, 2016 3:49 pm
No new posts Interface from Mainframe to Confluenc... hblun CLIST & REXX 4 Tue Sep 20, 2016 5:47 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us