How to connect python with mysql database using pyodbc API?
0
import pyodbc
driver='{MySQL ODBC 8.0 ANSI Driver}'
server='localhost'
database='python'
username='root'
password='PASSSWORD'
cnxn = pyodbc.connect(Driver='{MySQL ODBC 8.0 ANSI Driver}',Server=server,Database=database,Uid=username,Pwd=password)
cursor = cnxn.cursor()
When I run it gives me this error
cnxn = pyodbc.connect(Driver='{MySQL ODBC 8.0 ANSI
Driver}',Server=server,Database=database,Uid=username,Pwd=password)
pyodbc.InterfaceError: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)')
python mysql pyodbc
asked Nov 20 '18 at 23:51
Sid SidhantSid Sidhant
12
add a comment |
0
import pyodbc
driver='{MySQL ODBC 8.0 ANSI Driver}'
server='localhost'
database='python'
username='root'
password='PASSSWORD'
cnxn = pyodbc.connect(Driver='{MySQL ODBC 8.0 ANSI Driver}',Server=server,Database=database,Uid=username,Pwd=password)
cursor = cnxn.cursor()
When I run it gives me this error
cnxn = pyodbc.connect(Driver='{MySQL ODBC 8.0 ANSI
Driver}',Server=server,Database=database,Uid=username,Pwd=password)
pyodbc.InterfaceError: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)')
python mysql pyodbc
asked Nov 20 '18 at 23:51
Sid SidhantSid Sidhant
12
Check the list returned bypyodbc.drivers()to see the names of the ODBC drivers available to your Python app. (BTW, I just tried your code and it worked fine for me.)
– Gord Thompson
Nov 21 '18 at 0:03
Thanks for replying. But when I print pyodbc.drivers() to console it does not show me any driver for MySQL.
– Sid Sidhant
Nov 21 '18 at 0:14
Then you'll need to install a copy of MySQL Connector/ODBC that matches the "bitness" of your Python interpreter (32-bit or 64-bit).
– Gord Thompson
Nov 21 '18 at 0:27
Can you please tell me the steps to download a copy of MySQL Connector/ODBC.
– Sid Sidhant
Nov 21 '18 at 13:28
add a comment |
0
0
0
1
import pyodbc
driver='{MySQL ODBC 8.0 ANSI Driver}'
server='localhost'
database='python'
username='root'
password='PASSSWORD'
cnxn = pyodbc.connect(Driver='{MySQL ODBC 8.0 ANSI Driver}',Server=server,Database=database,Uid=username,Pwd=password)
cursor = cnxn.cursor()
When I run it gives me this error
cnxn = pyodbc.connect(Driver='{MySQL ODBC 8.0 ANSI
Driver}',Server=server,Database=database,Uid=username,Pwd=password)
pyodbc.InterfaceError: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)')
python mysql pyodbc
asked Nov 20 '18 at 23:51
Sid SidhantSid Sidhant
12
import pyodbc
driver='{MySQL ODBC 8.0 ANSI Driver}'
server='localhost'
database='python'
username='root'
password='PASSSWORD'
cnxn = pyodbc.connect(Driver='{MySQL ODBC 8.0 ANSI Driver}',Server=server,Database=database,Uid=username,Pwd=password)
cursor = cnxn.cursor()
When I run it gives me this error
cnxn = pyodbc.connect(Driver='{MySQL ODBC 8.0 ANSI
Driver}',Server=server,Database=database,Uid=username,Pwd=password)
pyodbc.InterfaceError: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)')
python mysql pyodbc
python mysql pyodbc
asked Nov 20 '18 at 23:51
Sid SidhantSid Sidhant
12
asked Nov 20 '18 at 23:51
Sid SidhantSid Sidhant
12
asked Nov 20 '18 at 23:51
Sid SidhantSid Sidhant
12
asked Nov 20 '18 at 23:51
Sid SidhantSid Sidhant
12
asked Nov 20 '18 at 23:51
Sid SidhantSid Sidhant
12
12
Check the list returned bypyodbc.drivers()to see the names of the ODBC drivers available to your Python app. (BTW, I just tried your code and it worked fine for me.)
– Gord Thompson
Nov 21 '18 at 0:03
Thanks for replying. But when I print pyodbc.drivers() to console it does not show me any driver for MySQL.
– Sid Sidhant
Nov 21 '18 at 0:14
Then you'll need to install a copy of MySQL Connector/ODBC that matches the "bitness" of your Python interpreter (32-bit or 64-bit).
– Gord Thompson
Nov 21 '18 at 0:27
Can you please tell me the steps to download a copy of MySQL Connector/ODBC.
– Sid Sidhant
Nov 21 '18 at 13:28
add a comment |
Check the list returned bypyodbc.drivers()to see the names of the ODBC drivers available to your Python app. (BTW, I just tried your code and it worked fine for me.)
– Gord Thompson
Nov 21 '18 at 0:03
Thanks for replying. But when I print pyodbc.drivers() to console it does not show me any driver for MySQL.
– Sid Sidhant
Nov 21 '18 at 0:14
Then you'll need to install a copy of MySQL Connector/ODBC that matches the "bitness" of your Python interpreter (32-bit or 64-bit).
– Gord Thompson
Nov 21 '18 at 0:27
Can you please tell me the steps to download a copy of MySQL Connector/ODBC.
– Sid Sidhant
Nov 21 '18 at 13:28
Check the list returned by
pyodbc.drivers() to see the names of the ODBC drivers available to your Python app. (BTW, I just tried your code and it worked fine for me.)– Gord Thompson
Nov 21 '18 at 0:03
Check the list returned by
pyodbc.drivers() to see the names of the ODBC drivers available to your Python app. (BTW, I just tried your code and it worked fine for me.)– Gord Thompson
Nov 21 '18 at 0:03
Thanks for replying. But when I print pyodbc.drivers() to console it does not show me any driver for MySQL.
– Sid Sidhant
Nov 21 '18 at 0:14
Thanks for replying. But when I print pyodbc.drivers() to console it does not show me any driver for MySQL.
– Sid Sidhant
Nov 21 '18 at 0:14
Then you'll need to install a copy of MySQL Connector/ODBC that matches the "bitness" of your Python interpreter (32-bit or 64-bit).
– Gord Thompson
Nov 21 '18 at 0:27
Then you'll need to install a copy of MySQL Connector/ODBC that matches the "bitness" of your Python interpreter (32-bit or 64-bit).
– Gord Thompson
Nov 21 '18 at 0:27
Can you please tell me the steps to download a copy of MySQL Connector/ODBC.
– Sid Sidhant
Nov 21 '18 at 13:28
Can you please tell me the steps to download a copy of MySQL Connector/ODBC.
– Sid Sidhant
Nov 21 '18 at 13:28
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
});
}
});
draft saved
draft discarded
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%2f53403344%2fhow-to-connect-python-with-mysql-database-using-pyodbc-api%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
draft saved
draft discarded
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.
draft saved
draft discarded
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%2f53403344%2fhow-to-connect-python-with-mysql-database-using-pyodbc-api%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
Check the list returned by
pyodbc.drivers()to see the names of the ODBC drivers available to your Python app. (BTW, I just tried your code and it worked fine for me.)– Gord Thompson
Nov 21 '18 at 0:03
Thanks for replying. But when I print pyodbc.drivers() to console it does not show me any driver for MySQL.
– Sid Sidhant
Nov 21 '18 at 0:14
Then you'll need to install a copy of MySQL Connector/ODBC that matches the "bitness" of your Python interpreter (32-bit or 64-bit).
– Gord Thompson
Nov 21 '18 at 0:27
Can you please tell me the steps to download a copy of MySQL Connector/ODBC.
– Sid Sidhant
Nov 21 '18 at 13:28