Results 1 to 7 of 7
  1. #1
    2 Star Lounger
    Join Date
    Mar 2003
    Location
    London, Gtr London
    Posts
    131
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Linking Access to a SCO Unix Server (2003)

    Could someone please help. I'm trying to link my new version of access to our SCO Unix server but I cannot seem to be able to do it.

    Previously I used Access 97 which linked to the Unix box using ODBC software, but now that I have upgraded to Access 2003 I can't reinstall the ODBC software because of a licensing issue.

    I have heard that I can use something called an ADO connection but I don't know how this works.

    Many thanks in advance
    Hayden

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Linking Access to a SCO Unix Server (2003)

    Unfortunately, ADO won't help you much, as it is just another Data Access method like DAO. If the Unix server software is OLE DB compliant, you should be able to connect directly, but in my view that's pretty unlikely. We would need to know more about the package you are using on the Unix server to be able to provide specific help. I think you will probably end up need to have ODBC to make things work in the long run, so solving the licensing issue is probably the best path to pursue.
    Wendell

  3. #3
    2 Star Lounger
    Join Date
    Mar 2003
    Location
    London, Gtr London
    Posts
    131
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linking Access to a SCO Unix Server (2003)

    Thanks for your reply Wendell, I'll re-look at the licensing again.

    By the way, by "package" are you meaning the software/program we are using on the Unix server?

    Regards
    Hayden

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Linking Access to a SCO Unix Server (2003)

    That's what I had in mind - is it Informix, DB2, Oracle, mySQL or someother database product, or is it a custom application that exposes data in some fashion? The answer could be different for some products than others.
    Wendell

  5. #5
    2 Star Lounger
    Join Date
    Mar 2003
    Location
    London, Gtr London
    Posts
    131
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linking Access to a SCO Unix Server (2003)

    I think it is Informix.

  6. #6
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Linking Access to a SCO Unix Server (2003)

    HMMM - after doing a bit of a search, it appears several vendors may have OLE DB capability - see this URL http://ourworld.compuserve.com/homepages/K...th/oledbVen.htm, that at least one has native mode support for ADO - http://www.datadirect-technologies.com. Hope this helps.
    Wendell

  7. #7
    2 Star Lounger
    Join Date
    Mar 2003
    Location
    London, Gtr London
    Posts
    131
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linking Access to a SCO Unix Server (2003)

    Thanks Wendell

    I'll look into those links you gave.

Posting Permissions

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