Posted by Shane on 05/25/07 04:04

Shane wrote:

> I am trying to write an application for a MSSQL database, using SQL
> Express, and Visual Studio (Express edition)
>
> I tried to connect to an existing database (named testing) but to no
> avail. Visual Studio claims the database does not exist.
>
> Any ideas?
> TIA
>

Sorry about that, a simple search turned it up. New problem however, when I
go to connect to it I get the following error.

Unable to open the physical file "C:\Program Files\Micrososft SQL
Server\MSSQL.1\MSSQL\Data\testing.mdf", Operating System error 32: "32(The
process cannot be access the file because it is being used by another
process.)".
An attempt to attach an auto-named database for file C:\Program
Files\Micrososft SQL Server\MSSQL.1\MSSQL\Data\testing.mdf failed. A
database with the same name exists, or specified file cannot be opened, or
it is located on UNC share.
--
It is only two weeks into the term that, in a calculus class, a student
raises his hand and asks: "Will we ever need this stuff in real life?"
The professor gently smiles at him and says: "Of course not - if your real
life will consist of flipping hamburgers at MacDonald's!"

[Back to original message]