April 5, 2009 at 12:44 am
New install SQL Server 2008
New install Visual Studio 2008
OS: Vista Home Premium
All patches and updates installed.
Created db and table using SQL Server Management Tools.
When trying to access from VS using C# the db is always in use when I try to access it. Tried to reboot and access with same result.
When accessing from SQL Server Management Tool I have no problem.
Any help appreciated!
TH
April 5, 2009 at 1:24 am
Hello,
If you check the DB Properties via SSMS, what are the values in the State section e.g. is the DB in Multi or Single User Mode?
Do you have any errors in the SQL Logs that you could post? (As well as the Error Number, the Level and State can be helpful in determining the root cause).
Regards,
John Marsh
PS: Which Edition of SQL Server?
www.sql.lu
SQL Server Luxembourg User Group
April 5, 2009 at 2:00 am
tdhall_75233 (4/5/2009)
When trying to access from VS using C# the db is always in use when I try to access it.
How are you trying to access it? (C# code)
What errors are you getting?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 5, 2009 at 11:04 am
Which Edition of SQL Server?
Could you please post your connection-string (sure, without real user and password!)?
Greets
Flo
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply