Ask Question Forum:
Model Library:2025-02-08 Updated:A.I. model is online for auto reply question page
C
O
M
P
U
T
E
R
2
8
Show
#
ASK
RECENT
←
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Below area will not be traslated by Google,you can input code or other languages
Hint:If find spelling error, You need to correct it,1 by 1 or ignore it (code area won't be checked).
X-position of the mouse cursor
Y-position of the mouse cursor
Y-position of the mouse cursor
Testcursor
caretPos
Attachment:===
Asked by APD_Toronto
at 2024-07-31 08:10:56
ModifyPoint:500 Replies:13 POST_ID:829185USER_ID:12075
Topic:
Network Routers;;Networking Hardware
Hi Experts,
Is there a way to test a router?
I know if you connect to the internet it works, but I have previous issues where an Access application connecting to SQL had issues, but once I replaced the router, they went away. However, I was able to connect to internet with both routers.
Thank you
Is there a way to test a router?
I know if you connect to the internet it works, but I have previous issues where an Access application connecting to SQL had issues, but once I replaced the router, they went away. However, I was able to connect to internet with both routers.
Thank you
Expert: John Hurst replied at 2024-08-06 08:58:32
@APD_Toronto - Thanks for the update and I was happy to help.
Author: APD_Toronto replied at 2024-08-06 08:54:55
For now the client has put this issue on hold. If they reopen it I will review the above, and if needed open another post.
Assisted Solution
Expert: Gerwin Jansen replied at 2024-08-04 11:52:49
250 points EXCELLENT
If you have the issues again, can you check whether the router has the Intrusion Prevention setting enabled? That setting is under Advanced -> Advanced ->IPS accoring the manual. What value does the IPS status counter have?
Author: APD_Toronto replied at 2024-08-04 09:32:08
Sorry guys, I was distracted by another IT emergency.
At any rate, the *new* router, which I installed ~14months ago is D-Link DSR-250N. At that point, the frequency of the Access-SQL issues were reduced by far, but now they are high again.
At any rate, the *new* router, which I installed ~14months ago is D-Link DSR-250N. At that point, the frequency of the Access-SQL issues were reduced by far, but now they are high again.
Expert: Gerwin Jansen replied at 2024-07-31 14:41:06
I'm thinking the router that was not working had a firewall built into it. It probably had rules configured that caused Access not to be able to connect to the SQL database. A factory reset of that router may have fixed the issue.
Do you have a brand and type of that router?
Do you have a brand and type of that router?
Accepted Solution
Expert: John Hurst replied at 2024-07-31 10:21:01
250 points EXCELLENT
If you can get the maximum speed from a workstation on the router that your ISP advertises, then throughput is probably OK. It should be a specification of your router.
The other thing is latency, which often follow slowness.
Now I take it from your first post that the new router is OK and the problem was with the now out-of-service router. Correct me on that if I am wrong.
The other thing is latency, which often follow slowness.
Now I take it from your first post that the new router is OK and the problem was with the now out-of-service router. Correct me on that if I am wrong.
Author: APD_Toronto replied at 2024-07-31 09:12:19
So how would I test throutput and what are the normal readings?
Expert: John Hurst replied at 2024-07-31 08:31:57
If a router is slow inside (throughput) that affects speed and that may affect queries (because of the two way traffic).
What are you thinking of?
What are you thinking of?
Author: APD_Toronto replied at 2024-07-31 08:30:22
<<<Throughput would have an impact on Access and SQL and that may be what you saw.
What do you mean?
What do you mean?
Expert: John Hurst replied at 2024-07-31 08:27:23
Assuming the firewall is OK (usually is), then I use speedtest.net to see what the overall performance is. Throughput would have an impact on Access and SQL and that may be what you saw.
Expert: duncanb7 replied at 2024-07-31 08:25:35
You mean your question is how to test router to being connected to your SQL database, Right ?
Author: APD_Toronto replied at 2024-07-31 08:23:05
...but, if you read my post, I am able to connect to the internet.
Expert: duncanb7 replied at 2024-07-31 08:19:03
you can run any sites on your browser, and you can open the router administration page at 192.168.0.1 on browser , please read the router manual for exact IP, and you can use command of "ping yahoo.com" to test internet connection for yahoo.com
Duncan
Duncan
