I am getting lots of the below errors in my order entry system recently with no explainable cause.
[DBNETLIB][ConnectionWrite (send()).]General network error. Check your network documentation.
While i guess this could be a network hub failing or something in the network I am assuming these are being caused by SQL server. My course of action is to install the service packs in my SQL2000 server. Currently i'm running version 8.00.194 on Windows NT 5.0 (Build 2195: Service Pack 4). I have lots of stored procedures that my VB6 order entry frontend and reporting system uses. Is there any known problems with going from no service packs to SP4? I plan on running a full backup of all user db's and scripting out all jobs before installing SP4.
When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful.
Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.