DB2 ODBC Connection thru Excel VBA

Question

I am trying to connect to DB2 on AIX through excel VBA, my connection string is

conn.ConnectionString = "Driver={IBM DB2 ODBC DRIVER};Database=XXXXXXXX;Hostname=XXX.XXX.XXX.XXX;Port=50000;Protocol=TCPIP;Uid=username;Pwd=password;"

When I try to open "conn.Open" the connection my windows logon credentials are used for authentication and not the one given in connection string.

Can you please help in resolving this.

Thanks In Advance. Gokul

EDIT your question to show the Db2 client configuration and version+fixpack. If you make a DSN and configure it, does it work correctly with odbcad32 for connecting with your AIX-credentials? — mao
– mao, Commented Dec 31, 2018 at 11:43

PiTri · Accepted Answer · 2019-08-15 12:28:38Z

0

Try to add parameter Persist Security Info=False;to ConnectionString.

answered Aug 15, 2019 at 12:28

PiTri

1

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

DB2 ODBC Connection thru Excel VBA

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related