SQL Server Performance Forum – Threads Archive
Concurrent multiuser processHi, I have a SQL express 2005 database in a Pc and another client PC.
When an VB 2005 aplication run in any of both machines no problem, but
when i intent to run it at both machines at the same time, in the
second show an error:
the file is being used by another process. The Sql is configured with MULTIUSER. Thanks for your help
I don’t think it sql error, check your VB app…
Even if the sql database/server in single user mode you get different error…
True and you need to mention where this error is generated, is it during the connection or during any update of data. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
I suppose you are using a connetion which allocates a mdf-file (attachdbfilename) from a specific location.
There is this "lovely" thing about sql2005 express edition called "Connection String for Using User instance". This feature is only available with SQL2005 express edition !! Seems to me you might be using this.