General network error in VB Application

Hello All,

I need some help with tracing this problem. Only one system in our network gets this error.

Runtime error '-2147467259(80004005')

[DBNETLIB][ConnectionWrite (send()).]General network error. Check your network documentation.

I am using SQL Server 2000

I have checked the access rights of the user they are perfect and also as i have mentioned earlier this error comes up with this login only. I have also tried replacing the system but it was not helpfull.

What can I do to trace this error.

Thanks in advance.

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?

|||

dhavalchoksi,

Looks like this is permission issue with your login credential. Even the login credential has permission to login on the server machine, it probably does not have permission to access the targetted dababase tables. Hence you wan to also verify that the targetted table exists and the user login has the permission. Otherwise, tell me about your machine settups.

(1) domain or workgroup,

(2) OS of both client and server.

(2) connection strings in your VB app.

Thanks,

Nan