uppercut7141
asked on
Receiving errors on ODBC (Pervasive DB) on Server 2008 R2
Here's a brief scenario of what's going on presently:
Server 1 is reports dropping error on Pervassive DB (ODBC connection) on a Windows Server 2008 R2. When we switched over to Server 2 which sits on the exact, supposedly, server hardware as server 1, we do not witness any issues/errors. Went back onto Server 1 again and errors report again. Once again we switched to server 2 and rebooted server 1. No errors to report as of now.
Any utilities windows server 2008 R2 offer to assist in the troubleshooting of these errors? I understand Server 2008 R2 is supposed to be filled with built in utilities for a bunch of things.
I was thinking of running I/O meter to verify if I can witness anything, but we're restricted on running anything outside of the MS world.
Server 1 is reports dropping error on Pervassive DB (ODBC connection) on a Windows Server 2008 R2. When we switched over to Server 2 which sits on the exact, supposedly, server hardware as server 1, we do not witness any issues/errors. Went back onto Server 1 again and errors report again. Once again we switched to server 2 and rebooted server 1. No errors to report as of now.
Any utilities windows server 2008 R2 offer to assist in the troubleshooting of these errors? I understand Server 2008 R2 is supposed to be filled with built in utilities for a bunch of things.
I was thinking of running I/O meter to verify if I can witness anything, but we're restricted on running anything outside of the MS world.
ASKER
Great info!
Is there anything within the MS world that could assist with this?
Is there anything within the MS world that could assist with this?
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
It could be a simple cabling issue (try replacing cable, check port configuration on switch, etc.), a problem with throughput (such as during backups or other heavy network activity), a problem with the NIC or driver (try updating the driver, switching to an alternate NIC if available), etc.
If it helps, there is a paper on testing your network connection with the Pervasive System Analyzer located here:
http://www.goldstarsoftware.com/whitepapers-troubleshooting.asp
Be sure to read the paper to know how to analyze the results.
You can also use FPING (from qwakkelflap) to test like this:
FPING computername -t 0 -s 32000 -n 1000
If you see dropped packets, then you have a networking issue. This is nice because you can test to ANY two computers, without involving Pervasive at all.