ODBC and VPN

[stindle]

Hi All, new here to forums.

I have a SQL server running on Server 2003. I also have a win2000 server being used as a warehouse server. The problem I am having is with a remote clinic.

This clinic connects thru the VPN into the main office. We connect thru a 3meg connection to a T1 1.5 meg coonection in office. I have 3 machines connecting frm this office to the main office.

The software we run is from Nextgen and is medical charting software, from within this grogram we then call up our scanning software (Impact IGN) this loads the charts for Doctors and nurses to view with each vist.

Everything is set up thru ODBC to connect to database and everyone logs into the domain just as if the where in the main office.

Both servers are running on 1 GB netcard on 3Com superstack 4200 switch , the vpn is setup on a Adtran 600R and Cisco Pix 506E in the main office and a Westell Modem and Cisco Pix 501 in the clinic.

Main office is on IP 192.169.1.X clinic is on IP 192.168.3.X


Ok now for the problem sorry for the long post so far but wanted to get all the info out first.
My problem is I think my ODBC is losing connection when I load the nextgen software and then the impact program from with in. Its not a set thing it happens 2 to 8 times a day and on diff pc's not all at once.

I will say I am not an expert with VPN nor ODBC so any help would be great. Thanks

Skip

 

[mikej336]

Does it ever connect?

Is it giving an error message?

Describe a little bit more about what is happening.

Thanks

Uncle Mike

 

[stindle]

It always connects, and will work find for 1 to several hours then I will get a database not found error and the uasal SQL/OBDC errors you get when you have been disconnected from the data base. I then have to exit the app and restart it. It then reconnects and works fine till she blows again.

My connection to the network never get disconnected just the one to the database. So I think it has something to do with my VPN, which pings with no packet drops from pixs to pixs.

 

[mikej336]

Most firewalls have a limited life on a tunnel before it is recreated. You might be hitting that limit. It may break the connection when recreating the tunnel.

Also some firewalls will periodically close a tunnel with no activity after a given period. There are programs on the net that will periodically ping thru the tunnel to keep it alive.

Either will be hard to diagnose.

Uncle Mike