Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Spionred
Starting Member
8 Posts |
 Posted - 2007-01-22 : 16:25:56
|
Hi,I have a major problem here. Hope you guys can help.I have a VS2005 project that uses a DB I developed on and MSDE database using TOAD for SQL. A while ago I upgraded to SQL Server Express and all was well.Next I was looking to create a deployment package for both the application and BD so after a bit of reading I created a connection to the DB in my VS2005 project with the intention of making it a dependency so both app and DB could be installed in one go (maybe not the best idea L). Previously I had just been using a connection string and opening/closing the connection as and when it was needed (this app only runs for 5 minutes each night).This however has now stopped the ability to connect to the database with any of my DB development tools (Toad and the SQL management app that comes with express).When I try to connect I get the following errorTITLE: Microsoft SQL Server Management Studio Express------------------------------Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476------------------------------ADDITIONAL INFORMATION:An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)------------------------------CREATE FILE encountered operating system error 32(The process cannot access the file because it is being used by another process.) while attempting to open or create the physical file 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\CDEvolution.mdf'. (Microsoft SQL Server, Error: 5123)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.0760&EvtSrc=MSSQLServer&EvtID=5123&LinkId=20476------------------------------BUTTONS:OK------------------------------ I had a look at the connection string that VS2005 is using and it looks nothing like the standard connection string I was using previously. It seems that the action of creating the connection with VS has changed/corrupted something on the DB.To ad to my woes I also have to either change the connection string (this built using an xml file containing the all the elements of the string and parsed in allowing be to edit the string depending on the environment) to match the one VS is using or change my code to use the new connection.I would prefer to revert back to the way it was working previously and figure out a different method of deploying the software.Any thoughts?Cheers,Kevin. |
|
|
Spionred
Starting Member
8 Posts |
Posted - 2007-01-23 : 15:17:59
|
| Hi,Can anyone offer any suggestions to this problem?Cheers,Kevin. |
 |
|
|
|
|
|
Error connecting to DB