Im using Enterprise library 5.0I have a scenario, where I have to access two
different databases in my application.

Basically this application is a
webservice,delployed on my local for testing purpose.I'm trying to access
this web method from diffent windows application, default connection works fine
but the other database throw's exception.

Problem is only my
defaultDatabase is works fine, if I change defaultDatabase="MYCON1" with
"MYCON2" it works fine, if I try to access the other database which is not
default, throws exception.

Error 1 'MovieApp.Controllers.MoviesDbEntities' does not contain a definition for 'MovieSet' and no extension method 'MovieSet' accepting a first argument of type 'MovieApp.Controllers.MoviesDbEntities' could be found (are you missing a using directive or an assembly reference?) P:\experiment\MovieApp\MovieApp\Controllers\HomeController.cs 18 35 MovieApp

If I just enter return View(_entities. then Intellisense offers Equals, GetHashCode, GetType, and TosString.

We are running SQL server 2005 under WS 2003. This error is showing up in our log every time there is a select. I have looked everywhere for a solution and cannot find one that works.
DATABASE/ADO ERROR
Error Number: -2147467259
Error Description: [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite (send()).
Error Source: Microsoft OLE DB Provider for ODBC Drivers

AD Service account password was changed. Now the SQL Server Agent (MSSQLSERVER) will not start even after updating the password. Have no access into the databases. Log files say "Could not load the DLL xpstar90.dll, or one of the DLLs
it references. Reason: 126(The specified module could not be found.)." Service Account has Full rights on system. Any help in solving the problem would be great.

Hello,
On the MDW Disk Usage Collection Set report, I get the following error when I click on a database hyperlink.
A data source has not been supplied for the data source DS_TraceEvents
SQL profiler shows the following SQL statements are executed (I've replaced the database name with databaseX)
1. exec sp_executesql N'SELECT
dtb.name AS [Name]
FROM
master.sys.databases AS dtb
WHERE
(dtb.name=@_msparam_0)',N'@_msparam_0 nvarchar(4000)',@_msparam_0=N'databaseX'
this returns zero rows as databaseX does not exist on my MDW central server, but is a database on a target server (i.e. one that is being monitored and uploaded into the MDW central server).
2. USE [datatbaseX]
this produces the following error:
Msg 911, Level 16, State 1, Line 1
Database 'databaseX' does not exist. Make sure that the name is entered correctly.
why is the report looking for the database on my server?
thanks
Jag
Environment: MDW (Management Data Warehouse) on SQL 2008 R2

Hi
I have migrated to a new computer using Windows 7, 6 gig memory, I7 chip (old machine had xp) and have installed Visual Studio 2008 and SQL Server 2008 R2.
I get CREATE DATABASE permission denied in database 'master'. (Microsoft SQL Server, Error: 262) when I try to create a new database.
Other posts (example:http://social.msdn.microsoft.com/forums/en-US/sqltools/thread/28fee0ed-c7e2-40df-8f79-f513c9848f09/) work for Vista but I cannot find how to grant permissions. Run as administrator (vista fix) does not work.
I have admin privaleges on my machine. There are no other accounts.
What do I need to do to update privaleges?
Thanks and have a nice day.

One of our SQL 2005 database started to give us "Database is in transition...Error 952". We were trying to Take the DB offline when this problem occurred. Restarting SQL service did not help us. We were unable to do anything with this database as we were unable to obtain any locks. What resolved the problem? Re-starting manamgement studio on client machine. Go Figure!

Hi Guys,
The subject of this question is the error which I am receiving when running a scheduled job also this is an error which we get at a random intervals and the frequency would be once or twice in a month. I have been through several posts and didn't concluded
anything out of it. At the time when we receive this error the memory usage of the database was normal with free resources available and also the network was stable without issues.
Our Sql database is in cluster mode with named instance.
Can anyone share some information on this, I know this is not the right forum with the error message I have posted but am sure some one might have face the same problem when running some ETL jobs. Source and target both are sql server and the error message
is generated in the validation phase of the connection manager connecting to target database.
SSIS 2005 SP2
64 bit environmentRaju

I have a simple service to return a custom SOAP Fault. And here is what the service throws
MappingError me = new MappingError();
me.ErrorCode = ErrorType.OrderMappingFailed;
me.Message = "Order mapping failed";
throw new FaultException<MappingError>(me);
At this point i get an exception "The creator of this fault did not specify a reason".
LookingÃÂ around iÃÂ see there is a FaultReason(String) classÃÂ andÃÂ FaultException<> has a readonly Reason property. So, i used one of the overloaded constructor to set the FaultReason and made it work. Here is the working code
MappingError me = new MappingError();
me.ErrorCode = ErrorType.OrderMappingFailed;
me.Message = "Order mapping failed";
FaultException<MappingError> fe = new FaultException<MappingError>(me, new FaultReason("Order Guid is NULL"));
throw fe;
Now, will this be the behaviour when Winfx ships. If that be the case please update the FaultException<>ÃÂ SDK docs.
[ServiceContract]
public interface IMyService
{
[OperationContract]
[FaultContract(typeof(MappingError))]
Guid SendRequest(int ID);
}
ÃÂ
[DataContract]
public class MappingError
{
[DataMember]
public ErrorType ErrorCode;
[DataMember]
public String Message;
}

I am running SharePoint on a standalone machine, and the workstation service is up and running. Restarting the service makes no difference. Rebooting the machine hasn't helped either. No errors are being written to the event log.