Hi,
This is really a Visual Studio 2005 Report Designer problem but I didn't see a good place to post this question in the Visual Studion forum.
On some reports when looking at the Data tab the Generic Query Designer is disabled. Anybody know why? The report runs. Other reports have it enabled.
I am using Visual Studio 2005 sp1.
Thanks,
Darren
Just answered my own question.
It seems the Generic Query Designer is disabled when you are using an expression for a connection string.
When I am in Visual Studio 2005, and I try to add an SQL database, I get the following error "generating user instances in sql server is disabled. use sp_configure user instances enabled to generate user instances."
I am currently using SQL server 2005 Express.
What do I need to do, to create an SQL database? Thanks in advance.
Execute this statement:
sp_configure'user instances enabled', 1;RECONFIGURE
You can execute it either from Management Studio for SQL Express (http://msdn.microsoft.com/vstudio/express/sql/download/) or from Visual Stuido (create new connection to SQL Express instance then New Query, then execute it!).
Good luck.
|||Thanks for the advice. Being so new to this, a lot of that went over my head. So I have two questions...
1. How do I create a new connection the SQL Express instance?
2. How do I execute a query after creating it? (With F5?)
Thanks for your help CS4Ever
Select theData | Add New Data Source menu command. This launches theData Source Configuration Wizard.
In theData Source Configuration Wizard, in theChoose a Data Source type step, selectDatabase and then clickNext,then complete the wizard.
Checkout this link:http://msdn.microsoft.com/vstudio/tour/vs2005_guided_tour/VS2005pro/Smart_Client/DataBinder.htm
Good luck.
|||Ok I got it to work. Thanks!