Click here to Skip to main content
15,880,392 members
Home / Discussions / Database
   

Database

 
QuestionProblem with Access Pin
JackMisani10-Jan-18 7:51
JackMisani10-Jan-18 7:51 
AnswerRe: Problem with Access Pin
Tim Carmichael12-Jan-18 3:50
Tim Carmichael12-Jan-18 3:50 
GeneralRe: Problem with Access Pin
JackMisani12-Jan-18 4:23
JackMisani12-Jan-18 4:23 
GeneralRe: Problem with Access Pin
Tim Carmichael12-Jan-18 5:13
Tim Carmichael12-Jan-18 5:13 
GeneralRe: Problem with Access Pin
JackMisani16-Jan-18 22:07
JackMisani16-Jan-18 22:07 
GeneralRe: Problem with Access Pin
Tim Carmichael17-Jan-18 2:24
Tim Carmichael17-Jan-18 2:24 
QuestionOLEDB connection to a SQL server database hosted in an availability group (repost) Pin
kmoorevs2-Jan-18 11:38
kmoorevs2-Jan-18 11:38 
AnswerRe: OLEDB connection to a SQL server database hosted in an availability group (repost) Pin
PIEBALDconsult2-Jan-18 14:12
mvePIEBALDconsult2-Jan-18 14:12 
<oldnews>

Oh, right, MultiSubnetFailover cannot be set via OleDb -- OleDb considered harmful. Without that setting our OleDb connections failed about half the time.

We started hearing the "Microsoft is deprecating OleDb" rumor a few years back (2012?) but we hadn't had any issues until this past summer when one of our partners changed their configuration.
Our partner said we had to use the SQL Client via ADO.net and I said I bet we don't -- so we use the Native Client via ODBC via ADO.net . ODBC can set MultiSubnetFailover

SQL Server Native Client Support for High Availability, Disaster Recovery | Microsoft Docs[^]

Microsoft is Aligning with ODBC for Native Relational Data Access – Microsoft SQLNCli team blog[^]

SQL Server Native Client OLE DB Provider Will Not Ship after SQL Server 2012[^]

</oldnews>

Joyous news! THIS JUST IN! (two months ago)

Announcing the new release of OLE DB Driver for SQL Server – Microsoft SQLNCli team blog[^]

modified 2-Jan-18 21:07pm.

GeneralRe: OLEDB connection to a SQL server database hosted in an availability group (repost) Pin
kmoorevs4-Jan-18 8:33
kmoorevs4-Jan-18 8:33 
AnswerRe: OLEDB connection to a SQL server database hosted in an availability group (repost) Pin
Joe DiNatale4-Jan-18 11:10
Joe DiNatale4-Jan-18 11:10 
GeneralRe: OLEDB connection to a SQL server database hosted in an availability group (repost) Pin
kmoorevs4-Jan-18 11:33
kmoorevs4-Jan-18 11:33 
GeneralRe: OLEDB connection to a SQL server database hosted in an availability group (repost) Pin
S Douglas7-Mar-18 11:35
professionalS Douglas7-Mar-18 11:35 
AnswerRe: OLEDB connection to a SQL server database hosted in an availability group (repost) Pin
S Douglas7-Mar-18 11:31
professionalS Douglas7-Mar-18 11:31 
QuestionMore than interesting... Pin
Kornfeld Eliyahu Peter31-Dec-17 21:05
professionalKornfeld Eliyahu Peter31-Dec-17 21:05 
AnswerRe: More than interesting... Pin
Jörgen Andersson1-Jan-18 3:44
professionalJörgen Andersson1-Jan-18 3:44 
GeneralRe: More than interesting... Pin
Kornfeld Eliyahu Peter1-Jan-18 4:31
professionalKornfeld Eliyahu Peter1-Jan-18 4:31 
GeneralRe: More than interesting... Pin
Jörgen Andersson2-Jan-18 5:28
professionalJörgen Andersson2-Jan-18 5:28 
SuggestionRe: More than interesting... Pin
Richard Deeming8-Jan-18 7:22
mveRichard Deeming8-Jan-18 7:22 
GeneralRe: More than interesting... Pin
Jörgen Andersson8-Jan-18 9:03
professionalJörgen Andersson8-Jan-18 9:03 
GeneralRe: More than interesting... Pin
Richard Deeming9-Jan-18 1:26
mveRichard Deeming9-Jan-18 1:26 
GeneralRe: More than interesting... Pin
Jörgen Andersson9-Jan-18 8:39
professionalJörgen Andersson9-Jan-18 8:39 
AnswerRe: More than interesting... Pin
jschell1-Jan-18 7:04
jschell1-Jan-18 7:04 
GeneralRe: More than interesting... Pin
Kornfeld Eliyahu Peter1-Jan-18 8:23
professionalKornfeld Eliyahu Peter1-Jan-18 8:23 
GeneralRe: More than interesting... Pin
ZurdoDev8-Jan-18 8:05
professionalZurdoDev8-Jan-18 8:05 
QuestionTrigger value > ? write in different table Pin
brian121026-Dec-17 13:44
brian121026-Dec-17 13:44 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.