my odbc connection drops after a while. rum23 10/29/2008 10:41:01 AM I am using Access 2007 to connect via ODBC (SQL Native Client driver) to our MSSQL server 2005. Nothing wrong with the connection except that it drops after about 8 to 10 minutes. Is there a time out / keep-alive on SQL or ACCESS that needs to be set? Thanks.

Re: my odbc connection drops after a while. Stefan Hoffmann <ste5an[ at ]ste5an.de> 10/29/2008 12:20:21 PM hi, rum23 wrote: [Quoted Text] > Nothing wrong with the connection except that it drops after about 8 to 10 > minutes. > Is there a time out / keep-alive on SQL or ACCESS that needs to be set? I don't know the value for Access 2007, but Jet 4.0 has a default timeout of 600 seconds. But this should be not a problem. mfG --> stefan <--

Re: my odbc connection drops after a while. Stefan Hoffmann <ste5an[ at ]ste5an.de> 10/29/2008 12:31:12 PM Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\ODBC] "ConnectionTimeout"=dword:00000258

Re: my odbc connection drops after a while. rum23 10/29/2008 12:58:01 PM I changed the connectionTimeout value in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\12.0\Access Connectivity Engine\Engines\ODBC and that doesn't seem to help. :-( I just changed it in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\ODBC. Hopefully this will help. keeping fingers crossed! Thanks for a quick response "Stefan Hoffmann" wrote: [Quoted Text] > Windows Registry Editor Version 5.00 > > [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\ODBC] > "ConnectionTimeout"=dword:00000258 > > >

Re: my odbc connection drops after a while. "Alex Dybenko" <alexdyb[ at ]PLEASE.cemi.NO.rssi.SPAM.ru> 10/29/2008 1:44:01 PM Hi, also check this post: http://accessblog.net/2008/05/why-sql-server-drops-connection.html -- Best regards, ___________ Alex Dybenko (MVP) http://accessblog.net http://www.PointLtd.com "rum23" <rum23[ at ]discussions.microsoft.com> wrote in message news:1AFE5FB7-5899-4CAE-A342-73CBD153402E[ at ]microsoft.com... [Quoted Text] > I am using Access 2007 to connect via ODBC (SQL Native Client driver) to > our > MSSQL server 2005. > Nothing wrong with the connection except that it drops after about 8 to 10 > minutes. > Is there a time out / keep-alive on SQL or ACCESS that needs to be set? > Thanks. > >

Re: my odbc connection drops after a while. "Tony Toews [MVP]" <ttoews[ at ]telusplanet.net> 10/30/2008 1:47:19 AM rum23 <rum23[ at ]discussions.microsoft.com> wrote: [Quoted Text] >I changed the connectionTimeout value in >HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\12.0\Access Connectivity >Engine\Engines\ODBC and that doesn't seem to help. :-( > >I just changed it in >HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\ODBC. Hopefully this >will help. keeping fingers crossed! Please post back and let us know if this worked or didn't work. Thanks, Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

Re: my odbc connection drops after a while. Armen Stein <ArmenStein[ at ]R3m00v3Th1s.gmail.com> 10/30/2008 1:22:03 PM On Wed, 29 Oct 2008 13:20:21 +0100, Stefan Hoffmann <ste5an[ at ]ste5an.de> wrote: [Quoted Text] >I don't know the value for Access 2007, but Jet 4.0 has a default >timeout of 600 seconds. > >But this should be not a problem. I agree - the timeout setting shouldn't cause a drop of the connection. It indicates how long Access should wait for a response from a request. It should not affect the connection during an idle period of 8-10 minutes. It drops when the PC is idle, right? Or is it working on a query and timing out? You're not running it over a wireless connection, right? Does this happen on any other PC connected to the same database? If not, I would look at the network card and cable. Access is the "canary in the coal mine" for connection issues - sometimes it will drop before you notice it anywhere else. Armen Stein Microsoft Access MVP www.JStreetTech.com

Re: my odbc connection drops after a while. "david" <david[ at ]nospam.au> 11/1/2008 10:32:38 AM The Connection Timeout value is for dropping a connection. http://support.microsoft.com/default.aspx?scid=kb;en-us;170536 The Query Timeout value is a query property called "ODBCTimeout" The ODBCTimeout value indicates how long Access should wait for a response from a request. (david) "Armen Stein" <ArmenStein[ at ]R3m00v3Th1s.gmail.com> wrote in message news:dtcjg4didk4qrcans8eues7au785la37cf[ at ]4ax.com... [Quoted Text] > On Wed, 29 Oct 2008 13:20:21 +0100, Stefan Hoffmann <ste5an[ at ]ste5an.de> > wrote: > >>I don't know the value for Access 2007, but Jet 4.0 has a default >>timeout of 600 seconds. >> >>But this should be not a problem. > > I agree - the timeout setting shouldn't cause a drop of the > connection. It indicates how long Access should wait for a response > from a request. It should not affect the connection during an idle > period of 8-10 minutes. It drops when the PC is idle, right? Or is > it working on a query and timing out? > > You're not running it over a wireless connection, right? > > Does this happen on any other PC connected to the same database? If > not, I would look at the network card and cable. Access is the > "canary in the coal mine" for connection issues - sometimes it will > drop before you notice it anywhere else. > > Armen Stein > Microsoft Access MVP > www.JStreetTech.com >

Re: my odbc connection drops after a while. rum23 11/4/2008 2:01:01 AM Unfortunately, this is not working either. The SQLServer 2005 and ACCESS 2007 are on the same machine. No network or anything like that. I desperately need help. "Tony Toews [MVP]" wrote: [Quoted Text] > rum23 <rum23[ at ]discussions.microsoft.com> wrote: > > >I changed the connectionTimeout value in > >HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\12.0\Access Connectivity > >Engine\Engines\ODBC and that doesn't seem to help. :-( > > > >I just changed it in > >HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\ODBC. Hopefully this > >will help. keeping fingers crossed! > > Please post back and let us know if this worked or didn't work. > > Thanks, Tony > -- > Tony Toews, Microsoft Access MVP > Please respond only in the newsgroups so that others can > read the entire thread of messages. > Microsoft Access Links, Hints, Tips & Accounting Systems at > http://www.granite.ab.ca/accsmstr.htm > Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ >

Re: my odbc connection drops after a while. rum23 11/4/2008 2:03:02 AM Nope, there is no wireless connection or anything like that.....ACCESS and SQLServer is on one machine (developer's machine) This doesn't happen in any other machines. Just my unlucky machine :-( "Armen Stein" wrote: [Quoted Text] > On Wed, 29 Oct 2008 13:20:21 +0100, Stefan Hoffmann <ste5an[ at ]ste5an.de> > wrote: > > >I don't know the value for Access 2007, but Jet 4.0 has a default > >timeout of 600 seconds. > > > >But this should be not a problem. > > I agree - the timeout setting shouldn't cause a drop of the > connection. It indicates how long Access should wait for a response > from a request. It should not affect the connection during an idle > period of 8-10 minutes. It drops when the PC is idle, right? Or is > it working on a query and timing out? > > You're not running it over a wireless connection, right? > > Does this happen on any other PC connected to the same database? If > not, I would look at the network card and cable. Access is the > "canary in the coal mine" for connection issues - sometimes it will > drop before you notice it anywhere else. > > Armen Stein > Microsoft Access MVP > www.JStreetTech.com > >