Is Microsoft SQL Server Data Connection supported?

HCL Domino Domino Forum
1

Inside the Shared Resources section of a database design, it is possible to find a new type of object for R6: Data Connections. When I create a new data connection, the only types available are:

  • DB2

  • Oracle

  • Oracle8

  • Sybase

  • ODBC

  • OLE DB

Since the company I work for uses Microsoft SQL Server, I’d like to know if it is possible to configure somehow a native access to this database, inserting a option to this list.

Is it possible or I must use the slow ODBC bridge?

Thanks.

2

Subject: Is Microsoft SQL Server Data Connection supported?

There’s also OLE DB, which gives you a lower-level hook to MSSQL. That is, you should be able to execute stored procedures and so forth.

3

Subject: Is Microsoft SQL Server Data Connection supported?

I was interested in your question, so I assumed that the question relates to one thing–does MS SQL Server support NATIVE drivers right?

I searched the Designer Help on “MS SQL Server”, here is what I found.

Introduction to the Lotus Connector for OLE DB

This chapter provides information about the Lotus Connector for OLE DB. It contains information about creating Microsoft SQL Server Connections. The Lotus Connector for OLE DB can be used with IBM Lotus Enterprise Integrator for Domino (LEI), Domino Enterprise Connection Services (DECS), and Lotus Connector LotusScript Extensions (LSX).

Use the Lotus Connector for OLE DB to connect to a Microsoft SQL server database. Since Microsoft only provides the OLE DB technology on Windows platforms, use the ODBC Connector to connect to SQL server databases when LEI is installed on non-Windows platforms.

The OLE DB connector can be used with SQL Server 7/2000 and Access 2000.

So I guess the answer to your question is – NO.

Regards

Rolf Pfotenhauer