How to add a ODBC (Lotus Notes) linked server in SQL 2005

  • Hello,

    I have no problem creating a ODBC data source, and I am able to connect Notes from Access (2003, 2007), why I don't see the ODBC option in the provider drop down list in SQL 2005? where did it go? or should I install some extra driver?

    Thank you very much.

    ***This is not SSIS question, please don't move it to any other forum, thanks***

  • up

  • up

  • nobody knows?

  • Look for: linked servers [SQL Server], ODBC in BOL (Books Online).

    You use the OLE DB Provider for ODBC when creating a Linked Server that uses ODBC.

  • Hi Lynn,

    Thank you for your reply, but I am desperately in dark here, I've attached some snapshots in the attachment, can you help me with it? all the approaches I tried as well as procedures are presented in the document, please do take a look and write me back if you need the related software.

    I know this would be very useful to many people with this problem, thank you very much in advance to you or any one who can resolve this issue.

  • Please run this in SSMS when connected to the server in question and post the results:

    select @ @VERSION -- no spaces between the @ signs, had to add a space to post the code from work --- don't ask, don't know why.

  • Here is the query result:

    Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 3)

  • I do have another 2k5 version with more recent patch:

    Microsoft SQL Server 2005 - 9.00.4053.00 (Intel X86) May 26 2009 14:24:20 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

    Regarding to the data source when I run import wizard, both servers show same option: I am guessing there is just no such an option in SQL 2005 than in 2000.

  • At this point, not sure where to go. I haven't had to work with Lotus Notes since early 2005. If I get some time, I'll do some more research, but at the moment I really have to do some paid work regarding Database Mirroring with SQL Server 2008.

  • Thank you and please DO do something when you have time later on, I did lots of search, I didn't find any complete working example so far, so this got to be very useful and helpful to other people. Also, I do believe there is some work around to it, like in my attachment, maybe programatically read the data in via .NET?

  • At the previous employer where we had Notes, the Notes programmer wrote code that pushed data into a database on SQL Server, so I never had to setup a transfer from Notes.

    I will try and do some research over the weekend, but not making any promises.

  • thank you

  • I have done this in the past using the NotesSQL driver. The latest version is 8.5 which can be found here:

    http://www14.software.ibm.com/webapp/download/nochargesearch.jsp?cat=&q0=&pf=&k=ALL&pn=&pid=&rs=&S_TACT=104CBW71&status=Active&S_CMP=&b=&sr=1&q=notes+sql&ibm-search=Search

    The ODBC interface require an authenticated Notes client ID - I recommend that you get a dedicated Notes ID file generated for this use.

    In the past when I have been doing this - the Notes client has to be installed on the SQL Server host. A good write up on the whole process can be found here:

    http://www.databasejournal.com/features/mssql/article.php/3462011/Connect-to-Lotus-Domino-using-SQL-Server-Linked-Server.htm

    It may be that later versions of the NotesSQL driver have removed this requirement and will let you talk directly to the server.

    Hope this helps.

    ProPodean - A podean who lost his amateur status

Viewing 14 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply