Click here to Skip to main content
15,882,278 members
Home / Discussions / Database
   

Database

 
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 
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 
I had a similar problem a while ago. Sometimes it would connect and other times it would time out depending on which server was the current primary. I believe there is a DNS setting you can use to get around this but that was not an option in our case. The only solution I came up with was to set a long timeout (300 seconds) in the connection string. So now sometimes it connects right away and the rest of the time it will take about a minute. Not ideal but we've been able to live with it.

Hope this helps.
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 
AnswerRe: Trigger value > ? write in different table Pin
Victor Nijegorodov26-Dec-17 22:13
Victor Nijegorodov26-Dec-17 22:13 
AnswerRe: Trigger value > ? write in different table Pin
Richard MacCutchan26-Dec-17 22:41
mveRichard MacCutchan26-Dec-17 22:41 

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.