by I am using Microsoft TCP/IP with Windows Sockets communicating with a SQL Server database (4.21) through MS Visual basic
and VBSQL and DBLIB.
What I am doing is writting a large file to an image field using SqlWriteText, and SqlMoreText. After about 40,000 characters I get a
"10025: Write to SQL Server Failed. Possible Network Problems." error.
However, if I step through the code, everything works correctly. Also if I run exactly the same code using Named Pipes I do not get
this error (our clients do not used Named Pipes, so this workaround doesn't help me too much).
This error can be easily reproduced using the VBSQL visual basic example Image.mak and the following steps:
1) Ensure you are running ONLY TCP/IP as your protocol, and that TCP/IP Sockets is chosen as your Net-Library.
2) Load the application titled Image.MAK supplied with the Microsoft SQL Server Programmers Reference for Visual Basic.
3) Connect to a SQL Server Database that is configured to "listen" on TCP/IP Sockets.
4) Select a database on this server (if it says the table does not exist say yes to it's creation).
5) Select a bitmap that is approx. 100,000 bytes or larger in size.
5) Choose Insert Image.
6) You will get a 10025 error (note in the VBSQL documentation the error says: "Write to SQL Server Failed. this error number is
unused"--I wish it was :-) )
If anyone has any hints/tips/comments/solutions, I would be eternally grateful.
Todd Stevenson
Onyx Software Corporation