Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with connection to sql server from excel
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with connection to sql server from excel
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 "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
RTD Server question, Excel to Excel connection | Excel Programming | |||
SQL Server (2005 or other) - Permissions on Views Excel Connection | Excel Programming | |||
Excel VBA connection to SQL Server using ADO | Excel Programming | |||
Populate QueryTable Using SQL Server - Connection Problem | Excel Programming | |||
ADO connection problem when using server | Excel Programming |