EA through VPN

[PogPower]

I'm using EA 6.5.806 to connect to a SQL server database through a VPN.  Everything was working fine until I lost my connection with "EA open".

I've restarted my connection, VPN client and EA.  All my usual services (Remote desktop, Mail ... ) are working normally but EA prompt me and ask for a password when trying to connect to the same DB.  It looks like EA is not able to either find the DB or doesn't have the right credentials (I'm using the same connection string and logged under the same profile, credential should be the same???).

The only way I have been able to fix the problem was to reconnect my laptop on the LAN at the office.  Once this done, I'm able to reconnect the DB through the VPN.

I'm also able to reproduce the problem consistently.  Disconnecting VPN with EA open cause the problem.  However, everything work as expected if EA is closed followed by the VPN Client.

Anybody else encountered similar problem while using EA through VPN?  I'm looking to determine if the problem is VPN or EA related.

[PogPower]

Problem doesn't seems to occurs if I'm connecting to a mySQL database using ODBC drivers.

Apprently, it is related to OLEDB drivers.  Again, I'dont know if it is VPN or EA problem.

[Dave_Bullet]

Haven't tried, but can you get a DBA (or via Enterprise Manager yourself) - see if you have any leftover connections?  Could be the drop in the VPN isn't dropping your existing session.  I can't see how that relates to re-prompting you for your password (unless it is being smart and trying to reacquire your old session? Somehow I don't think it works that way).

Either way - Enterprise Manager might help find it.  If you can - use SQL profiler and also trace what is going on with a disconnect.  Problem here is you'll have to run it server side (otherwise when your VPN drops) so might your profiler trace.

Cheers,
David.

[PogPower]

Thank for your help.  Actually, I'm working with a DBA at my company to isolate the problem (might take few days ... I'm working for a big company :-/).  

I'll post something if we find a solution or at least the problem ....

[Martin Terreni]

I work with VPM on MSSQL2005 and it never happened to me.
Even when connection was dropped, I just reconnected and restarted EA (or just closed all diagrams and pressed on the link again) and it worked fine.

[PogPower]

Thanks, here we use SQL Server 2000 but this shouldn't make a big difference for EA.  It seems to point to a VPN configuration or OLEDB Driver problem.

[Dave_Bullet]

I wouldn't discount SQL Server 2000 as not being an issue.  It is quite possible 2005 handles disconnects more elegantly.  I even get periodic timeouts with SQL 2K on our LAN when the database server gets busy.  I haven't bothered into digging into OLEDB connection params (if any) to tweak the timeout.  You may want to have a look at that and increase?

There could be server side settings to to "hang onto" client connections if a dropout.

Cheers,
David.