System Error &H80004005 (-2147467259). Unspecified Error using VB6 & SQL Server 2005

Question

Dear Sir,

I have developed application using Visual Basic 6 & Microsoft SQL Server 2005. At my client place after some entries it getting System Error &H80004005 (-2147467259). Unspecified Error. In this case it doesn't work at all even we close and start application again. If my client restart system then again it works for some time.

Earlier my application using Visual Basic 6 & Microsoft Access was working properly.

Please HELP me.

Thanks,

Sanjay Shah

Answer 1

Refer below link, it may help :-

http://support.microsoft.com/kb/230888?wa=wsignin1.0

---

Regards,
Rohit Garg
(My Blog)
This posting is provided with no warranties and confers no rights.
Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread.

Answer 2

Hello,

It could be a problem of permissions type errors

http://social.msdn.microsoft.com/Forums/en-US/exceldev/thread/8447e6ce-588f-47b4-b47a-ee9e3a70624d

SQL Server 2005 is no longer supported ( even with extended support ). Please, could you tell us which is the exact version you have ( at least the last installed Service Pack for your SQL Server ) and the edition (Express,Standard,Entreprise,...) ?

Have a nice day

---

Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

Answer 3

Hello,

It would be useful to provide the informations about your SQL Server to make easier for us to find a solution to your problem.

VB6 is no longer supported.It would be clever to rewrite your application in a newer language based on the .Net Framework.

Have you looked at the logfiles of the operating system ( Windows,Applications,...) to find whether there is a record written when your problem is occuring? Idem in the SQL Server logs of your SQL Server instance ? If you find a logged error, could you provide the full and exact error message ? It is one of the most important informations necessary to solve your problem.

Please, could you tell us what is the operating system ( full edition and version ) of the computer on which the application is running ? It is also an important information...

It is a long time i have written in VB6 ( since the arrival of "clever" languages like VC Sharp or VB 2003 and a "correct" .Net Framework ) and i have forgotten most of my knowledges about VB6 and VC++ ( i had the Entreprise Edition of these both languages ), but i think that it is possible to know the place in the code where your error is occuring.The code around the error place is also an useful information to post ( for the last rare people who are knowing VB6 ).

It is also useful to provide informations explaining why you have unmarked a post marked as answer ( i think that , in 8 days , you should have enough time to test and post the results ).The repliers and moderators have no advantage to solve the problems reported by the original posters (OP), points and medals are not my main aims . But i recognize that a reply of the OP is always pleasant and useful , as it is a best way to provide more informations which would avoid that the replier is not coming on a bad way.

A last useful information would the provider you are using to connect to your SQL Server instance (ODBC,OLEDB ,...).

We are waiting for your feedback to try to help your more efficiently.

Have a nice day

---

Mark Post as helpful if it provides any help.Otherwise,leave it as it is.