Python 2.7 program no longer working after a Teradata upgrade2019 Community Moderator ElectionWhich version of the Microsoft Access ODBC Driver should I install?Connect Python to Teradata in mac with pyodbcTeradata connection working for one site but not for the otherTrouble Installing tdodbc in UbuntuHow do I connect to a Teradata via ODBC in code?PHP 64 bit - Teradata ODBC driver failure - system error 126 'specified module cannot be found' -Connecting to MSSQL in Flask using Flask-SQLAlchemy and pyodbccan I run a custom function using teradata python module?How to connect to Teradata Database using R + DBI +ODBC with osx (and windows VM)Python teradata Uda Exec ODBC connection issue
How could a female member of a species produce eggs unto death?
How to answer questions about my characters?
Employee lack of ownership
What is the greatest age difference between a married couple in Tanach?
How do anti-virus programs start at Windows boot?
Connecting top and bottom SMD component pads using via
Current sense amp + op-amp buffer + ADC: Measuring down to 0 with single supply
How to deal with a cynical class?
Why must traveling waves have the same amplitude to form a standing wave?
Is it normal that my co-workers at a fitness company criticize my food choices?
Is it possible that AIC = BIC?
Why is "das Weib" grammatically neuter?
Why would a flight no longer considered airworthy be redirected like this?
How to make healing in an exploration game interesting
How to write cleanly even if my character uses expletive language?
Why did it take so long to abandon sail after steamships were demonstrated?
Can elves maintain concentration in a trance?
Why are the outputs of printf and std::cout different
Official degrees of earth’s rotation per day
Replacing Windows 7 security updates with anti-virus?
Is having access to past exams cheating and, if yes, could it be proven just by a good grade?
Co-worker team leader wants to inject his friend's awful software into our development. What should I say to our common boss?
Why doesn't the EU now just force the UK to choose between referendum and no-deal?
PTIJ: Who should pay for Uber rides: the child or the parent?
Python 2.7 program no longer working after a Teradata upgrade
2019 Community Moderator ElectionWhich version of the Microsoft Access ODBC Driver should I install?Connect Python to Teradata in mac with pyodbcTeradata connection working for one site but not for the otherTrouble Installing tdodbc in UbuntuHow do I connect to a Teradata via ODBC in code?PHP 64 bit - Teradata ODBC driver failure - system error 126 'specified module cannot be found' -Connecting to MSSQL in Flask using Flask-SQLAlchemy and pyodbccan I run a custom function using teradata python module?How to connect to Teradata Database using R + DBI +ODBC with osx (and windows VM)Python teradata Uda Exec ODBC connection issue
I have a Python 2.7 program which uses the teradata module.
Before the program worked perfectly. After upgrading the Teradata software on my machine (not the python module) from version 15.00 to 16.20 python program stopped working.
I get the following error message:
raise DatabaseError(i[2], u"[] ".format(i[0], msg), i[0])
teradata.api.DatabaseError: (0, u'[IM002] [Microsoft][ODBC Driver
Manager] Data source name not found and no default driver specified')
It makes sense that the driver version is no longer supported since the version is updated. The question is how can I fix this?
What have I tried so far?
In the folder where I have the Python program I have a copy of the teradata module. I replaced the existing one with a more recent version. This was not succesful.
I have also looked in the teradata module to see if I manually could update the ODBC driver. I didn't find any good place to modify the code.
My code:
def setup_teradata_session(username_,password_, environment_):
system_ = get_system_nm(environment_)
udaExec = teradata.UdaExec (appName="Something", version="1.0", logConsole=False)
return udaExec.connect(method="odbc", system=system_,username = username_, password = password_, authentication="LDAP")
python windows python-2.7 teradata
asked Mar 7 at 12:26
Filip ErikssonFilip Eriksson
43931836
add a comment |
I have a Python 2.7 program which uses the teradata module.
Before the program worked perfectly. After upgrading the Teradata software on my machine (not the python module) from version 15.00 to 16.20 python program stopped working.
I get the following error message:
raise DatabaseError(i[2], u"[] ".format(i[0], msg), i[0])
teradata.api.DatabaseError: (0, u'[IM002] [Microsoft][ODBC Driver
Manager] Data source name not found and no default driver specified')
It makes sense that the driver version is no longer supported since the version is updated. The question is how can I fix this?
What have I tried so far?
In the folder where I have the Python program I have a copy of the teradata module. I replaced the existing one with a more recent version. This was not succesful.
I have also looked in the teradata module to see if I manually could update the ODBC driver. I didn't find any good place to modify the code.
My code:
def setup_teradata_session(username_,password_, environment_):
system_ = get_system_nm(environment_)
udaExec = teradata.UdaExec (appName="Something", version="1.0", logConsole=False)
return udaExec.connect(method="odbc", system=system_,username = username_, password = password_, authentication="LDAP")
python windows python-2.7 teradata
asked Mar 7 at 12:26
Filip ErikssonFilip Eriksson
43931836
add a comment |
I have a Python 2.7 program which uses the teradata module.
Before the program worked perfectly. After upgrading the Teradata software on my machine (not the python module) from version 15.00 to 16.20 python program stopped working.
I get the following error message:
raise DatabaseError(i[2], u"[] ".format(i[0], msg), i[0])
teradata.api.DatabaseError: (0, u'[IM002] [Microsoft][ODBC Driver
Manager] Data source name not found and no default driver specified')
It makes sense that the driver version is no longer supported since the version is updated. The question is how can I fix this?
What have I tried so far?
In the folder where I have the Python program I have a copy of the teradata module. I replaced the existing one with a more recent version. This was not succesful.
I have also looked in the teradata module to see if I manually could update the ODBC driver. I didn't find any good place to modify the code.
My code:
def setup_teradata_session(username_,password_, environment_):
system_ = get_system_nm(environment_)
udaExec = teradata.UdaExec (appName="Something", version="1.0", logConsole=False)
return udaExec.connect(method="odbc", system=system_,username = username_, password = password_, authentication="LDAP")
python windows python-2.7 teradata
asked Mar 7 at 12:26
Filip ErikssonFilip Eriksson
43931836
I have a Python 2.7 program which uses the teradata module.
Before the program worked perfectly. After upgrading the Teradata software on my machine (not the python module) from version 15.00 to 16.20 python program stopped working.
I get the following error message:
raise DatabaseError(i[2], u"[] ".format(i[0], msg), i[0])
teradata.api.DatabaseError: (0, u'[IM002] [Microsoft][ODBC Driver
Manager] Data source name not found and no default driver specified')
It makes sense that the driver version is no longer supported since the version is updated. The question is how can I fix this?
What have I tried so far?
In the folder where I have the Python program I have a copy of the teradata module. I replaced the existing one with a more recent version. This was not succesful.
I have also looked in the teradata module to see if I manually could update the ODBC driver. I didn't find any good place to modify the code.
My code:
def setup_teradata_session(username_,password_, environment_):
system_ = get_system_nm(environment_)
udaExec = teradata.UdaExec (appName="Something", version="1.0", logConsole=False)
return udaExec.connect(method="odbc", system=system_,username = username_, password = password_, authentication="LDAP")
python windows python-2.7 teradata
python windows python-2.7 teradata
asked Mar 7 at 12:26
Filip ErikssonFilip Eriksson
43931836
asked Mar 7 at 12:26
Filip ErikssonFilip Eriksson
43931836
edited Mar 7 at 13:49
Filip Eriksson
asked Mar 7 at 12:26
Filip ErikssonFilip Eriksson
43931836
asked Mar 7 at 12:26
Filip ErikssonFilip Eriksson
43931836
asked Mar 7 at 12:26
Filip ErikssonFilip Eriksson
43931836
43931836
add a comment |
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%2f55043786%2fpython-2-7-program-no-longer-working-after-a-teradata-upgrade%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%2f55043786%2fpython-2-7-program-no-longer-working-after-a-teradata-upgrade%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
