Problem with connection to sql server from excel

[Lina]

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

 

[Patrick Molloy]

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.

 

[Sam Wilson]

Hi,

Can you post the code that you're using to connect to the database? It could
be a number of things. If you're using windows authentication to connect it
could be that some users don't have sufficient rights to write etc.

Otherwise I'd look at locking

Sam