Results 1 to 10 of 10

Thread: Connection of VB code with COBOL interface

  1. #1
    Guest

    Post

    we have developed an application in VB. Now our clients want us to run half the application using VB interface and half in COBOL. Actually the application is a payroll system. They want to utilise the interface in COBOL for the income tax part. Is it possible to use the VB code with COBOL interface?

  2. #2
    Lively Member Ishamel's Avatar
    Join Date
    Nov 1999
    Location
    Edinburgh, Scotland
    Posts
    112

    Post

    When you say "use the VB code with COBOL interface", do you mean read from/update the same database??

  3. #3
    Guest

    Post

    Ishamel, yeah i meant that how to read/update from the same database with the cobol interface.can you help me please.

  4. #4
    Lively Member Ishamel's Avatar
    Join Date
    Nov 1999
    Location
    Edinburgh, Scotland
    Posts
    112

    Post

    Do you know what type of Mainframe database you are wanting to link to?

  5. #5
    Guest

    Post


    Do you know what type of Mainframe database you are wanting to link to?
    The database that we are using is MS SQL Server. Although they don't mind using our application, but as they want to make sure that they don't make mistakes, they want us to link the vb with the cobol interface. Help me please

  6. #6
    Guest

    Post



    Do you know what type of Mainframe database you are wanting to link to?
    The database that we are using is MS SQL Server. Although they don't mind using our application, but as they want to make sure that they don't make mistakes, they want us to link the vb with the cobol interface. Help me please

    how do I know when you love me when I am sitting on you?

  7. #7
    Addicted Member
    Join Date
    Jan 2000
    Location
    Fresno, California, USA
    Posts
    195

    Post

    We haven't found any way to talk directly to SQL-Server from the mainframe. We use one of two methods to share information. We use screen scraping code for small amounts of data, and use FTP to move large amounts of data.

  8. #8
    Guest

    Post

    What our clients need is that we should try to connect the sql database connectivity which we used in our vb payroll application to the cobol interface which they already have at their place. Is it possible? Please reply. thanks for anyone helping us.

  9. #9
    Addicted Member
    Join Date
    Jan 2000
    Location
    Fresno, California, USA
    Posts
    195

    Post

    Sounds like a screen scraper application to me. You display the information you need on the PC on the mainframe screen, run the scraper (it scrapes the writing off of the mainframe screen) and uses it on the PC. HLLAPI is one of them. I haven't looked for a while, so I'm not up on these things.

  10. #10
    Guru Clunietp's Avatar
    Join Date
    Oct 1999
    Location
    USA
    Posts
    1,844

    Post

    HLLAPI is code that relies on the client to screen scrape data -- I use this at work to get info (only because I cannot get direct access to mainframe data via SNA server [politics]) but check out this page, it might help:

    http://www.4guysfromrolla.com/webtec...011300-2.shtml

    If you have a willing IT group, you can set up an SNA server which would allow you direct access to your mainframe data via ADO. Check out the M$ site regarding SNA server.

    This link might help as well:

    http://msdn.microsoft.com/library/pe...99/ivb9931.htm

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width