ODBC test
ODBC test
Time to time on some ODBC test happens strange error:
Unknown Error: [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation<cr> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionRead (recv())
Used ODBC driver "SQL Server" version 2000.86.18.30.00 with few SQL Servers 2005. HostMonitor 6.10 on Windows 2003 R2. 1Gb network connection.
Unknown Error: [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation<cr> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionRead (recv())
Used ODBC driver "SQL Server" version 2000.86.18.30.00 with few SQL Servers 2005. HostMonitor 6.10 on Windows 2003 R2. 1Gb network connection.
-
- Posts: 2832
- Joined: Tue May 16, 2006 4:41 am
- Contact:
Re: ODBC test
Such error means the server forcefully closed the connection. Hm. Could you check the MS SQL log for the errors?trurl wrote:[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionRead (recv())
With SQL Servers 2005 client is supplied SQL Native Client ODBC driver(sqlncli.dll 2005.90.2047.00). Coud you try to setup the datasource using this driver?trurl wrote:Used ODBC driver "SQL Server" version 2000.86.18.30.00 with few SQL Servers 2005.
There are some special ODBC options, located on Options > Misc > ODBC related options tab. Have you enabled "Connection pooling" or "Do not use SQLFetchAbsolute command" options?
Regards,
Max
-
- Posts: 2832
- Joined: Tue May 16, 2006 4:41 am
- Contact:
Re: ODBC test
No any errors on SQL server side.KS-Soft Europe wrote:Such error means the server forcefully closed the connection. Hm. Could you check the MS SQL log for the errors?trurl wrote:[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionRead (recv())
With SQL Servers 2005 client is supplied SQL Native Client ODBC driver(sqlncli.dll 2005.90.2047.00). Coud you try to setup the datasource using this driver?trurl wrote:Used ODBC driver "SQL Server" version 2000.86.18.30.00 with few SQL Servers 2005.
There are some special ODBC options, located on Options > Misc > ODBC related options tab. Have you enabled "Connection pooling" or "Do not use SQLFetchAbsolute command" options?
Regards,
Max
With "SQL Native Client" I've time to time getting another error:
Code: Select all
Unknown Error: [Microsoft][SQL Native Client]Failed to read prelogin response<cr> [Microsoft][SQL Native Client][SQL Server]Changed language setting to us_english<cr> [Microsoft][SQL Native Client][SQL Server]Changed database context to 'DataStore'<cr> [Microsoft][SQL Native Client]Client unable to establish connectio
"Do not use SQLFetchAbsolute command" turned off (but with "on" is same result)
Antivirus not used yet (new monitoring server). Firewall used, but open as router (no NAT) on this protocols
-
- Posts: 2832
- Joined: Tue May 16, 2006 4:41 am
- Contact:
Re: ODBC test
Quite strange error. It seems the server is not ready to process a new local connection, possibly due to overload. How often does HostMonitor perform the ODBC tests? Do you use lightweight query or something complex (stored proc, etc)? What about other software that uses SQL servers? Could you check the server load?trurl wrote:Error: [Microsoft][SQL Native Client]Failed to read prelogin response
I think, following article might be helpful: http://www.microsoft.com/technet/prodte ... rfprb.mspx
Regards,
Max
Re: ODBC test
Running 15-20 tests (interval 10 minutes)KS-Soft Europe wrote:Quite strange error. It seems the server is not ready to process a new local connection, possibly due to overload. How often does HostMonitor perform the ODBC tests? Do you use lightweight query or something complex (stored proc, etc)? What about other software that uses SQL servers? Could you check the server load?trurl wrote:Error: [Microsoft][SQL Native Client]Failed to read prelogin response
I think, following article might be helpful: http://www.microsoft.com/technet/prodte ... rfprb.mspx
Regards,
Max
Stored procedures, but very light
Fails not related to server load

With SQL Server driver it's happens 5-10 times per day, with SQL Native Client it's fails every time with 1-5 tests)
Sometimes getting error:
Code: Select all
Unknown Error: [Microsoft][SQL Native Client]TCP Provider: The specified network name is no longer available.<cr> <cr> [Microsoft][SQL Native Client]Communication link failur
-
- Posts: 2832
- Joined: Tue May 16, 2006 4:41 am
- Contact:
Looks like problem with SQL Server. I have looked through Google and found the following:
It might help.
Regards,
Max
You may find full article here: http://download.microsoft.com/download/ ... XP2005.htm5.1 Connections May Be Forcibly Closed When Running on Windows Server 2003 SP1
If TCP/IP networking is turned on, client connections to an instance of the SQL Server Express Database Engine running on Windows Server 2003 Service Pack 1 might fail with the following error: "ProviderNum: 7, Error: 10054, ErrorMessage: "TCP Provider: An existing connection was forcibly closed by the remote host"."
This might occur when you are testing scalability with a large number of client connection attempts. To resolve this issue, use the regedit.exe utility to add a new DWORD value named SynAttackProtect to the registry key HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters\ with value data of 00000000.
Security Note:
Setting this registry key might expose the server to a SYN flood denial-of-service attack. Remove this registry value when testing is complete.
Caution:
Incorrectly editing the registry can cause serious problems that might require you to reinstall your operating system. Microsoft cannot guarantee that problems resulting from editing the registry incorrectly can be resolved. Before editing the registry, back up any valuable data. For information about how to back up, restore, and edit the registry, Microsoft Knowledge Base article 256986.
It might help.
Regards,
Max
Still every time happen random errors. For example:
or
Code: Select all
Error: Access violation at address 00000000. Read at address 00000000
Code: Select all
Error: [Microsoft][SQL Native Client] Failed to read prelogin response
-
- Posts: 2832
- Joined: Tue May 16, 2006 4:41 am
- Contact:
Sorry, we could not reproduce such behaviour in our test environment. Probably, you need adjust some network or MS SQL server settings.
Please, read following article:
http://support.microsoft.com/kb/170359/en-us
It might help.
Regards,
Max
Please, read following article:
http://support.microsoft.com/kb/170359/en-us
It might help.
Regards,
Max