Re: Problem with one table - Connection Timeout

If you don't know what the problem is you can't fix it.

You don't know what the problem is because you can't get on the server to
investigate.

Talk to the DBA again. Point out that you accept it is the application but
you need her help and some server time to investigate the problem. If she
won't help then you have to escalate it to your boss/her boss.

If you don't then you're the one who ends up looking stupid not her.

--

Terry Kreft


"Julia" <julia77a@xxxxxxxxxxxx> wrote in message
news:1149537998.137698.268810@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hello everyone,
I have an Access 2003 (2000 format) front end application with SQL 2000
back end that is being used by about 20 users on a daily basis (using
local copy of .mdb file). Ever since we migrated the data to the
company's SQL server we've been having problems with one particular
table (tblContact). We were using linked tables and ODBC connection
originally. When we tried to make any changes (additions/edits/deletes
using SQL update statements) to records in this table through Access,
there was a long
pause and then we would get the error:
ODBC--update on a linked table 'TABLENAME' failed.
[Microsoft][ODBC SQL Server Driver]Timeout expired. Once we got this
error, the table would lock and not allow for any changes. Usually it
would clear itself up after several minutes, or if we asked everyone to
log out.
So, I figured there had to be some issue with the ODBC / Jet engine and
I rewrote all the forms that added/edited contacts to use ADO
connection instead. Unfortunatelly, the problem still exists and now we
get the OLE DB error message: Connection Timeout.
Not only did it not solve the problem, but it seems like it made it
even worst as it happens now several times during the day and I hear
people complainig all the time. It drives me crazy and I have no idea
why this is happening. I guess there must be some locking going on with
this table, but why this one and how to fix it. What makes it even
worst is that I don't have the admin access to the SQL Server to run
some tools, and the lady who does administer it is a piece of work and
does not want to help at all. She says it is the application's fault,
and she can't help me. So, what am I supposed to do? Please, someone
help me, or I'll shoot myslef if I don't fix this soon (and I have 2
children at home :)



.

Relevant Pages

  • Re: accessing data mining model via web/PDA
    ... Is your OPENROWSET clause connecting to a SQL Server 2000 database? ... Is your SQL Server instance running on the same machine as your Analysis ... i need some> help for the connection string, let say to access the> mining model in the AS. ...
    (microsoft.public.sqlserver.datamining)
  • Re: VB Express SQL Express Remote Connection
    ... Yes I can connect using the SQL Server Management Studio Express Tool. ... I changed my connection to exactly what you specified and it connected. ... I can connect and create databases on the Remote Server ...
    (microsoft.public.dotnet.languages.vb)
  • Re: How to Direct connect with ActiveSync
    ... That won't work because you have a connection string that can't be correct. ... You're saying that the database is, but it's not; ... Server 2000, Visual Studio 2008. ... Again sorry if this should be in another form but you say that SQL Server ...
    (microsoft.public.sqlserver.ce)
  • Re: Communication Link Failure Error
    ... On disconnection from the network, in my code I changed the connection ... string to use SQLOLEDB and sent a SQL query to SQL server which failed as ... unplug the network cable from the client machine and put the cable ...
    (microsoft.public.data.ado)
  • .Net Scalability problem
    ... I finished a Great project using .Net and SQL Server and .Net Mobile ... Million concurrent users ... So I think that the MTC generate concurrent connection and per ...
    (microsoft.public.sqlserver.connect)
Loading