CODEWITHSUNDEEP
odbcdb2lotus-noteslotus-dominolotusscript
user1500961
user1500961

Reputation: 3

Lotus Notes Domino ODBC Connections on Windows Server

I am a Domino/Notes programmer just started to write LS scripts to other external DataBases.

Question 1. I've got one ODBC connection on the Domino server to a DB2 AS400 server. 2. I require access to 4 DB2 databases. 3. Is it enough with one ODBC connection for 4 databases?

The server admin say there is no need for more ODBC connections.

My ODBC experience have tought me I require one unique connection for each database I need to access.

Am I right?

Thanks in advance

Hal, Norway

Upvotes: 0

Views: 759

Answers (1)

Ken Pespisa
Ken Pespisa

Reputation: 22266

One ODBC connection to the DB2 server will be enough. You might specify a default database but you can operate on many databases via that one server connection.

The reverse isnt true, and I am guessing that is where the confusion lies. When you create an ODBC connection to a Lotus Notes database,you have to create a new ODBC connection for each Lotus Notes database you are accessing.

Upvotes: 1

Related Questions