ODBC Oracle Client 10.2 x64 TNS error
I have both Oracle 11.2 x86 and 10.2 x64 installed, for reasons I need to use both x86 and x64 connection.
11.2 x86 works well, but 10.2 x64 has below errors when I try to set up ODBC on Windows 10.
It is not a encoding issue with TNSNAMES.ORA, as I have tried different encoding, and even if I completely remove TNSNAMES.ORA, it still has the same error.
If I ignore it and connect anyway, it will fail with error saying cannot resolve TNS, etc.
windows-10 odbc oracle-10g
edited Jan 25 at 9:42
n8te
4,97372233
asked Jan 25 at 9:33
AAaaronAAAAaaronAA
1
add a comment |
I have both Oracle 11.2 x86 and 10.2 x64 installed, for reasons I need to use both x86 and x64 connection.
11.2 x86 works well, but 10.2 x64 has below errors when I try to set up ODBC on Windows 10.
It is not a encoding issue with TNSNAMES.ORA, as I have tried different encoding, and even if I completely remove TNSNAMES.ORA, it still has the same error.
If I ignore it and connect anyway, it will fail with error saying cannot resolve TNS, etc.
windows-10 odbc oracle-10g
edited Jan 25 at 9:42
n8te
4,97372233
asked Jan 25 at 9:33
AAaaronAAAAaaronAA
1
Try creating an environmental variable namedTNS_ADMINand set the value toC:oracleproduct10.2.0instantclient_10_2networkadmin
– n8te
Jan 25 at 9:42
add a comment |
I have both Oracle 11.2 x86 and 10.2 x64 installed, for reasons I need to use both x86 and x64 connection.
11.2 x86 works well, but 10.2 x64 has below errors when I try to set up ODBC on Windows 10.
It is not a encoding issue with TNSNAMES.ORA, as I have tried different encoding, and even if I completely remove TNSNAMES.ORA, it still has the same error.
If I ignore it and connect anyway, it will fail with error saying cannot resolve TNS, etc.
windows-10 odbc oracle-10g
edited Jan 25 at 9:42
n8te
4,97372233
asked Jan 25 at 9:33
AAaaronAAAAaaronAA
1
I have both Oracle 11.2 x86 and 10.2 x64 installed, for reasons I need to use both x86 and x64 connection.
11.2 x86 works well, but 10.2 x64 has below errors when I try to set up ODBC on Windows 10.
It is not a encoding issue with TNSNAMES.ORA, as I have tried different encoding, and even if I completely remove TNSNAMES.ORA, it still has the same error.
If I ignore it and connect anyway, it will fail with error saying cannot resolve TNS, etc.
windows-10 odbc oracle-10g
windows-10 odbc oracle-10g
edited Jan 25 at 9:42
n8te
4,97372233
asked Jan 25 at 9:33
AAaaronAAAAaaronAA
1
edited Jan 25 at 9:42
n8te
4,97372233
asked Jan 25 at 9:33
AAaaronAAAAaaronAA
1
edited Jan 25 at 9:42
n8te
4,97372233
edited Jan 25 at 9:42
n8te
4,97372233
edited Jan 25 at 9:42
n8te
4,97372233
4,97372233
asked Jan 25 at 9:33
AAaaronAAAAaaronAA
1
asked Jan 25 at 9:33
AAaaronAAAAaaronAA
1
asked Jan 25 at 9:33
AAaaronAAAAaaronAA
1
1
Try creating an environmental variable namedTNS_ADMINand set the value toC:oracleproduct10.2.0instantclient_10_2networkadmin
– n8te
Jan 25 at 9:42
add a comment |
Try creating an environmental variable namedTNS_ADMINand set the value toC:oracleproduct10.2.0instantclient_10_2networkadmin
– n8te
Jan 25 at 9:42
Try creating an environmental variable named
TNS_ADMIN and set the value to C:oracleproduct10.2.0instantclient_10_2networkadmin– n8te
Jan 25 at 9:42
Try creating an environmental variable named
TNS_ADMIN and set the value to C:oracleproduct10.2.0instantclient_10_2networkadmin– n8te
Jan 25 at 9:42
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
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%2fsuperuser.com%2fquestions%2f1398272%2fodbc-oracle-client-10-2-x64-tns-error%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 Super User!
- 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%2fsuperuser.com%2fquestions%2f1398272%2fodbc-oracle-client-10-2-x64-tns-error%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
Try creating an environmental variable named
TNS_ADMINand set the value toC:oracleproduct10.2.0instantclient_10_2networkadmin– n8te
Jan 25 at 9:42