Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Accessing DB2 database and creating reports with VB

Accessing DB2 database and creating reports with VB

Accessing DB2 database and creating reports with VB

Would VB be an efficient/useful language if I wanted to access a DB2 database and retrieve information? And after acessing this, allow consumers to be able to create reports online using the information pulled off of the DB2 database? Can all this be done with VB?
Know a site where this information can be found? Thanks.

RE: Accessing DB2 database and creating reports with VB


Would be and is, as long as you have an ODBC connection to DB2.

We (read that as one other and me, but she is doing most of the work - one of the advantages of being an old cripple is to be able to delegate w/o repercussion <grin!>!) use the InterSolv SequeLink client/server product to talk to DB2 (on IBM big iron, VMS host (I think)). It installs a 'thin' server on the DB2 platform, and an ODBC client on the local box. There are other DB2 ODBC connectivity resolutions, so my explain may be a little off-kilter for them.

ODBC aside, we use three approaches to reporting from the DB2 database. (As an aside, we also link in ODBC connectivity to some Oracle tables and even a couple of MS Access .mdb files.)

The first approach, and the most commonly used, is a VB launch mechanism which populates pre-designed Crystal reports (v6.0 currently, but I've been using this method since version two or three) with user-selectable parameters, up to five parameters, then 'prints' the reports to screen, with option for hardcopy or export to Excel, Word, etc.. The VB launch mechanism is fairly straightforward, and allows you to build a few 'generic' reports that can end up highly customized depending upon user input.

The next approach is to build a hard-coded report from SQL and raw code (no user input except, "Press the button, Max!") to build a 'fixed' report, i.e., a 'standard' report that allows of no change.

The last approach involves use of a third-party control, the VS OCXs. Using the VSPrint and VSView capabilities, I've been able to create coherent reports out of multiple, non-relational (non-realted?) SQL statements, all on one page. Could do the same in Crystal, but would be a page per SQL statement. Could do in plain vanilla VB via the printer object, but wouldn't have the 'pretty-print' capabality so easily, or perhaps at all.

If any of this seems to be something useful to you, just say what you want and I'll try to expand, or supply code where possible.

Make a good day . . ..

RE: Accessing DB2 database and creating reports with VB

You may find the following middleware names useful if you are seriously contemplating Vb with a DB2 back-end. VB can be a very useful language with DB2. In fact I state as a matter of fact - the largest retailer in the UK (ok perhaps now the 2nd largest) uses VB as its main front end gui for DB2 in all implementations - and very successfully at that....

The two main middleware solutions for efficient connectivity from a VB front end and a DB2 subsystem that I have come accross - are products called XDB and Shadow Direct.
I suspect the latest ado technology in vb6 could influence your decision (I am just starting to familiarise with that as apposed to the older RDO)- and I have to confess - at the time I used both middleware solutions - I was using vb3 and 4. perhaps much has changed since then...and I do suspect - that middleware may be 'overkill' if you are not looking for a full 'client server' type
installation of VB<--->DB2 but could luck in your hunt for a solution.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close