×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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

ODBC and Sequential Mainframe files

ODBC and Sequential Mainframe files

ODBC and Sequential Mainframe files

(OP)
I have a User who says ODBC drivers exist that allow MS ACCESS to read Mainframe sequential files.  I thought ODBC only accessed data bases.  Can someone please comment?..

Thanks

Tom

RE: ODBC and Sequential Mainframe files

Yes, there are such ODBC drivers.  I currently have several VB and Access applications using the ODBC drivers that shipped with Client Access/Personal Communications running over AS/400 files.  Since the drivers are IBM-supplied, I'd suspect that it would work just as easily with a mainframe.

All I had to do was install the drivers and create a DSN to point to the 400's IP address.

RE: ODBC and Sequential Mainframe files

Quote (TomDx):

I thought ODBC only accessed data bases.

Hmmm....  While they may not be a fully implemented relational database, those sequential files are a database.

Tom Morrison
www.liant.com

RE: ODBC and Sequential Mainframe files

(OP)
GhostWolf, could you give me some specifics about the driver(s) that you are using..?  Maybe where or how to get them?  I've managed to connect MS-ACCESS to the DB2 SubSystem on our mainframe, but I'm not making any headway in accessing a VSAM or sequential file.  I know very little about ODBC, and unfortunately it is not widely used at my Company.

Thanks


Tom

RE: ODBC and Sequential Mainframe files

Tom,

CONNX is probably the most well known of the ODBC drivers for VSAM.  connx.com

Is it possible that the DB2 subsystem has any mechanism to use the VSAM files?

Tom Morrison
www.liant.com

RE: ODBC and Sequential Mainframe files

Tom,

The drivers I'm using originally came from our Client Access install disks. Setting up a DSN with that driver was only slightly more difficult than pointing to our AS/400's IP address and defining the library list, (and a few other parameters).

Once it was set up, all I had to do was link files to Access,  (Get External Data, Link Tables, Files of type: ODBC Databases), using that DSN.  When the DSN is selected, the dialog opens a list of files in your library list and you just select the one(s) you need.

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