You are here: Brisbane Web Design Blog
contact us

Posts Tagged ‘mysql’

Navicat MySQL 8.0.29 can’t connect to ntunnel_mysql.php Connection

Posted in Database, Troubleshooting, Windows on April 27th, 2009 by madhava – 14 Comments

UPDATE: This problem is now solved by a newer version of Navicat.
Thanks for everyones contributions to this thread and may Ntunnel rock on! :)

Navicat MySQL 8.0.29 can’t connect to ntunnel_mysql.php Connection
Error: 101 - wininet error # 126 : (Unknown WININET error)

Ok here’s a really strange one, if you’re reading this page you no doubt have the same error above as I did.

After lots of testing and Googling I have concluded the following:

- The problem is due to wininet.dll in the C:\windows\system32\ directory.
- The problem might in part be caused by Internet Explorer 8, apparently other users are reporting other similar errors since installing Microsofts latest FAIL piece of software.
- The problem seems to only effect Vista, (I am on SP1) however my Windows 7 build 7000 system was unaffected as was XP.

The solution?
People have been talking about replacing the dll with one from XP. I was hesitant to replace my Vista dlls with ones from half a decade ago. Instead I opted for the working Win7 Beta dll :)

EDIT:
If you don’t have a good wininet.dll handy, google around or download this one. Just remember I am not responsible if you damage your own system.

Download my wininet.dll from Windows 7 Beta build 7000

You will need WinRar to extract the archive

http://www.rarlab.com

It worked!

The only issue I had was actually replacing the file as it’s a system file and windows doesn’t take kindly to our kind around those parts.

I backed up my old file and then copied the Win7 version to my local machine.

The next step was to gain ownership of the file so I could replace it.

Step 1)
I downloaded a reg script which adds Right-Click “Take Ownership” functionality to your user account.
http://www.howtogeek.com/howto/windows-vista/add-take-ownership-to-explorer-right-click-menu-in-vista/
After I ran the reg file, I right clicked on the file C:\windows\system32\wininet.dll

Step 2)
To be sure, to be sure, I ran a command line ownership from my Administrator Level Command Prompt.
http://www.tech-recipes.com/rx/2204/vista_how_to_take_ownership_system_file/

takeown /f c:\windows\system32\wininet.dll

Step 3)
I then downloaded a nifty application called Replacer:
http://www3.telus.net/_/replacer/
Once running, I typed:
At the first prompt:
“C:\windows\system32\wininet.dll” <- this is my current version which must die
At the second prompt:
“C:\wininet.dll” <- this is the version I copied from my Win7 Build 7000 Beta box.
After a reboot my Navicat MySQL was connecting to ntunnel connections again.

Hooray!

Good bye: wininet error # 126 : (Unknown WININET error)
There might be some official fixes for this from Navicat and or Microsoft in the near future, but in the mean time this works.

Many of the other applications that use wininet.dll don’t seem to have problems so I am not sure what the conflict with Navicat is directly.

I have tested this on two machines now and both work great.

I am sure I won’t be the only person with Vista, IE8 and Navicat MySQL wanting to use an ntunnel connection.

Good luck!