mibuso.com

Ok so I had this very odd situation, but it was only ever happening on Vista so I just assumed it as another one of those vista things, that would finally go away when I upgraded to XP. But now I have upgraded, and still I have the issue, so thinking through, the only other common factor is SQL 2008. So I think this is probably a SQL 2008 issue. Also this only happens on my local laptop, so it was not a critical issue. So...

Basically if I am connected to Navision (this has happened now with 5.00 sp1, 2009 SP1 RTC and Classic and 4.00sp3) and i put Navision in the background. Now if the internet connection fails (DSL connected via WiFi) then when I bring Navision back to the foreground, I get a message that the connection is lost to SQL server and Navision wants to restart.

Now if I turn off WiFi, there is no problem. Its ONLY if the connection from the router/modem to the ISP dies. I was having a lot of Internet disconnects over 5 weeks, so I was able to narrow it down and I am sure it was only when the DSL lost connection. I tried all kinds of other network disconnects with no issue.

Its happened now on XP and Vista, on two different laptops the only common thing being SQL 2008 installed locally. Also during the Internet problem stage, the ISP changed routers for a completely different brand and I had the same issue with both brands.

The only thing I never tried was pulling the phone line out to see if dropping DSL that way causes an issue.

Anyway I just can't see why the internet should disconnect Navision, its weird.

Has anyone any clue on this? Its not important, but very strange.

May be it is a problem how your router works. How the IP of your notebook is set up? Fixed IP? DHCP from router? DHCP from ISP (router request the IP from ISP and bridge it to your notebook...)? May be that when the ISP connection is lost, these settings are lost too, thus all connections are disconnected..

No I think I have eliminated those.

The issue was O2 having problems with line quality that would drop the DSL connection. Among the work they did, they changed modems 3 times, so in total there were 4 completely different modems, (the first 2 the same model, the other 2 different, so at least three completely different types of modem).

In all cases IP is DHCP from the router, and IPs were still working, and computers on the LAN could continue communicating.

It originally happened on my Vista laptop (dell), now on my XP (HP), the Dell I tried on Wifi and hard wired, the only common factor appears to be Navision and SQL 2008.

And remember I am talking about SQL and Navision on the same machine. NOT a separate server.

If I pull the modem out of the wall or turn off WiFi, it has NO effect on Navision.

It really doesn't matter, its just a local machine, but its very weird.

Oh and I tested connecting to SQL via the machine name, local host, 127.0.0.1, and 192.168.0.103 and 10.0.1.138 (my local IPs on the different routers) and every tie the result was identical.



The biggest issue I have now is that O2 found and resolved the DSL issue, so it now happens very very rarely (once a month) compared to 5-10 times a day, so I really can't test it any more.

Interesting... Question is, how NAV is connecting to the SQL - TCP/IP, Shared Memory, Named Pipes... you can check if that make some change...