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 AdamsIT TeamAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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$).

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Lotus IBM

From novice to tech pro — start learning today.