Creating SQL data via ODBC

HCL Domino Domino Forum
1

I am looking for information on ODBC connections. When we create a record in Lotus, we need it to also create a record in a SQL Server table. We have been able to connect to the table and pull fields from SQL Server and create a record but only if the form contains fields generated by the ODBC connection. However, when we create a form using fields from the lotus side and SQL Server side it will not update the SQL Server side. We are using DCRs.

Another issue we have is forcing Lotus to use the ODBC connection on the server rather than the client machines. From what I understand you should be able to do this with agent.runonserver? However, haven’t been able to get that working correctly as well.

Is there documentation that explains the ODBC connects other then the help files. It appears that all the information about ODBC is scattered or non existent.

Any help is appreciated…

2

Subject: Check DECS

You might want to take a look at DECS which ships with Notes. The Installation and Help db is help\decsdoc6.nsf (assuming you installed the file on the client or server). Take a look at Chapter 1 Introduction - Introduction to DECS. DECS will support an ODBC connection on the Domino server; you don’t have to set up ODBC on the workstations.