Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-01-13 : 08:46:40
|
| Leonardo writes "Hello Guys, I would like to share with you a problem that I got and up to now I don't have any idea how to fix that up. I had developed an application (VB 6.0 Platform) where the application is supposed to manage all plant scheduling activities, so it's complex and pretty. I made use of OLEDB connection to reach my SQL Server, but as much as the system was getting bigger, the problem has been appearing. The application seems normal for some time, but suddenly I got the following error messages when I'd try to run some big functionality: "General Network Error", "Connection Link Failure" and "Protocol Error in TDS Stream" Those errors appears when the cursor is in the line that opens the recordset with the database. Details: 1. I'm running the application under a 10/100mpbs network 2. The application has been developed in Visual Basic 6.0 3. The database type is a SQL Server 2000 (Service Pack 2.0) 4. The client is using MDAC 2.8 version 5. I already made use of ODBC connection type as well (but I got the same errors)" |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-01-13 : 09:24:37
|
| Could be symptomatic of an overloaded network. You could try switching to gigabit ethernet and seeing if that solves your problem. Might be worth checking network load first.I've also seen similar things on systems where the back end disk subsystem is not up to the job, eg IDE hard drives where you could use SATA or SCSI.-------Moo. :) |
 |
|
|
|
|
|
SQL Server - Connection Link Failure