Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2005
    Posts
    4

    Unanswered: DB2, Access, links, ODBC, no DSN, any thoughts?

    Hello,

    I am more of an Access/VB/SQL Server user, so please let me know if I need to provide anymore info:

    I am attempting to link a DB2 table into an Access database. I can do it using a DSN, but I cannot get it to work without. There may be 1000 users across the country using the Access database, so I really don't want to go through the trouble of establishing a DSN on so many desktops.

    When I attempt to run this code:

    Set tbl1 = CurrentDb.CreateTableDef("UDBLA003_SOR_LOGIN")
    tbl1.SourceTableName = "UDBLA003.SOR_LOGIN"
    tbl1.Connect = "ODBC;driver={IBM DB2 ODBC
    DRIVER};Database=SOR;hostname=axsc2lpar06;port=500 03;
    Protocol=TCPIP;uid=******;pwd=******"
    CurrentDb.TableDefs.Append tbl1

    I get Reserved Error (-7778); There is no message for this error.

    Does this mean I am actually connecting? Is there something else I should add? Am I way off?

    Thanks in advance!

    Pinback

  2. #2
    Join Date
    Jan 2005
    Posts
    4
    I should also mention I am using Access97.

    Thanks!

  3. #3
    Join Date
    Jan 2005
    Posts
    4
    Maybe there is a good place I can go to find this info? Any ideas?

  4. #4
    Join Date
    Nov 2004
    Posts
    1,427
    Provided Answers: 4
    Have you tried to upgrade Access 97 to the highest patch level?
    I had this problem too a number of years ago. I remeber that applying a number of patches solved the problem.

    Kind regards
    Wim

  5. #5
    Join Date
    Jan 2005
    Posts
    4
    Thanks Wim,

    Unfortunately, I think I am running the most recent version (SR-2).

    Thanks again,

    Pinback

Posting Permissions

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