Python 2.7 module that supports database connection with multisubnetfailover
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
Our database team recently implemented a listener that has multiple IP addresses. Before this implementation, our connection string to connect to the SQL server used to work flawlessly with pyodbc...
import pyodbc
pyodbc.connect("driver=sql-blah-blah;server=server;database=blah;uid=left empty;pwd=left empty;Trusted Connection=yes", autocommit=True)
Now, we're finding that our connections to the listener are hit and miss. Sometimes we will establish a connection successfully and sometimes the connection fails with a timeout.
I'm curious if there is a Python 2.7 module that will support multisubnetfailover where I can specify a connection string like the following...
"hoped for module".connect("driver=sql-blah-blah;server=server;database=blah;uid=left empty;pwd=left empty;Trusted Connection=yes", autocommit=True)
And it will handle the complexity of the listener by choosing an ip address and making the connection? Or the connection simply handles the multisubnetfailover? Or any other possible solution to our problem?
I've tried the ;MultiSubnetFailover approach in the connection string itself. Still does not connect.
pyodbc.connect("driver=sql-blah-blah;server=server;database=blah;uid=left empty;pwd=left empty;Trusted Connection=yes;MultiSubnetFailover=True", autocommit=True,)
Connection timeout. More specifically...
pyodbc.OperationalError: ('HYT00', '[HYT00] [Microsoft][ODBC SQL Server Driver]Login timeout expired (0) (SQLDriverConnect); [01S00] [Microsoft][ODBC SQL Server Driver]Invalid connection string attribute (0)')
Even without the "MultiSubnetFailover=True" attribute in the connection string, I still get the following error...
pyodbc.OperationalError: ('HYT00', '[HYT00] [Microsoft][ODBC SQL Server Driver]Login timeout expired (0) (SQLDriverConnect); [01S00] [Microsoft][ODBC SQL Server Driver]Invalid connection string attribute (0)')
python sql pyodbc
asked Jan 3 at 22:31
Austin DuranAustin Duran
34
add a comment |
Our database team recently implemented a listener that has multiple IP addresses. Before this implementation, our connection string to connect to the SQL server used to work flawlessly with pyodbc...
import pyodbc
pyodbc.connect("driver=sql-blah-blah;server=server;database=blah;uid=left empty;pwd=left empty;Trusted Connection=yes", autocommit=True)
Now, we're finding that our connections to the listener are hit and miss. Sometimes we will establish a connection successfully and sometimes the connection fails with a timeout.
I'm curious if there is a Python 2.7 module that will support multisubnetfailover where I can specify a connection string like the following...
"hoped for module".connect("driver=sql-blah-blah;server=server;database=blah;uid=left empty;pwd=left empty;Trusted Connection=yes", autocommit=True)
And it will handle the complexity of the listener by choosing an ip address and making the connection? Or the connection simply handles the multisubnetfailover? Or any other possible solution to our problem?
I've tried the ;MultiSubnetFailover approach in the connection string itself. Still does not connect.
pyodbc.connect("driver=sql-blah-blah;server=server;database=blah;uid=left empty;pwd=left empty;Trusted Connection=yes;MultiSubnetFailover=True", autocommit=True,)
Connection timeout. More specifically...
pyodbc.OperationalError: ('HYT00', '[HYT00] [Microsoft][ODBC SQL Server Driver]Login timeout expired (0) (SQLDriverConnect); [01S00] [Microsoft][ODBC SQL Server Driver]Invalid connection string attribute (0)')
Even without the "MultiSubnetFailover=True" attribute in the connection string, I still get the following error...
pyodbc.OperationalError: ('HYT00', '[HYT00] [Microsoft][ODBC SQL Server Driver]Login timeout expired (0) (SQLDriverConnect); [01S00] [Microsoft][ODBC SQL Server Driver]Invalid connection string attribute (0)')
python sql pyodbc
asked Jan 3 at 22:31
Austin DuranAustin Duran
34
add a comment |
Our database team recently implemented a listener that has multiple IP addresses. Before this implementation, our connection string to connect to the SQL server used to work flawlessly with pyodbc...
import pyodbc
pyodbc.connect("driver=sql-blah-blah;server=server;database=blah;uid=left empty;pwd=left empty;Trusted Connection=yes", autocommit=True)
Now, we're finding that our connections to the listener are hit and miss. Sometimes we will establish a connection successfully and sometimes the connection fails with a timeout.
I'm curious if there is a Python 2.7 module that will support multisubnetfailover where I can specify a connection string like the following...
"hoped for module".connect("driver=sql-blah-blah;server=server;database=blah;uid=left empty;pwd=left empty;Trusted Connection=yes", autocommit=True)
And it will handle the complexity of the listener by choosing an ip address and making the connection? Or the connection simply handles the multisubnetfailover? Or any other possible solution to our problem?
I've tried the ;MultiSubnetFailover approach in the connection string itself. Still does not connect.
pyodbc.connect("driver=sql-blah-blah;server=server;database=blah;uid=left empty;pwd=left empty;Trusted Connection=yes;MultiSubnetFailover=True", autocommit=True,)
Connection timeout. More specifically...
pyodbc.OperationalError: ('HYT00', '[HYT00] [Microsoft][ODBC SQL Server Driver]Login timeout expired (0) (SQLDriverConnect); [01S00] [Microsoft][ODBC SQL Server Driver]Invalid connection string attribute (0)')
Even without the "MultiSubnetFailover=True" attribute in the connection string, I still get the following error...
pyodbc.OperationalError: ('HYT00', '[HYT00] [Microsoft][ODBC SQL Server Driver]Login timeout expired (0) (SQLDriverConnect); [01S00] [Microsoft][ODBC SQL Server Driver]Invalid connection string attribute (0)')
python sql pyodbc
asked Jan 3 at 22:31
Austin DuranAustin Duran
34
Our database team recently implemented a listener that has multiple IP addresses. Before this implementation, our connection string to connect to the SQL server used to work flawlessly with pyodbc...
import pyodbc
pyodbc.connect("driver=sql-blah-blah;server=server;database=blah;uid=left empty;pwd=left empty;Trusted Connection=yes", autocommit=True)
Now, we're finding that our connections to the listener are hit and miss. Sometimes we will establish a connection successfully and sometimes the connection fails with a timeout.
I'm curious if there is a Python 2.7 module that will support multisubnetfailover where I can specify a connection string like the following...
"hoped for module".connect("driver=sql-blah-blah;server=server;database=blah;uid=left empty;pwd=left empty;Trusted Connection=yes", autocommit=True)
And it will handle the complexity of the listener by choosing an ip address and making the connection? Or the connection simply handles the multisubnetfailover? Or any other possible solution to our problem?
I've tried the ;MultiSubnetFailover approach in the connection string itself. Still does not connect.
pyodbc.connect("driver=sql-blah-blah;server=server;database=blah;uid=left empty;pwd=left empty;Trusted Connection=yes;MultiSubnetFailover=True", autocommit=True,)
Connection timeout. More specifically...
pyodbc.OperationalError: ('HYT00', '[HYT00] [Microsoft][ODBC SQL Server Driver]Login timeout expired (0) (SQLDriverConnect); [01S00] [Microsoft][ODBC SQL Server Driver]Invalid connection string attribute (0)')
Even without the "MultiSubnetFailover=True" attribute in the connection string, I still get the following error...
pyodbc.OperationalError: ('HYT00', '[HYT00] [Microsoft][ODBC SQL Server Driver]Login timeout expired (0) (SQLDriverConnect); [01S00] [Microsoft][ODBC SQL Server Driver]Invalid connection string attribute (0)')
python sql pyodbc
python sql pyodbc
asked Jan 3 at 22:31
Austin DuranAustin Duran
34
asked Jan 3 at 22:31
Austin DuranAustin Duran
34
edited Jan 4 at 16:56
Austin Duran
asked Jan 3 at 22:31
Austin DuranAustin Duran
34
asked Jan 3 at 22:31
Austin DuranAustin Duran
34
asked Jan 3 at 22:31
Austin DuranAustin Duran
34
34
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%2f54030699%2fpython-2-7-module-that-supports-database-connection-with-multisubnetfailover%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%2f54030699%2fpython-2-7-module-that-supports-database-connection-with-multisubnetfailover%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
