Results 1 to 7 of 7
  1. #1
    Join Date
    Oct 2002
    Location
    Paris FRANCE
    Posts
    5

    Unanswered: ODBC error with ACCESS 2000 XP

    Hi
    I have an error -7711 when I try to import or link tables in MS Access 2000 under XP. I can see the list of the tables which are on a RS6000 under AIX but when I try to select them I have the error. BUT the same ODBC driver works well with Excell. Someone can help me ??
    thanks in advance

  2. #2
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    I don't think that's an Informix error.
    Can you trace your ODBC connection with SQLIDEBUG and check the output?
    rws

  3. #3
    Join Date
    Oct 2002
    Location
    Paris FRANCE
    Posts
    5
    Originally posted by Roelwe
    I don't think that's an Informix error.
    Can you trace your ODBC connection with SQLIDEBUG and check the output?
    I made the SQLIDEBUG and sqlprt and the result is in the attached file, at the begining it seems that there is a Msysconf table which is missing.
    but I have not enough knowledge to interpret this debug thanks if you can help
    Kristof
    Attached Files Attached Files

  4. #4
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    Could you check this sql?

    select count(*) from informix.systables t, informix.sysfragments f where t.tabid = f.tabid and f.fragtype = 'T' and t.tabname like 'bdaclients' and t.owner like 'bmc'

    Did you ask for a table called 'bdaclients'?
    If so is that table in the database?
    If so is the owner 'bmc'?

    If you did not ask for all that, could you also trace the Excel connection and check the difference.
    rws

  5. #5
    Join Date
    Oct 2002
    Location
    Paris FRANCE
    Posts
    5
    Originally posted by Roelwe
    Could you check this sql?

    select count(*) from informix.systables t, informix.sysfragments f where t.tabid = f.tabid and f.fragtype = 'T' and t.tabname like 'bdaclients' and t.owner like 'bmc'

    Did you ask for a table called 'bdaclients'?
    If so is that table in the database?
    If so is the owner 'bmc'?

    If you did not ask for all that, could you also trace the Excel connection and check the difference.
    Yes table and owner exist and yes it is the "bdaclients" table that I try to link in access. In fact I choose it from a list that access gives me. Access find correctly all the tables that are present in the informix database, it is when i choose one and press OK that I 've got the error .
    Does the problem can comes from the level release of my informix database because I think it is an old one.
    thanks.

  6. #6
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    If it works in Excel an it doesn't work with Access, I think it is a microsoft thing.
    ODBc is not a part of the Informix Engine, it is part of the CSDK.
    You can download the latest csdk (2.80) from
    http://www.informix.com/evaluate
    rws

  7. #7
    Join Date
    Oct 2002
    Location
    Paris FRANCE
    Posts
    5
    Originally posted by Roelwe
    If it works in Excel an it doesn't work with Access, I think it is a microsoft thing.
    ODBc is not a part of the Informix Engine, it is part of the CSDK.
    You can download the latest csdk (2.80) from
    http://www.informix.com/evaluate
    The problem have been solved with the download of the 2.80 SDK wich contain the 3.81 ODBC driver instead of the 3.80.
    Thanks a lot
    Kristof

Posting Permissions

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