Cannot get NotesSQL driver to work

Discussion in 'Lotus Notes Programming' started by Parney, Jan 28, 2004.

  1. Parney

    Parney Guest

    Scenario:
    Access 97 on Win XP Pro (SP1), NotesSQL 3.02e, Notes Client 4.6.7a.
    I am trying to connect to a networked Domino server to pull some data
    in to Access 97 with the following VBA code:

    Dim con As ADODB.Connection
    Set con = New ADODB.Connection
    con.Open "Driver=Lotus NotesSQL Driver
    (*.nsf);Database=TEST.NSF;Server=Domino1;UID=username;PWD=password;"

    When logged on as local administrator (workstation only) everything
    works fine. I can also connect to local Notes databases without any
    problems. When I log on to the windows domain as a user with local
    administrator rights I receive the following error message:

    -2147217843 [Lotus][ODBC Lotus Notes]Driver not capable.

    I also get the same message if I use a DSN.

    Has anybody got any ideas?

    Regards,

    Parney
     
    Parney, Jan 28, 2004
    #1
    1. Advertisements

  2. Parney

    Michael Vogt Guest

    My guess is, it is the wrong driver-version. I tried it out so and the other
    way round. Connecting via ODBC with notesSQL 1.x and Notes 5.x doesn't work.
    Connection with notesSQL 2.x and notes 4.6x, doesn't work either.
    Connection notesSQL 1.x and Notes 4.6x works fine.
    Connection notesSQL 2.x and Notes 5.x works fine either.

    So try to downgrade to a previous notesSQL-version

    with regards
     
    Michael Vogt, Jan 28, 2004
    #2
    1. Advertisements

  3. Parney

    Parney Guest

    Hi Michael,
    thanks for the response. I have also tried NotesSQL 2.06 with the same
    results. Both driver work perfectly when I am logged in to the
    workstation as local admin. I suspect this may be a rights issue with
    XP but I am totally stumped as my domain user has local admin rights
    to this PC.

    Regards,

    Parney
     
    Parney, Jan 29, 2004
    #3
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.