View original (French)

ACCESS TO AS400

guillaumekoffy Posted messages 4 Status Member -  
biere Posted messages 9 Status Member -
I would like to know if I can connect Microsoft Access and an AS400. If it's possible, how to do it?

4 answers

  1.
    grofwa Posted messages 440 Status Member 479
     
    Hi,

    Theoretically, there are no problems. You just need to take the ODBC drivers for AS/400 and link the tables.

    michael.

    Don't worry about not being noticed; rather, try to do something remarkable [Confucius]
    0
    1. Guillaume
       
      How are we going to growfa!!!!!!!!!! thank you for the reply, but where can I find the ODBC drivers for AS400
      0
    2. grofwa Posted messages 440 Status Member 479
       
      Hi,

      I would say that *normally*, with your AS/400, you should receive ODBC drivers (it's DB2, the DB?). It's kind of the idea, every DBMS comes with its drivers.

      Michael

      Don’t worry about not being noticed; instead, look to do something remarkable [Confucius]
      0
  2. Guillaume
     
    Hi, thanks my guy
    0
    1. sp AS/400 Posted messages 2 Status Member
       
      If you want a more integrated solution on the 400 side, you have this type of tool, see the link below.
      http://www.easycom-aura.com it does everything ...
      0
      1. biere Posted messages 9 Status Member > sp AS/400 Posted messages 2 Status Member
         
        Can you tell me a bit more about Launcher? Is it reliable (security)?
        Thanks in advance.
        0
  3. grofwa Posted messages 440 Status Member 479
     
    But there’s nothing to it, my friend!
    (but do we know each other? )

    Don’t worry about not being noticed; instead, aim to do something remarkable [Confucius]
    0
  4. http://pagesperso.laposte.net/kaillou/index.php
     
    If you use "client access" or a compatible emulator (easy to spot, you just need to see if the 400 STRPCO command works from your PC in 5250 emulation!) as an AS400 emulator, you just need to record a transfer request (in the taskbar you can find downlink and uplink of indo), then you run it either from your PC or from your AS400, and that’s it. For more info if you’re missing some, write me a message at http://pagesperso.laposte.net/kaillou/index.php
    0