Results 1 to 10 of 10
  1. #1
    Join Date
    Mar 2004
    Location
    Boston
    Posts
    13

    Arrow Unanswered: DTS to Lotus notes

    DTS to Lotus notes

    I must import/export some data from SQL Server to Lotus Notes.
    I downloaded and installed NotesSQL ODBC drivers.
    I met no problem importing from a Lotus Notes view to an SQL Server table: I used DTS and everything succeded.
    But I can't do the reverse process (exporting from SQL Server to Lotus Notes): DTS keeps on giving an error without description and it fails.
    Does anybody know how to export a table or a view from SQL Server to Lotus Notes using DTS?

    Thanks in advance.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Are you trying to setup a daily process, or is it a 1 time thing?

    Do you have Notespump or Notestrix?

    And as much as they protest, Lotus Notes is NOT a database...

    Sorry...I got carried away....

    And what do you mean...are you trying 2 way replication?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Mar 2004
    Location
    Boston
    Posts
    13
    Originally posted by Brett Kaiser
    Are you trying to setup a daily process, or is it a 1 time thing?

    Do you have Notespump or Notestrix?

    And as much as they protest, Lotus Notes is NOT a database...

    Sorry...I got carried away....

    And what do you mean...are you trying 2 way replication?
    Thanks for the reply. This would be a weekly process that I would like to setup and schedule via DTS. I would agree that notes is not a database by definition. I would just like to automate this if possible. It is a very small dataset based on an SQL query. Do I have a bad version of NotesSQL that only works one way?! I don't have Notespump or Notestrix. Wouldn't those apps be a bit overkill? Thanks! - JB

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    I haven't done this...but I'm going to try it....got a link for the driver?

    Also, how do you authenticate?

    Maybe it's a permissions issue...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Mar 2004
    Location
    Boston
    Posts
    13
    Originally posted by Brett Kaiser
    I haven't done this...but I'm going to try it....got a link for the driver?

    Also, how do you authenticate?

    Maybe it's a permissions issue...

    The site is: www.lotus.com/notessql

    The owner of the DB has given me read/write
    permission on the DB. Each time DTS attempts
    to read or write to the .nsf, I am prompted for
    my lotus notes password and it is accepted.

  6. #6
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Still looking

    Found this

    http://www.lotus.com/products/rnext....5?OpenDocument

    Does it have to be installed on the server, or can it be installed on the client?

    I guess where ever DTS is running, no?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  7. #7
    Join Date
    Mar 2004
    Location
    Boston
    Posts
    13
    Originally posted by Brett Kaiser
    Still looking

    Found this

    http://www.lotus.com/products/rnext....5?OpenDocument

    Does it have to be installed on the server, or can it be installed on the client?

    I guess where ever DTS is running, no?
    Yes. I think you would want to install it on the server. You will then be permitted to setup an odbc connection there to an nsf file.

  8. #8
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    You can install on the client...just did it...

    Bam shows up in my source selection list...

    Now I gotta find a notes server to link to....

    Did you see the user manual after the install?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  9. #9
    Join Date
    Mar 2004
    Location
    Boston
    Posts
    13
    I've reviewed the "help" html doc a bit. It seems to talk more about extracting data to another DB.

  10. #10
    Join Date
    Oct 2004
    Posts
    2
    Quote Originally Posted by jimmy_bacadoodi
    The site is: www.lotus.com/notessql

    ....Each time DTS attempts to read or write to the .nsf, I am prompted for
    my lotus notes password and it is accepted.
    Don't want this to happen every time? Go into your registry under HKLM->Software->ODBC->ODBC.INI, then find the entry for your connection. Add a new string called SuppressUID and set it to 1. You won't get prompted anymore. You do have to do this for all of your Notes connections though.

Posting Permissions

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