Error when running Lotus Domino agent

0
votes

I wrote an Lotus Domino agent to transfer Domlog.nsf data to DB2 database. When I run agent I get:

Error: Cannot find Connector 'DB2COPY2'

DB2COPY2 is name of my DB2 client or instance, don't know how you call it. And next error is (probably due to first error) 

NO RESUME

In the LotusScript I got line Dim conn As New LCConnection("DB2COPY2")

Any ideas on first error? Thank you.

1
lotus-notes
Is the DB2- connector installed on the server and can the "service"- User access the connection information? When working with ODBC you have to configure the ODBC as System- DSN, not User- DSN, I don't know if there is something similar with DB2... – Torsten Link
I don't think I have it installed, unless it comes by default. Where do I get it? – estranged
You need to download and install the DB2 CLI drivers and then configure the connection on the machine/server that the code is going to run on. The name of the connection you configure will be the name you set on the LCConnection properties. But, your call to create the LCConnection object would be: Dim conn as New LCConnection("db2") – David Morton

1 Answers

0
votes

You want to access a data source without installing a driver for it. Its like wanting to drive a car without a key... This does not work. To access odbc data sources, you need tominstall an odbc driver (from the vendor of your database system). To accesss db2 databases, you need a db2- client installed on the server (delivered by ibm if you have the relevant licenses).

In addition you could install decs (for free) or lei (quite cost intensive) to make it easier to configure the access to the data sources, but it will not make the drivers obsolete...