Unable to establish connection with data source with Teradata. Missing settings: {[DBCName]} ...
Increase performance creating Mandelbrot set in python
How does practicing restraint and performing actions of merit purify the mind?
What can we do to stop prior company from asking us questions?
Anatomically Correct Mesopelagic Aves
Robert Sheckley short story about vacation spots being overwhelmed
Should I tutor a student who I know has cheated on their homework?
How easy is it to start Magic from scratch?
Failed to fetch jessie backports repository
How to make a software documentation "officially" citable?
Is a stroke of luck acceptable after a series of unfavorable events?
When airplanes disconnect from a tanker during air to air refueling, why do they bank so sharply to the right?
How do I go from 300 unfinished/half written blog posts, to published posts?
Term for the "extreme-extension" version of a straw man fallacy?
What makes a siege story/plot interesting?
Trouble understanding the speech of overseas colleagues
How to safely derail a train during transit?
Anatomically Correct Strange Women In Ponds Distributing Swords
What is the difference between "behavior" and "behaviour"?
How should I support this large drywall patch?
How long to clear the 'suck zone' of a turbofan after start is initiated?
Whats the best way to handle refactoring a big file?
How do we know the LHC results are robust?
Why do remote companies require working in the US?
Text adventure game code
Unable to establish connection with data source with Teradata. Missing settings: {[DBCName]}
The Next CEO of Stack OverflowSQL Server to MySQL sync, using Workbench, FreeTDS, and iODBC on 10.9Export data from a CCURE 800/8000 System using a pair of ODBC data sources?teradata database unable to increase database size in permanent spaceNeed help with SQL query in TeradataUnable to execute the Teradata stored procedure due to syntax errorsSQL Server: ODBC Linked Server to Oracle does not return all rowsTeradata: Select Table With No LockOracle Instant Client 64-bit “Unable to connect, SQLState=” Windows Server 2012SSMA for Access - Migration Assistant Wizard fails at link tablesunixODBC - [IM002][unixODBC][Driver Manager] Data source name not found and no default driver specified
I'am installed Teradata driver on CentOS as described in official README.
After installation drivers is located in /opt/teradata/client
/ODBC_32/
/ODBC_64/
Each folder has subfolders and files
include
lib
locale
odbc.ini
odbcinst.ini
Using ODBC_64 driver, I'am copied contents from odbc.ini and odbcinst.ini into /etc/odbc.ini and /etc/odbcinst.ini files respectively.
Now in /etc/odbc.ini
[ODBC]
InstallDir=/opt/teradata/client/ODBC_64
Trace=no
Pooling=yes
[ODBC Data Sources]
Teradata_ODBC_DSN=Teradata Database ODBC Driver 16.20
[Teradata_ODBC_DSN]
Description=Teradata Database ODBC Driver 16.20
Driver=/opt/teradata/client/ODBC_64/lib/tdataodbc_sb64.so
DBCName=My_Teradata_Server_IP
UID=
PWD=
in odbcinst.ini
[ODBC Drivers]
Teradata Database ODBC Driver 16.20=Installed
[Teradata Database ODBC Driver 16.20]
Description=Teradata Database ODBC Driver 16.20
Driver=/opt/teradata/client/ODBC_64/lib/tdataodbc_sb64.so
CPTimeout=60
But, when I'am tested connection with command isql -v Teradata_ODBC_DSN it show me an error [08001][unixODBC][Teradata][ODBC] (10380) Unable to establish connection with data source. Missing settings: {[DBCName]}
DBCName option is filled as you can see above. Why such error is appear?
odbc teradata unixodbc isql
asked 6 mins ago
EvgeniyEvgeniy
1011
New contributor
Evgeniy is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I'am installed Teradata driver on CentOS as described in official README.
After installation drivers is located in /opt/teradata/client
/ODBC_32/
/ODBC_64/
Each folder has subfolders and files
include
lib
locale
odbc.ini
odbcinst.ini
Using ODBC_64 driver, I'am copied contents from odbc.ini and odbcinst.ini into /etc/odbc.ini and /etc/odbcinst.ini files respectively.
Now in /etc/odbc.ini
[ODBC]
InstallDir=/opt/teradata/client/ODBC_64
Trace=no
Pooling=yes
[ODBC Data Sources]
Teradata_ODBC_DSN=Teradata Database ODBC Driver 16.20
[Teradata_ODBC_DSN]
Description=Teradata Database ODBC Driver 16.20
Driver=/opt/teradata/client/ODBC_64/lib/tdataodbc_sb64.so
DBCName=My_Teradata_Server_IP
UID=
PWD=
in odbcinst.ini
[ODBC Drivers]
Teradata Database ODBC Driver 16.20=Installed
[Teradata Database ODBC Driver 16.20]
Description=Teradata Database ODBC Driver 16.20
Driver=/opt/teradata/client/ODBC_64/lib/tdataodbc_sb64.so
CPTimeout=60
But, when I'am tested connection with command isql -v Teradata_ODBC_DSN it show me an error [08001][unixODBC][Teradata][ODBC] (10380) Unable to establish connection with data source. Missing settings: {[DBCName]}
DBCName option is filled as you can see above. Why such error is appear?
odbc teradata unixodbc isql
asked 6 mins ago
EvgeniyEvgeniy
1011
New contributor
Evgeniy is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I'am installed Teradata driver on CentOS as described in official README.
After installation drivers is located in /opt/teradata/client
/ODBC_32/
/ODBC_64/
Each folder has subfolders and files
include
lib
locale
odbc.ini
odbcinst.ini
Using ODBC_64 driver, I'am copied contents from odbc.ini and odbcinst.ini into /etc/odbc.ini and /etc/odbcinst.ini files respectively.
Now in /etc/odbc.ini
[ODBC]
InstallDir=/opt/teradata/client/ODBC_64
Trace=no
Pooling=yes
[ODBC Data Sources]
Teradata_ODBC_DSN=Teradata Database ODBC Driver 16.20
[Teradata_ODBC_DSN]
Description=Teradata Database ODBC Driver 16.20
Driver=/opt/teradata/client/ODBC_64/lib/tdataodbc_sb64.so
DBCName=My_Teradata_Server_IP
UID=
PWD=
in odbcinst.ini
[ODBC Drivers]
Teradata Database ODBC Driver 16.20=Installed
[Teradata Database ODBC Driver 16.20]
Description=Teradata Database ODBC Driver 16.20
Driver=/opt/teradata/client/ODBC_64/lib/tdataodbc_sb64.so
CPTimeout=60
But, when I'am tested connection with command isql -v Teradata_ODBC_DSN it show me an error [08001][unixODBC][Teradata][ODBC] (10380) Unable to establish connection with data source. Missing settings: {[DBCName]}
DBCName option is filled as you can see above. Why such error is appear?
odbc teradata unixodbc isql
asked 6 mins ago
EvgeniyEvgeniy
1011
New contributor
Evgeniy is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I'am installed Teradata driver on CentOS as described in official README.
After installation drivers is located in /opt/teradata/client
/ODBC_32/
/ODBC_64/
Each folder has subfolders and files
include
lib
locale
odbc.ini
odbcinst.ini
Using ODBC_64 driver, I'am copied contents from odbc.ini and odbcinst.ini into /etc/odbc.ini and /etc/odbcinst.ini files respectively.
Now in /etc/odbc.ini
[ODBC]
InstallDir=/opt/teradata/client/ODBC_64
Trace=no
Pooling=yes
[ODBC Data Sources]
Teradata_ODBC_DSN=Teradata Database ODBC Driver 16.20
[Teradata_ODBC_DSN]
Description=Teradata Database ODBC Driver 16.20
Driver=/opt/teradata/client/ODBC_64/lib/tdataodbc_sb64.so
DBCName=My_Teradata_Server_IP
UID=
PWD=
in odbcinst.ini
[ODBC Drivers]
Teradata Database ODBC Driver 16.20=Installed
[Teradata Database ODBC Driver 16.20]
Description=Teradata Database ODBC Driver 16.20
Driver=/opt/teradata/client/ODBC_64/lib/tdataodbc_sb64.so
CPTimeout=60
But, when I'am tested connection with command isql -v Teradata_ODBC_DSN it show me an error [08001][unixODBC][Teradata][ODBC] (10380) Unable to establish connection with data source. Missing settings: {[DBCName]}
DBCName option is filled as you can see above. Why such error is appear?
odbc teradata unixodbc isql
odbc teradata unixodbc isql
asked 6 mins ago
EvgeniyEvgeniy
1011
New contributor
Evgeniy is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 6 mins ago
EvgeniyEvgeniy
1011
New contributor
Evgeniy is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 6 mins ago
EvgeniyEvgeniy
1011
New contributor
Evgeniy is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 6 mins ago
EvgeniyEvgeniy
1011
asked 6 mins ago
EvgeniyEvgeniy
1011
1011
New contributor
Evgeniy is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Evgeniy is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Evgeniy is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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
});
}
});
Evgeniy is a new contributor. Be nice, and check out our Code of Conduct.
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%2fdba.stackexchange.com%2fquestions%2f233458%2funable-to-establish-connection-with-data-source-with-teradata-missing-settings%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
Evgeniy is a new contributor. Be nice, and check out our Code of Conduct.
Evgeniy is a new contributor. Be nice, and check out our Code of Conduct.
Evgeniy is a new contributor. Be nice, and check out our Code of Conduct.
Evgeniy is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Database Administrators Stack Exchange!
- 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%2fdba.stackexchange.com%2fquestions%2f233458%2funable-to-establish-connection-with-data-source-with-teradata-missing-settings%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
