Click here to Skip to main content
15,397,218 members
Home / Discussions / Database
   

Database

 
AnswerRe: Why connection is failing?! Pin
Jassim Rahma16-Apr-14 10:50
MemberJassim Rahma16-Apr-14 10:50 
GeneralRe: Why connection is failing?! Pin
Mycroft Holmes16-Apr-14 12:57
professionalMycroft Holmes16-Apr-14 12:57 
GeneralRe: Why connection is failing?! Pin
Jassim Rahma16-Apr-14 12:59
MemberJassim Rahma16-Apr-14 12:59 
GeneralRe: Why connection is failing?! Pin
Bernhard Hiller16-Apr-14 20:54
MemberBernhard Hiller16-Apr-14 20:54 
GeneralRe: Why connection is failing?! Pin
Jassim Rahma16-Apr-14 22:38
MemberJassim Rahma16-Apr-14 22:38 
GeneralRe: Why connection is failing?! Pin
Eddy Vluggen17-Apr-14 0:26
professionalEddy Vluggen17-Apr-14 0:26 
GeneralRe: Why connection is failing?! Pin
Jassim Rahma17-Apr-14 0:42
MemberJassim Rahma17-Apr-14 0:42 
GeneralRe: Why connection is failing?! Pin
Eddy Vluggen17-Apr-14 10:46
professionalEddy Vluggen17-Apr-14 10:46 
Jassim Rahma wrote:
and by the way, I was not pointing fingers Smile | :) Lol
My bad; it could have been, depending on language and intonation Smile | :)

I usually take the exception-message as a starting point;
Jassim Rahma wrote:
"MySQL A connection attempt failed because the connected third party did not properly respond after a period of time"
Plan of attack;

  • Create a console-app, use the users' credentials, and try a minimal query (SELECT 1 or something similar)
  • Test once with your current data provider (MySQL Connector.NET?)
  • Copy the project, try another data provider (MySQLDotNET[^])
  • Try the same again, using the dba-account.
If you can terminal to MySQL, then the server is there; that you said was true. That means that you can skip checking the firewall and the port on which MySQL speaks. The reason I'm asking to test with the dba's account is that he should have unrestricted access to all tables. If that one connects correctly, then you'd need to do some extra grants on your users' accounts.

What does your connection-string look like? Can you post it here? (Without the login-info)
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]

Questionwhy looping is not starting from my start date? Pin
Jassim Rahma16-Apr-14 0:04
MemberJassim Rahma16-Apr-14 0:04 
AnswerRe: why looping is not starting from my start date? Pin
jimbowAX16-Apr-14 3:04
MemberjimbowAX16-Apr-14 3:04 
QuestionRe: why looping is not starting from my start date? Pin
Richard MacCutchan16-Apr-14 6:01
mveRichard MacCutchan16-Apr-14 6:01 
AnswerRe: why looping is not starting from my start date? Pin
Jassim Rahma16-Apr-14 6:14
MemberJassim Rahma16-Apr-14 6:14 
SuggestionRe: why looping is not starting from my start date? Pin
Richard MacCutchan16-Apr-14 6:29
mveRichard MacCutchan16-Apr-14 6:29 
GeneralRe: why looping is not starting from my start date? Pin
jimbowAX22-Apr-14 7:32
MemberjimbowAX22-Apr-14 7:32 
QuestionEmail Notification trhu SQL SERVER using SMTP Pin
Member 1075257815-Apr-14 21:09
MemberMember 1075257815-Apr-14 21:09 
AnswerRe: Email Notification trhu SQL SERVER using SMTP Pin
jschell17-Apr-14 10:07
Memberjschell17-Apr-14 10:07 
QuestionRecurring job orders timeing out after about 32 seconds Pin
Jassim Rahma14-Apr-14 23:54
MemberJassim Rahma14-Apr-14 23:54 
AnswerRe: Recurring job orders timeing out after about 32 seconds Pin
Richard Deeming15-Apr-14 2:30
mveRichard Deeming15-Apr-14 2:30 
GeneralRe: Recurring job orders timeing out after about 32 seconds Pin
Jassim Rahma15-Apr-14 2:47
MemberJassim Rahma15-Apr-14 2:47 
GeneralRe: Recurring job orders timeing out after about 32 seconds Pin
Richard Deeming15-Apr-14 2:54
mveRichard Deeming15-Apr-14 2:54 
GeneralRe: Recurring job orders timeing out after about 32 seconds Pin
Jassim Rahma15-Apr-14 2:55
MemberJassim Rahma15-Apr-14 2:55 
QuestionMySQL A connection attempt failed because the connected third party did not properly respond after a period of time Pin
Jassim Rahma12-Apr-14 1:57
MemberJassim Rahma12-Apr-14 1:57 
AnswerRe: MySQL A connection attempt failed because the connected third party did not properly respond after a period of time Pin
Jassim Rahma14-Apr-14 23:55
MemberJassim Rahma14-Apr-14 23:55 
Questionconvert Pin
Member 1074305611-Apr-14 10:33
MemberMember 1074305611-Apr-14 10:33 
AnswerRe: convert Pin
Mycroft Holmes11-Apr-14 13:35
professionalMycroft Holmes11-Apr-14 13:35 

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.