Does the release 9 client/ODBC driver work with Connection strings?
I installed the IBM Notes 9.0.1 Social Edition. ODBC driver stopped working. Installed the driver version 9, 32 bit. It worked for launching queries manually from querying tools. It allowed me to setup DSN.
But when trying to use it programmatically, it fails. Not sure what I am doing wrong.
Dim Xcnn As New ADODB.Connection
Xcnn.Open “DRIVER=Lotus NotesSQL Driver (*.nsf);Database=;Server=Local;UserName=;;ThreadTimeout=60;”
It also doesn’t allow me to complete .oce configuration in Brio, but I can live with that - manual queries I can do from other tools.
Subject: Any news?
Any news? A colleague of mine confirmed the same issue.
Subject: Solution - IBM Notes 9 and Connection strings
OK, found a solution.
Connection string which used to work before, like this, doesn’t work in IBM Notes 9 driver anymore, it throws an error:
DRIVER=Lotus NotesSQL Driver (*.nsf);Database=C:\notes\data\c_dir\cssilo03.nsf;Server=local;UserName=;MaxVarcharLen=10240;KeepTempIdx=1;MaxLongVarcharLen=10240;ShowImplicitFlds=1;MapSpecialChars=1;ThreadTimeout=60;
But if I created an ODBC connection, and used a Connection string in a “normal” ODBC connection string format, it worked:
ODBC;UID=;PWD=;DSN=
I even went with blank UID and PWD, because the automation didn’t require login - it used my existing LN credentials automatically. But the parameters UID and PWD should be there, even if blank. So the format is
DSN=;UID=;PWD=;
So the conclusion is that the driver does work with connection strings, but it requires the same format of connection strings as a normal relational database.
Subject: ODBC driver still not working properly?
Anybody?