What is the latest version of SQL Server native client that is compatible with Sql Server 2008 r2SQL Server 2008 R2 Setup Client Tools ConnectivityIs it possible to use Native Clients from previous releases to connect SQL Server 2012?Sql Server 2012 and native client 10Maintaining SQL Server 2008 R2 on Windows 10SQL Native Client and network disconnectsWhere to find the installer for SQL Server Native Client 11.0.5058?Bulk exporting SQL Server 7 data and bulk importing it to SQL Server 2008 R2SQL Server 2012 (compability level 110) and SQL Server Native Client 10Install SQL Server 2017 over 2016 Local DB and 2012 native client
Are there reliable, formulaic ways to form chords on the guitar?
Multicolumn in table not centered
How could Tony Stark wield the Infinity Nano Gauntlet - at all?
Is it allowable to use an organization's name to publish a paper in a conference, even after I graduate from it?
Levenshtein Neighbours
What can I do to keep a threaded bolt from falling out of it’s slot
Unbiased estimator of exponential of measure of a set?
Vacuum collapse -- why do strong metals implode but glass doesn't?
How did Apollo 15's depressurization work?
E: Sub-process /usr/bin/dpkg returned an error code (1) - but how do I find the meaningful error messages in APT's output?
Using は before 欲しい instead が
Are required indicators necessary for radio buttons?
Does the Symbiotic Entity damage apply to a creature hit by the secondary damage of Green Flame Blade?
Use of vor in this sentence
How big would a Daddy Longlegs Spider need to be to kill an average Human?
Moons that can't see each other
Do predators tend to have vertical slit pupils versus horizontal for prey animals?
Can I submit a paper under an alias so as to avoid trouble in my country?
Are there categories whose internal hom is somewhat 'exotic'?
What fuel is J005311 burning?
Are there any legal requirements concerning airline pilots and their watches?
Why don't sharp and flat root note chords seem to be present in much guitar music?
Why is su world executable?
Is a butterfly one or two animals?
What is the latest version of SQL Server native client that is compatible with Sql Server 2008 r2
SQL Server 2008 R2 Setup Client Tools ConnectivityIs it possible to use Native Clients from previous releases to connect SQL Server 2012?Sql Server 2012 and native client 10Maintaining SQL Server 2008 R2 on Windows 10SQL Native Client and network disconnectsWhere to find the installer for SQL Server Native Client 11.0.5058?Bulk exporting SQL Server 7 data and bulk importing it to SQL Server 2008 R2SQL Server 2012 (compability level 110) and SQL Server Native Client 10Install SQL Server 2017 over 2016 Local DB and 2012 native client
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
Title says it all, what is the most recent version of Sql Server native client that is compatible with Sql Server 2008 R2
sql-server-2008-r2 native-client
asked 8 hours ago
KySotoKySoto
1334 bronze badges
add a comment |
Title says it all, what is the most recent version of Sql Server native client that is compatible with Sql Server 2008 R2
sql-server-2008-r2 native-client
asked 8 hours ago
KySotoKySoto
1334 bronze badges
add a comment |
Title says it all, what is the most recent version of Sql Server native client that is compatible with Sql Server 2008 R2
sql-server-2008-r2 native-client
asked 8 hours ago
KySotoKySoto
1334 bronze badges
Title says it all, what is the most recent version of Sql Server native client that is compatible with Sql Server 2008 R2
sql-server-2008-r2 native-client
sql-server-2008-r2 native-client
asked 8 hours ago
KySotoKySoto
1334 bronze badges
asked 8 hours ago
KySotoKySoto
1334 bronze badges
asked 8 hours ago
KySotoKySoto
1334 bronze badges
asked 8 hours ago
KySotoKySoto
1334 bronze badges
asked 8 hours ago
KySotoKySoto
1334 bronze badges
1334 bronze badges
add a comment |
add a comment |
3 Answers
3
active
oldest
votes
Microsoft SQL Server Native Client 11.0 is the latest and is backward compatible with 2008 and 2008R2 (as of July 9 2019, both windows and sql server 2008 and 2008r2 are fully unsupported).
BOL warns you :
The SQL Server Native Client (SQLNCLI) remains deprecated and it is not recommended to use it for new development work. Instead, use the new Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) which will be updated with the most recent server features.
answered 8 hours ago
Kin ShahKin Shah
55.5k4 gold badges86 silver badges200 bronze badges
The fun thing is, after i asked this question, i found out that 11.0 doesnt support windows xp, and unfortunately we have test equipment we have not upgraded yet, Thanks for the quick answer.
– KySoto
7 hours ago
@KySoto Your test equipment is running XP? Is production running XP too? Otherwise how much faith do you put in your tests?
– Aaron Bertrand♦
6 hours ago
we have pieces of equipment that can ONLY run on xp, it cant get on the internet, but obviously if something sneaks in, that computer would be vulnerable to it. on some of the applications running, it was homebrew code that a former engineer wrote, but bailed out on us. it takes a lotta time to replace.
– KySoto
5 hours ago
add a comment |
SQL Server 2008 R2 is out of support, but AFAIK every existing SQL Server client library, including all SNAC and ODBC drivers should work fine with that version.
answered 8 hours ago
David Browne - MicrosoftDavid Browne - Microsoft
14.4k1 gold badge13 silver badges38 bronze badges
Thanks for the quick reply, sadly we just dont have the cash to update to a newer version of sql server (im pushing!)
– KySoto
7 hours ago
add a comment |
I believe, there is no version beyond SQL Server native client 11.0 which you can use for SQL Server 2008
answered 8 hours ago
Shekar KolaShekar Kola
3031 silver badge9 bronze badges
Didnt realize you could connect to sql server 2018 with native client 11.0, neat bit of trivia.
– KySoto
7 hours ago
1
@KySoto, sorry for the typo mistake, corrected!
– Shekar Kola
7 hours ago
add a comment |
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
);
);
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%2f245686%2fwhat-is-the-latest-version-of-sql-server-native-client-that-is-compatible-with-s%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
3 Answers
3
active
oldest
votes
3 Answers
3
active
oldest
votes
active
oldest
votes
active
oldest
votes
Microsoft SQL Server Native Client 11.0 is the latest and is backward compatible with 2008 and 2008R2 (as of July 9 2019, both windows and sql server 2008 and 2008r2 are fully unsupported).
BOL warns you :
The SQL Server Native Client (SQLNCLI) remains deprecated and it is not recommended to use it for new development work. Instead, use the new Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) which will be updated with the most recent server features.
answered 8 hours ago
Kin ShahKin Shah
55.5k4 gold badges86 silver badges200 bronze badges
The fun thing is, after i asked this question, i found out that 11.0 doesnt support windows xp, and unfortunately we have test equipment we have not upgraded yet, Thanks for the quick answer.
– KySoto
7 hours ago
@KySoto Your test equipment is running XP? Is production running XP too? Otherwise how much faith do you put in your tests?
– Aaron Bertrand♦
6 hours ago
we have pieces of equipment that can ONLY run on xp, it cant get on the internet, but obviously if something sneaks in, that computer would be vulnerable to it. on some of the applications running, it was homebrew code that a former engineer wrote, but bailed out on us. it takes a lotta time to replace.
– KySoto
5 hours ago
add a comment |
Microsoft SQL Server Native Client 11.0 is the latest and is backward compatible with 2008 and 2008R2 (as of July 9 2019, both windows and sql server 2008 and 2008r2 are fully unsupported).
BOL warns you :
The SQL Server Native Client (SQLNCLI) remains deprecated and it is not recommended to use it for new development work. Instead, use the new Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) which will be updated with the most recent server features.
answered 8 hours ago
Kin ShahKin Shah
55.5k4 gold badges86 silver badges200 bronze badges
The fun thing is, after i asked this question, i found out that 11.0 doesnt support windows xp, and unfortunately we have test equipment we have not upgraded yet, Thanks for the quick answer.
– KySoto
7 hours ago
@KySoto Your test equipment is running XP? Is production running XP too? Otherwise how much faith do you put in your tests?
– Aaron Bertrand♦
6 hours ago
we have pieces of equipment that can ONLY run on xp, it cant get on the internet, but obviously if something sneaks in, that computer would be vulnerable to it. on some of the applications running, it was homebrew code that a former engineer wrote, but bailed out on us. it takes a lotta time to replace.
– KySoto
5 hours ago
add a comment |
Microsoft SQL Server Native Client 11.0 is the latest and is backward compatible with 2008 and 2008R2 (as of July 9 2019, both windows and sql server 2008 and 2008r2 are fully unsupported).
BOL warns you :
The SQL Server Native Client (SQLNCLI) remains deprecated and it is not recommended to use it for new development work. Instead, use the new Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) which will be updated with the most recent server features.
answered 8 hours ago
Kin ShahKin Shah
55.5k4 gold badges86 silver badges200 bronze badges
Microsoft SQL Server Native Client 11.0 is the latest and is backward compatible with 2008 and 2008R2 (as of July 9 2019, both windows and sql server 2008 and 2008r2 are fully unsupported).
BOL warns you :
The SQL Server Native Client (SQLNCLI) remains deprecated and it is not recommended to use it for new development work. Instead, use the new Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) which will be updated with the most recent server features.
answered 8 hours ago
Kin ShahKin Shah
55.5k4 gold badges86 silver badges200 bronze badges
answered 8 hours ago
Kin ShahKin Shah
55.5k4 gold badges86 silver badges200 bronze badges
answered 8 hours ago
Kin ShahKin Shah
55.5k4 gold badges86 silver badges200 bronze badges
answered 8 hours ago
Kin ShahKin Shah
55.5k4 gold badges86 silver badges200 bronze badges
55.5k4 gold badges86 silver badges200 bronze badges
The fun thing is, after i asked this question, i found out that 11.0 doesnt support windows xp, and unfortunately we have test equipment we have not upgraded yet, Thanks for the quick answer.
– KySoto
7 hours ago
@KySoto Your test equipment is running XP? Is production running XP too? Otherwise how much faith do you put in your tests?
– Aaron Bertrand♦
6 hours ago
we have pieces of equipment that can ONLY run on xp, it cant get on the internet, but obviously if something sneaks in, that computer would be vulnerable to it. on some of the applications running, it was homebrew code that a former engineer wrote, but bailed out on us. it takes a lotta time to replace.
– KySoto
5 hours ago
add a comment |
The fun thing is, after i asked this question, i found out that 11.0 doesnt support windows xp, and unfortunately we have test equipment we have not upgraded yet, Thanks for the quick answer.
– KySoto
7 hours ago
@KySoto Your test equipment is running XP? Is production running XP too? Otherwise how much faith do you put in your tests?
– Aaron Bertrand♦
6 hours ago
we have pieces of equipment that can ONLY run on xp, it cant get on the internet, but obviously if something sneaks in, that computer would be vulnerable to it. on some of the applications running, it was homebrew code that a former engineer wrote, but bailed out on us. it takes a lotta time to replace.
– KySoto
5 hours ago
The fun thing is, after i asked this question, i found out that 11.0 doesnt support windows xp, and unfortunately we have test equipment we have not upgraded yet, Thanks for the quick answer.
– KySoto
7 hours ago
The fun thing is, after i asked this question, i found out that 11.0 doesnt support windows xp, and unfortunately we have test equipment we have not upgraded yet, Thanks for the quick answer.
– KySoto
7 hours ago
@KySoto Your test equipment is running XP? Is production running XP too? Otherwise how much faith do you put in your tests?
– Aaron Bertrand♦
6 hours ago
@KySoto Your test equipment is running XP? Is production running XP too? Otherwise how much faith do you put in your tests?
– Aaron Bertrand♦
6 hours ago
we have pieces of equipment that can ONLY run on xp, it cant get on the internet, but obviously if something sneaks in, that computer would be vulnerable to it. on some of the applications running, it was homebrew code that a former engineer wrote, but bailed out on us. it takes a lotta time to replace.
– KySoto
5 hours ago
we have pieces of equipment that can ONLY run on xp, it cant get on the internet, but obviously if something sneaks in, that computer would be vulnerable to it. on some of the applications running, it was homebrew code that a former engineer wrote, but bailed out on us. it takes a lotta time to replace.
– KySoto
5 hours ago
add a comment |
SQL Server 2008 R2 is out of support, but AFAIK every existing SQL Server client library, including all SNAC and ODBC drivers should work fine with that version.
answered 8 hours ago
David Browne - MicrosoftDavid Browne - Microsoft
14.4k1 gold badge13 silver badges38 bronze badges
Thanks for the quick reply, sadly we just dont have the cash to update to a newer version of sql server (im pushing!)
– KySoto
7 hours ago
add a comment |
SQL Server 2008 R2 is out of support, but AFAIK every existing SQL Server client library, including all SNAC and ODBC drivers should work fine with that version.
answered 8 hours ago
David Browne - MicrosoftDavid Browne - Microsoft
14.4k1 gold badge13 silver badges38 bronze badges
Thanks for the quick reply, sadly we just dont have the cash to update to a newer version of sql server (im pushing!)
– KySoto
7 hours ago
add a comment |
SQL Server 2008 R2 is out of support, but AFAIK every existing SQL Server client library, including all SNAC and ODBC drivers should work fine with that version.
answered 8 hours ago
David Browne - MicrosoftDavid Browne - Microsoft
14.4k1 gold badge13 silver badges38 bronze badges
SQL Server 2008 R2 is out of support, but AFAIK every existing SQL Server client library, including all SNAC and ODBC drivers should work fine with that version.
answered 8 hours ago
David Browne - MicrosoftDavid Browne - Microsoft
14.4k1 gold badge13 silver badges38 bronze badges
answered 8 hours ago
David Browne - MicrosoftDavid Browne - Microsoft
14.4k1 gold badge13 silver badges38 bronze badges
answered 8 hours ago
David Browne - MicrosoftDavid Browne - Microsoft
14.4k1 gold badge13 silver badges38 bronze badges
answered 8 hours ago
David Browne - MicrosoftDavid Browne - Microsoft
14.4k1 gold badge13 silver badges38 bronze badges
14.4k1 gold badge13 silver badges38 bronze badges
Thanks for the quick reply, sadly we just dont have the cash to update to a newer version of sql server (im pushing!)
– KySoto
7 hours ago
add a comment |
Thanks for the quick reply, sadly we just dont have the cash to update to a newer version of sql server (im pushing!)
– KySoto
7 hours ago
Thanks for the quick reply, sadly we just dont have the cash to update to a newer version of sql server (im pushing!)
– KySoto
7 hours ago
Thanks for the quick reply, sadly we just dont have the cash to update to a newer version of sql server (im pushing!)
– KySoto
7 hours ago
add a comment |
I believe, there is no version beyond SQL Server native client 11.0 which you can use for SQL Server 2008
answered 8 hours ago
Shekar KolaShekar Kola
3031 silver badge9 bronze badges
Didnt realize you could connect to sql server 2018 with native client 11.0, neat bit of trivia.
– KySoto
7 hours ago
1
@KySoto, sorry for the typo mistake, corrected!
– Shekar Kola
7 hours ago
add a comment |
I believe, there is no version beyond SQL Server native client 11.0 which you can use for SQL Server 2008
answered 8 hours ago
Shekar KolaShekar Kola
3031 silver badge9 bronze badges
Didnt realize you could connect to sql server 2018 with native client 11.0, neat bit of trivia.
– KySoto
7 hours ago
1
@KySoto, sorry for the typo mistake, corrected!
– Shekar Kola
7 hours ago
add a comment |
I believe, there is no version beyond SQL Server native client 11.0 which you can use for SQL Server 2008
answered 8 hours ago
Shekar KolaShekar Kola
3031 silver badge9 bronze badges
I believe, there is no version beyond SQL Server native client 11.0 which you can use for SQL Server 2008
answered 8 hours ago
Shekar KolaShekar Kola
3031 silver badge9 bronze badges
edited 7 hours ago
answered 8 hours ago
Shekar KolaShekar Kola
3031 silver badge9 bronze badges
answered 8 hours ago
Shekar KolaShekar Kola
3031 silver badge9 bronze badges
answered 8 hours ago
Shekar KolaShekar Kola
3031 silver badge9 bronze badges
3031 silver badge9 bronze badges
Didnt realize you could connect to sql server 2018 with native client 11.0, neat bit of trivia.
– KySoto
7 hours ago
1
@KySoto, sorry for the typo mistake, corrected!
– Shekar Kola
7 hours ago
add a comment |
Didnt realize you could connect to sql server 2018 with native client 11.0, neat bit of trivia.
– KySoto
7 hours ago
1
@KySoto, sorry for the typo mistake, corrected!
– Shekar Kola
7 hours ago
Didnt realize you could connect to sql server 2018 with native client 11.0, neat bit of trivia.
– KySoto
7 hours ago
Didnt realize you could connect to sql server 2018 with native client 11.0, neat bit of trivia.
– KySoto
7 hours ago
1
1
@KySoto, sorry for the typo mistake, corrected!
– Shekar Kola
7 hours ago
@KySoto, sorry for the typo mistake, corrected!
– Shekar Kola
7 hours ago
add a comment |
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%2f245686%2fwhat-is-the-latest-version-of-sql-server-native-client-that-is-compatible-with-s%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
