I am trying to connect DB2 within a local Notes database (action button) using LotusScript and I am getting this error:
“[IBM][CLI Driver] SQL1031N The database directory cannot be found on the indicated file system. SQLSTATE=”
Dim session As New NotesSession
Dim db As NotesDatabase
Set db = session.CurrentDatabase
Dim con As New LCConnection(“db2”)
con.Database = “BTMxxxx”
con.Userid = “dxxxxx”
con.Password = “4Qxxxxxxxx”
con.MapByName = True
con.Connect
If I test the ODBC Driver or “DB2 Connect to BTMxxxx” both connects successfully.
Could anybody help me with this?
Sorry, this sound very basic.
My specs (local):
Windows 10 (64 bit)
IBM Lotus Notes client 9.0.1 FP7 (I don’t have a Domino server and LEI/DECS installed on my local)
IBM DB2 V9.7
- IBM DB2 ODBC DRIVER - DB2COPY1 (tried both 32 and 64 bits driver)
Server
DB2/AIX64 10.1.6