Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 Looking for Mainframe job Chandan1993 Mainframe Jobs 0 Sun Sep 24, 2017 1:06 am
No new posts How do I create a mainframe monitorin... anjali.bisht All Other Mainframe Topics 4 Fri Sep 01, 2017 2:20 pm
No new posts Mainframe dataset split purushottam DFSORT/ICETOOL 13 Tue Aug 29, 2017 12:28 pm
No new posts FTP data transfer from PC to Mainfram... AJAYREDDY All Other Mainframe Topics 8 Wed Aug 23, 2017 9:59 pm
No new posts Allianz Technology - Mainframe 3+ Yea... sooraj184 Mainframe Jobs 0 Mon Jul 31, 2017 2:17 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us