DB2 ODBC Connection thru Excel VBA
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
excel db2 odbc db2-luw
edited Dec 31 '18 at 11:28
mao
3,9251316
asked Dec 31 '18 at 11:26
Gokul AGokul A
233
add a comment |
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
excel db2 odbc db2-luw
edited Dec 31 '18 at 11:28
mao
3,9251316
asked Dec 31 '18 at 11:26
Gokul AGokul A
233
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
Dec 31 '18 at 11:43
add a comment |
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
excel db2 odbc db2-luw
edited Dec 31 '18 at 11:28
mao
3,9251316
asked Dec 31 '18 at 11:26
Gokul AGokul A
233
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
excel db2 odbc db2-luw
excel db2 odbc db2-luw
edited Dec 31 '18 at 11:28
mao
3,9251316
asked Dec 31 '18 at 11:26
Gokul AGokul A
233
edited Dec 31 '18 at 11:28
mao
3,9251316
asked Dec 31 '18 at 11:26
Gokul AGokul A
233
edited Dec 31 '18 at 11:28
mao
3,9251316
edited Dec 31 '18 at 11:28
mao
3,9251316
edited Dec 31 '18 at 11:28
mao
3,9251316
3,9251316
asked Dec 31 '18 at 11:26
Gokul AGokul A
233
asked Dec 31 '18 at 11:26
Gokul AGokul A
233
asked Dec 31 '18 at 11:26
Gokul AGokul A
233
233
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
Dec 31 '18 at 11:43
add a comment |
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
Dec 31 '18 at 11:43
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
Dec 31 '18 at 11:43
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
Dec 31 '18 at 11:43
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53986899%2fdb2-odbc-connection-thru-excel-vba%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53986899%2fdb2-odbc-connection-thru-excel-vba%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
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
Dec 31 '18 at 11:43