Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Aug 2004
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access Informix data base from WOrd Macro (Word2000/XP)

    Can someone tell me how I can access an Informix database from my Word Macro? I tried using Opendatabse but no luck there ... Please help...
    Thanks.

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Access Informix data base from WOrd Macro (Wo

    Microsoft supplies a technology called ADO (ActiveX Data Objects) which you can use to access a wide variety of databases. ADO can be used to simply open a table, or to return the results of a complex query. It is a rich object model and, unfortunately, a bit complicated to learn (and remember!).

    In order to use ADO, you need one of two things: (1) a specific ADO Provider that knows how to talk to Informix, or (2) an ODBC connection to Informix (you can use the generic ADO provider for ODBC databases). I don't use Informix, so I can't help you identify which of these things you might have. If you are using any other applications that connect to the Informix database, you may find that you have an ODBC connection set up. Check the Data Sources control panel (on Windows XP Pro, under Start>Settings>Control Panel>Administrative Tools>Data Sources (ODBC)). If you have this connection, presumably it stores the necessary username and password and you can use the generic provider.

    At that point, the question becomes, what do you need to do with this database? That will guide the details.

Posting Permissions

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