• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 756
  • Last Modified:

SQL Server linked server to Lotus notes

Dear Experts,

I need expert advice regarding Linked server from SQL Server to Lotus Domino Server.

I have installed NotesSQL, Created ODBC DSN, from the excel I could connect the Domino database and retrieve the data.  Meaning the NotesSQL setup & ODBC connectivity is just working fine.

Then I created a Linked server from SQL Server 2005, Selected "Microsoft OLE DB provider for ODBC driver"
I could successfully create the linked server but when I run the openquery it is giving the below error message.

OLE DB provider "MSDASQL" for linked server "LOTUS" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_DBC failed". Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "LOTUS".

I googled, nothing useful.  

Please advice,

Wade Adams
Wade Adams
  • 2
1 Solution
Sjef BosmanGroupware ConsultantCommented:
Is there anything that's blocking you from using DECS, as I suggested in your previous question?

If you want your users to interact real-time with an SQL server but you don't want to install ODBC on every PC, the only way is to configure and use DECS. If real-time is not an issue, you can also install and use LEI, which creates and maintains a replica (subset) of the data on the SQL server.
Wade AdamsIT TeamAuthor Commented:
The DECS is yet to try.  But I have got a another assignment to push the SQL Server Data into lotus domino.
I could create ODBC and access through excel or other query tools.  But I could not create the link server.

Please suggest.
Sjef BosmanGroupware ConsultantCommented:
That sounds more like a LEI job. Hm, strange, the product seems no longer visible on the IBM websites... ANyway, here's a copy of the most recent description of LEI (sorry for the load of text), so you can see if that's what you're looking for:

Extend IBM Domino applications by integrating data from external sources

IBM® Enterprise Integrator for Domino® supports the exchange of data between IBM Domino and third-party data sources. This software provides data transfer and synchronization capabilities and enables business applications to access and use external data sources, such as IBM DB2®, Oracle and SAP. It helps to extend the reach of business applications and create more efficient workflows by working with data from diverse platforms and databases.

IBM Enterprise Integrator for Domino (formerly IBM Lotus Enterprise Integrator for Domino) features include:

    Access to a wide variety of external data sources and operating platforms for high-volume data transfer and synchronization and near-instant data access from IBM Domino.
    Comprehensive data handling capabilities for flexible application integration that can improve your business processes.
    A uniform set of tools for configuring data exchanges between IBM Domino applications and external data sources.
    Easier administration to help create and maintain processes for consistent, accurate data integration.
    Transparent, security-rich access to external data and processes to support an intuitive user experience and efficient workflow.

Access to a wide variety of external data sources and operating platforms

    Use preconfigured IBM Connector software to move, extract and synchronize data for multiple external data sources, and get access instantly using IBM Domino servers.
    Access data from commonly used relational database systems, including DB2 Universal Database, Oracle, SAP, Microsoft SQL Server, Sybase and Open Database Connectivity.
    Integrate IBM Domino with database data that is stored as text or in non-relational file systems.
    Work with Microsoft Windows 2003 Server and Server Enterprise Edition (32-bit and 64-bit); IBM AIX® 5.3; IBM i5/OS® V5R4; Sun Solaris 10; Red Hat Enterprise Linux 5.0 (32-bit and 64-bit); and Novell SUSE Linux Enterprise Server 10 (32-bit and 64-bit) platforms.

Transparent, security-rich access to external data and processes

    Eliminate the need to duplicate enterprise data in IBM Domino by using virtual documents and attachments that can be used directly from IBM Domino servers and synchronized with external data sources.
    Use fields in an IBM Domino document even when the contents of the field are stored in a third-party system, using a “key” document for background synchronization.
    Invoke procedures and business logic defined in external systems directly from IBM Domino as if these instructions were native LotusScript agents.
    Manage security-rich access to enterprise data sources and virtual data using sign-on credentials and access controls that you specify.

There's just a small drawback: it costs a lot, if I remember correctly it's 10K$ ... (or it could even be 20K$).
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now