Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Web display of DB2 data
- Thread starter goodhat
- Start date
Goodhat,
You need to be more specific. You should already have an idea of what/how you want to do. Operating system, programming language, communications architecture are all things which spring to mind.
Please re-post with more info and we will try to help.
Have a look at: FAQ222-2244 which may help you get the most out of these forums.
![[smile]](/data/assets/smilies/smile.gif "[smile] [smile]")
Marc
You need to be more specific. You should already have an idea of what/how you want to do. Operating system, programming language, communications architecture are all things which spring to mind.
Please re-post with more info and we will try to help.
Have a look at: FAQ222-2244 which may help you get the most out of these forums.
Marc
- Thread starter
- #3
An ASP on the web side, ODBC using DB2 driver to connect to DB2 database. I know how to do this on the web side, what needs to happen on the mainframe side?
I am lost as how to make this happen, the LAN dept does not have the expertise, nor I to understand how to go about this. I have spent a lot of time on the net looking into solutions and have concluded that there are middle ware companies which want to connect the enterprise.
But I have one database.
Could you give me direction.
I am lost as how to make this happen, the LAN dept does not have the expertise, nor I to understand how to go about this. I have spent a lot of time on the net looking into solutions and have concluded that there are middle ware companies which want to connect the enterprise.
But I have one database.
Could you give me direction.
The first thing you are going to need to do is to configure your ODBC driver to access the mainframe db2 tables. In theory, this should be done by your DBA department, particularly if you intend to perform updates, as there are security issues here that need to be addressed.
Do you have a DBA department to talk to you or can you already fire off a piece of SQL that uses the ODBC driver to get some mainframe data?
Do you have a DBA department to talk to you or can you already fire off a piece of SQL that uses the ODBC driver to get some mainframe data?
- Thread starter
- #5
I assume you are working with an AS/400? You need Client Access installed on the server. On the server, go to the ODBC manager from control panel, and make a new system DSN. In the driver box, choose Client Access ODBC driver, and fill in the information. The data source name is the name you will be referring to it in code. I used as400.
The AS400 system should be filled in already. Don't forget to add the libraries on the Server page.
I hope this helps.
Cheers!
The AS400 system should be filled in already. Don't forget to add the libraries on the Server page.
I hope this helps.
Cheers!
I've connected from Access and Excel via ODBC to a mainframe (OS390) DB2 system , but the ODBC driver was set up by the DBAs. I seem to recall that there were RACF group authorities on the mainframe that had to match up with authorities on the LAN.
Have you any maniframe DBAs that can help you out?
Have you any maniframe DBAs that can help you out?
- Status
Similar threads
- Locked
- Question