473,324 Members | 2,501 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Loose connection in vpn enviroment

Hi i've this problem

I've mssql server on remote pc.
Clients connect them trought vpn connection (open vpn in bridged mode on win xp pc)
All works fine i can connect to dabase and work with my remote clients.
But at irregular time i loose the connection to the sql server but the vpn is ok

I've error tcp/ip link message and the connection is broken from server !

How can i solve thi sproblem ?
Jun 14 '07 #1
10 2771
Purple
404 Expert 256MB
Hi gpinetto and welcome to TSDN !!

what application are you using to connect to the remote SQL server ?
Does the VPN link have an auto reconnect ?
how often is this happening ?
Is the application which is losing the connection running on your machine ? Is that machine connected via wireless or hardwired ?

Regards Purple
Jun 14 '07 #2
Hi gpinetto and welcome to TSDN !!

what application are you using to connect to the remote SQL server ?
Does the VPN link have an auto reconnect ?
how often is this happening ?
Is the application which is losing the connection running on your machine ? Is that machine connected via wireless or hardwired ?

Regards Purple
Hi Purple

I write my own application in vb6 and i use ado with native client for sqlsrver 2k5

Yes the vpn auto reconnect if tunnel go down but if i start a rdp session the rdp clinet never disconnect from server trougth vpn the same with ultra vnc session.

Happning often but not periodically every the same time. The disconntion are random time. Often when i open the connection to the server and i do nothing for some minuts.

In the machine that are in the same network of server (not trought vpn) i never loose the connection.

The machine are connected trougth hardwired.

But i remember that i've got the same problem when i was connected trought wireless without vpn. (after i change the channel in the ap and i solve the problem beause i belive the channel was disturbed )
Jun 14 '07 #3
Purple
404 Expert 256MB
Hi,

Is the SQL server a live machine or a very quiet development machine ?

Could your issue be a request timeout between your VB6 client and the SQL2005 server ?

I have seen this before on slow (VPN) connections and if the SQL server has low usage.

When the SQL server has low usage, the first request can take longer than the subsequent requests, this impact is made worse when connected via vpn.

What do you think ?

Purple
Jun 14 '07 #4
The sql server machine is a live machine.
I've upgrede timeouts parameter for connection and commands but my query return few rows.
Ping then remote server is between 180 ms and 70 ms it dipends.

I've modified keep alive parameters of sql server server side and clinent side but i can't solve the problem.

I open the connection at the start of program and i close it when di close the program.

OpenCn----->Open recordset----->do nothing for minutes------> re open the same recordset -------> Connection error over tcp link------>Cnn.close---->cnn.open---->reopen recordset all ok.
But this isn't normal. I've recordset open with no rows or 1 row like this

st="Select * From Customer Where CustId=1"

set rs= new adodb.recordset
rs.cursorlocation=aduseclient
rs.open St,Dbcnn,adopenstatic,adlockoptimistic,adcmdtext


then dbcnn was opened at start of program.

When i open the recorset i've the error if cnn was boked by the remote server.

What vpn software are you use !
Jun 14 '07 #5
Purple
404 Expert 256MB
Hi,

I think you have tried most of the thoughts I had already. As a work around can you test the connection to the sql server in your vb and reconnect if it has dropped ? I know its not very pretty but it may resolve the issue..

Purple
Jun 14 '07 #6
Hi,

I think you have tried most of the thoughts I had already. As a work around can you test the connection to the sql server in your vb and reconnect if it has dropped ? I know its not very pretty but it may resolve the issue..

Purple
Hi
it's a problem reconnect the connection because i update the recordset and the preocedure that do this things check concurrency violation and toher things.

After i have more procedures that open recordset make changes and update data it self.

It's a big problem.

I think that open vpn can have some problems because with cisco vpn
i havn't problems. But in this scenario i can't use cisco.
You know another vpn solution that work fine ?
Jun 15 '07 #7
Purple
404 Expert 256MB
Hi gpinetto,

can you change the updates and compress them into one stored procedure - if there is a potential for data corruption with the connection dropping, one must assume that exposure exists if the machines crashes, or the user turns it off etc..

Regarding using other VPNs - I suspect this is a latency issue due to running across a 'slow' connection not down to the VPN technology.

Purple
Jun 15 '07 #8
Hi gpinetto,

can you change the updates and compress them into one stored procedure - if there is a potential for data corruption with the connection dropping, one must assume that exposure exists if the machines crashes, or the user turns it off etc..

Regarding using other VPNs - I suspect this is a latency issue due to running across a 'slow' connection not down to the VPN technology.

Purple
Hi Purple thi is the specific message tha i receive when i loose the connection

Errore di runtime -2147467259 (80004005)
Tcp Provider :Connessione in corso interrotta forzatamente dall'host remoto
Jun 15 '07 #9
Purple
404 Expert 256MB
Hi,

have you tried a google search on 80004005 2147467259 ? brought me back 26000 pages.. A number of areas to look at and things to try..

Purple
Jun 15 '07 #10
Hi,
Yes I tied with google i change tpc parameters of windows and sql server but i can't solve this issue
Jun 15 '07 #11

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Nikhil Barthwal | last post by:
Hi, I have a Java program that needs to access the value of variable PATH (Set in Unix enviroment by setenv or DOS enviroment by PATH statement). How do I access it in Java? Thanks in...
8
by: Steven | last post by:
I am running V8 fp 4a on a W2K Server. I generated a script from CC to backup up my database and got the following: CONNECT TO EDPACKD; QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS; CONNECT...
4
by: GAVO-UK | last post by:
Hello everyone. Using Access 2003 and MSDE I just started experimenting using Access as the front end for SQL using *.adp, and would like to connect the front end to the back end remotely,...
26
by: Rajeev Tipnis | last post by:
http://support.microsoft.com/default.aspx?scid=kb;en- us;819450 Questions: 1) Is this patch (fix) applicable to the .NET 1.1 Framework as well? That is, if we have Framework 1.1 (On...
5
by: Zlatko Matić | last post by:
Hello. In ODBC Data Source Administrator, there is a tab "Connection Pooling" and option "PerfMon" Enable/Disable. Could someone explain the meaning of the option and how it reflects to Access...
2
by: Brave | last post by:
Hi, I normally work with MS Access databases using ASP pages. I have been given the opprotunity to work on some available SQL server space, and wanted to ask a couple of questions. The following...
1
by: Chazam | last post by:
Enviroment with Problem SERVER 2003 SQL SERVER 2005 DEV C# .NET 2.0 I have a web application that works perfect on my dev machine. When I publish it to my 2003 server it display this error ...
0
by: Frank Aune | last post by:
Hello, I configure the serial connection using: self.port = serial.Serial(baudrate=57600, timeout=0.06, parity=serial.PARITY_EVEN, stopbits=serial.STOPBITS_TWO, bytesize = serial.EIGHTBITS)
2
by: Johnson | last post by:
I'm trying to fix a "sub optimal" situation with respect to connection string management. Your thoughtful responses will be appreciated. I just started with a new client who has a bunch of legacy...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.