Win2k ICS dialing issues

[1000hours]

We are running Internet Connection Sharing (ICS) and SQL2000 on our Win2000 development server with Win98SE clients. Whenever we start our Access2000 application and it opens a oledb connection (with VBA) to our SQL server, the ICS on the sql server dials out to the internet. The app then waits for the connection to be established before continuing.

I can't figure out why it dials out. We can browse the network and hit the
server name from a command prompt without it dialing.

Anyone have any ideas?

Thanks in advance for your help.

[marquis]

Would ensuring that internet options connections is set to 'never dial a connection"?

[1000hours]

But we DO want it to dial a connection for addresses outside the network. The problem is that is shouldn't be dialing out when it hits the local address. Setting it to never dial a connection would defeat the purpose. I guess we could manually dial the connection when we wanted to use the internet.

That is an idea though, I'll try setting it to never dial a connection and see if the Access app will even start at that point.

[marquis]

Yep, that is what I meant by having to dial manually. It's how I always do it on home and office network, but just on a win98 ICS network. Then when idle fingers play with internet explorer we dont waste a phone call.

[1000hours]

ok, well I tried disabling the on-demand dialing and now the app will not start at all. It seems to require an internet connection to even startup. It just times out without a connection. I played around a bit and did discover that if I assigned a static IP to one of the machines, the app would start without an internet connection. Although, then the machine couldn't use the ICS Internet connection because ICS didn't assign that machines IP. I know that TCP/IP is configured correctly with the appropriate subnet mask and all so everything is local. I guess I may just look into other internet sharing solutions where I can have all the machines configured with static IPs. This is pretty strange really, ICS is screwy, but I guess I knew that already.