Why connection is failing?!
-
Hi, I am having the above error on my .net application. It only shows on customer screen with a basix SELECT statement. Currently I have only 1600 customers in the customers table This error is not shown on any of the other screens except the customer screen. My connection timeout is 360 and I even tried to increase it to 800 but getting the same error for the customer screen! what could be the problem please? Thanks, Jassim
Technology News @ www.JassimRahma.com
-
Hi, I am having the above error on my .net application. It only shows on customer screen with a basix SELECT statement. Currently I have only 1600 customers in the customers table This error is not shown on any of the other screens except the customer screen. My connection timeout is 360 and I even tried to increase it to 800 but getting the same error for the customer screen! what could be the problem please? Thanks, Jassim
Technology News @ www.JassimRahma.com
Jassim Rahma wrote:
"MySQL A connection attempt failed because the connected third party did not properly respond after a period of time"
You're referencing to something that's not there; the exception message comes from one of your older posts. Simply include it with the rest of the text. Can you connect at all to that particular server? Using Telnet[^]?
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]
-
Jassim Rahma wrote:
"MySQL A connection attempt failed because the connected third party did not properly respond after a period of time"
You're referencing to something that's not there; the exception message comes from one of your older posts. Simply include it with the rest of the text. Can you connect at all to that particular server? Using Telnet[^]?
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]
Yes I can. I am also able to view invoices, employees and all other data from the same database on the same server using the same .net application. Exceptions occurs on the customers only. Any timeout parameter or variable I should try to look at?
Technology News @ www.JassimRahma.com
-
Yes I can. I am also able to view invoices, employees and all other data from the same database on the same server using the same .net application. Exceptions occurs on the customers only. Any timeout parameter or variable I should try to look at?
Technology News @ www.JassimRahma.com
I would suggest you look at the customer query then, it is not your connection, that works for other queries!
Never underestimate the power of human stupidity RAH
-
I would suggest you look at the customer query then, it is not your connection, that works for other queries!
Never underestimate the power of human stupidity RAH
this is my query:
SELECT customer_id, id_number, customer_name, email_address, landline_number, mobile_number, customer_address_building, customer_address_road, customer_address_block, customer_address_landmark, allow_delete, is_blacklist, is_inactive FROM customers ORDER BY customer_name;
Technology News @ www.JassimRahma.com
-
this is my query:
SELECT customer_id, id_number, customer_name, email_address, landline_number, mobile_number, customer_address_building, customer_address_road, customer_address_block, customer_address_landmark, allow_delete, is_blacklist, is_inactive FROM customers ORDER BY customer_name;
Technology News @ www.JassimRahma.com
There is no
WHEREclause?! -
There is no
WHEREclause?!no WHERE. I am filtering using the XtraGrid. It will be maximum of 2000 records which I though MySQL will be able to handle it easily.
Technology News @ www.JassimRahma.com
-
no WHERE. I am filtering using the XtraGrid. It will be maximum of 2000 records which I though MySQL will be able to handle it easily.
Technology News @ www.JassimRahma.com
Jassim Rahma wrote:
which I though MySQL will be able to handle it easily
Stop pointing fingers; it's not MySQL that's failing, but a third-party component. You might try to connect using another user/role/password at the customers site. And update your MySQL data provider :)
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]
-
Jassim Rahma wrote:
which I though MySQL will be able to handle it easily
Stop pointing fingers; it's not MySQL that's failing, but a third-party component. You might try to connect using another user/role/password at the customers site. And update your MySQL data provider :)
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]
I will do and by the way, I was not pointing fingers :) Lol Thank you so much
Technology News @ www.JassimRahma.com
-
I will do and by the way, I was not pointing fingers :) Lol Thank you so much
Technology News @ www.JassimRahma.com
Jassim Rahma wrote:
and by the way, I was not pointing fingers :) Lol
My bad; it could have been, depending on language and intonation :) 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 :suss: If you can't read my code, try converting it here[^]