ODBC and LC connection

HCL Domino Domino Forum
1

Hi all,

I would like to know the differences in using LC connection class and ODBC connection class to connect to external database.

it would be helpful if the explanation is with examples…

Thanks in advance!!

2

Subject: ODBC and LC connection

There is no reason to use ODBCConnection. You should use only the Lotus Connectors support in LCLSX.

LCLSX example for ole db & MS Access here → .

To work with SQL Server you would modify that example as follows:

Set lc_connection = New LCConnection(“oledb”)

With lc_connection

.provider = "sqloledb" 

.Init_DataSource = "some_server"

.catalog = "some_database" ' optional, specify it here or in your sql query

.metadata = "some_data" ' optional

.init_mode = 3 ' Access privileges, 3 = read/write i don't think this applies with ole db, who knows

End With