View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Patrick Molloy[_2_] Patrick Molloy[_2_] is offline
external usenet poster
 
Posts: 1,298
Default Problem with connection to sql server from excel

well if multiple users are writing then they may locking out the others ....
this would cause a timeout and Excel would appear to freeze - because its
single threaded etc etc
our apps send data to a "load" table, with another column for a GUID that
excel sheets generates. when the load to the table is complete, an sp loads
any data from the load table with that guid to its target table.

"Lina" wrote:

Hi,
Has anyone had any random problems when trying to connect to a database
from excel?

I have just taken over the administration of an excel vba application that
reads and writes to a database.
It has worked ok until now but now many users sometimes have problems when
saving data. The problem for me is that I can not get the same error. It
happens for some users sometimes and I can not make any sense of it. I think
that the application stops when connectiong to the database. I wonder if this
can have anyting to do with other settings on the users computer. Can it be a
new office update, bad internet connection, to many people working with the
database at the same time or something else?
They use excel 2003 sp2 and sqlserver 2005 (I think it's sp 2)

Thanks