HI all
I am facing a problem on sql server 7 Desktop Engine with front end VB6 and ADO 2.8 my OS is windows 2000 Professional.
ie. I am doing appendchunk to add image files on SQL Table it works fine for Approximately 130 MB, But i am trying to add 249 MB size file it will be showing these error Message.
[DBNETLIB] 2147467259(80004005) [Connection write(send()),] General Network Error check your network documentation.
I do so many way to correct this problem but it stuck up overthere.
In vb appendchunk is completed and the error when Updated command starts (update command also going a long way then show the above mentioned error.
Any body have any idea or clue just tel me for experiment. and complete my project.
Once again I request you please help me.
Thanks in advance.
Note : it is working with Access Database very fine I am tested it But in Access not allow me to store me lots of images its only allow 2 GB storage totally in a table.
SQL 7 [DBNETLIB] 2147467259(80004005) [Connection write(send()),] General Network Error
kenichi yamazaki
Peter and Nan gave following useful info in another forum question, I gathered and hope this help you.
If this happens during the connection (login) time most likely the server closed the connection.
There may be several raesons. Besides general login permissions, it can be lack of permissions on the default database, lack of the default database etc.
You can try checking the EventLog ERRORLOG on the server whether it reveals any clues.
What is the OS of the client and server
Do you get the same error if you use the same login account through tools like Query Analyzer or OSQL
If you still face problem, please provide following info.
(1) domain or workgroup,
(2) OS of both client and server.
(2) connection strings in your client app.
dougal83
Thanks for your help in advance
1) Workgroup
2) Windows 2000 Professionall (Not Server) my sql 7 Server (installed desktop Engin) both are in same computer (os & Server 7)
3) connection string
strCn = "Server=srv;Database=blob;UID=administrator;Pwd=;"
cnnImage.Provider = "SQLOLEDB;OLE DB Services= -2;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=blob;Data Source=srv"
cnnImage.Open strCn
Note: my application is work fin in access 2000.
in Sql7 it will be working fine for less than 130 MB image field storing I need storing around 780Mb in a image field.
i really appreciate your response
thank you once again
highpockets
Also, you can check server errorlog or os event log to get more info about why server close connection, and that would greatly help us to identify your problem.
Thanks!
Ming.
ventura
Hi,Gilbee
As for the " General Network Error ..." it most likely that server close connection during your database operation, might due to what you described " in Sql7 it will be working fine for less than 130 MB image field storing I need storing around 780Mb in a image field ", it probably by product design.
So,
1) I wonder, why you really need SQL 7 since it is too old, why not upgrad to SQL 2000, even SQL 2005, server should compatabile with downlevel client app always.
2) If you still want to find out the problem inside SQL 7, I suggest you post question to Engine Forum where your question most related to, many experts could answer your question shortely.
http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=93&SiteID=1
Good Luck!
Ming.