Run-time error '-2147467259 (80004005)':

[fx.eko]

Hello all

I've been using it for years
SQL SERVER 2014 Standard and language
VB6 programming, but only this time
get the following error:

Run-time error '-2147467259 (80004005)':
[DBNETLIB][ConnectionWrite (WrapperWrite().]General network error

Has any of you guys ever experienced this??

what is this caused by??

thanks for the enlightenment

Regards,

[Dani]

This is outside my wheelhouse but I did a Google search and came across the following article on Microsoft's website about the issue: https://learn.microsoft.com/en-us/office/troubleshoot/excel/run-time-error-2147467259-80004005

The thing is though, that my Google search is also showing a lot of other articles each saying the problem is caused by all sorts of different things. In conclusion, I really wish I could help you, but you will probably need to wait for someone else to post here who has more experience with MSSQL.

[rproffitt]

While I can answer yes, you may not like my answer. VB6 was getting too expensive to keep up. Fixes too longer, workarounds kept getting more and more arcane and the client didn't like the pricing.

Finally we reached that tipping point where we moved up to VB.Net. Took a few months but out last VB6 app is officially dead.

But if the client wanted to run it on Windows XP to 7, it still works but their company policy is W10/11 everywhere so the app had to be upgraded.

[Dani]

Sorry, I don’t understand what you’re saying? Are you insinuating that the error they are getting is because they are running an older version of Windows? Because they’re also running an older version of VB and SQL, so why wouldn’t all 3 work together?

I’m confused about how your little anecdote about your company upgrading from VB6 is relevant to the error code.

[rproffitt]

Dani,

The old app was in VB6, ran for decades with minor revisions until Windows 10. We found work arounds but as Microsoft issued more OS updates it would break in very strange ways. Finally the cost (time is money) was getting to be too expensive. We didn't mind continuing but the cost to maintain legacy systems at some point means it's time to move on.

I see no need to open the old bug logs and look up exact errors we saw or the fixes we found. VB6 is unsupportable on Windows 10 and 11 today. Also, yes, we used SQL for this system.

[rproffitt]

PS: Read prior (old) answers like https://stackoverflow.com/questions/10755560/auto-recover-when-dbnetlib-connectionwrite-general-network-error-causes-ado-conn

My view is that VB6's time passed years ago. Also, you can run the code in the IDE to see where it failed and examine that failure in more detail.

[Dani]

To rproffitt's point, fx.eko, what operating system are you running? Do other VB6 apps run perfectly fine on it? Have you ever experienced any issues like this before? Did Windows Update recently run and perhaps upgrade something that broke VB6?

My view is that VB6's time passed years ago.

I agree that VB6's time passed many years ago, although I have a soft spot for it as it was one of my first programming languages. (I went from BASIC on an Apple IIGS when I was 4 years old, to QBASIC when I was 10 or 11, to Visual Basic 4 and then VB6 when I was 12/13ish. I think that timelines is about right, although don't quote me on it :)

But to go back to fx.eko's question, did the Microsoft article I linked you to yesterday help at all?

Good luck!

[fx.eko]

hi @Dani the link you provided didn't help me, the operating system that I use is Win 7 Professional and Win Server 2012 standard and SQL 2014 standard, indeed the VB6 programming language is a bit behind, but in migrating the system of course the old system is still running, can't just cut off, while the process of developing to VB.Net is not finished

Regards,

[rproffitt]

That error can be caused by non-code related issues. Such as a network issue, the server not responding and more.

As the VB6 app author you would repeat the error while the app is running in the Visual Studio development system so you can examine the code and variables on the failing line. Maybe you'll see why, IF it's code related. But given a network or server issue can cause it, you may have to consider replacing hardware that is past its prime.

I've run into this more than a few times with legacy systems that started to go unstable. Perils of running old gear.

[fx.eko]

@rproffitt is it possible that this is caused by blocking the mac address on the router from the lan card, because I don't want the server to be connected to the internet

[redplanetpk]

I have usually see the server time out errors most of the time at my client website, what is the issue behind it?

[antonio78]

I've been using it for years
SQL SERVER 2014 Standard and language
VB6 programming, but only this time
get the following error:
Run-time error '-2147467259 (80004005)':
[DBNETLIB][ConnectionWrite (WrapperWrite().]General network error

Has any of you guys ever experienced this??

Yes, I have experienced this error before. It is caused by a problem with the network connection between your computer and the SQL Server database.