Query Designer Not Displaying In Visual Studio 2013?
Nov 16, 2013
I've got a SQL2008 database with 2008R2 Express loaded.
In VS2012 if I right click a table and select New Query, I get the Visual Designer.
In VS2013, same database, I get a blank page
I've tried a fresh install of 2012 and 2013 onto a fresh Win8.1, same thing. SQL2012 Express, same. If I use an LocalDB option, again no tools. I've tried Ultimate to see if it's something not in Pro.
Also the "code only" query doesn't connect me to the file properly, so even if I accept doing the query by hand, I have to paste a connection string every time.
I'm expecting it to do as per VS2012, and the VS2013 pages in [URL] My database is an attached file from an ASP.NET project App_Data folder.
View 12 Replies
ADVERTISEMENT
Jan 29, 2007
In the Visual Studio Query designer against a ce 3.1 sdf file, if I type in
SELECT DATEPART(yyyy, GETDATE()) AS Expr1
FROM CropYear
The designer updates it to
SELECT [DATEPART](yyyy, GETDATE()) AS Expr1
FROM CropYear
Which results in an error
SQL Execution Error.
Executed SQL Statement: SELECT [DATEPART](yyyy, GETDATE()) AS Expr1 FROM CropYear
Error Source: SQL Server Compact Edition ADO.NET Data Provider
Error Message: There was an error parsing the query. [Token line number = 1, Token line offset = 19, Token in Error = (]
The original query works fine as long as I don't user the query designer to edit it.
The same problem occurs with DATEADD, DATEDIFF and DATENAME.
Any ideas?
Thanks
Judah
View 3 Replies
View Related
Oct 20, 2015
I'm attempting to connect to a database file through visual studio 2013 Ultimate. The .mdf file is located on my local drive inside the App_Data folder of the project. However when I try to connect to the file it fails and throws an error message (see below).
“The attempt to attach to the database failed with the following information: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 50 - Local Database Runtime error occurred. The specified LocalDB instance does not exist.”
View 8 Replies
View Related
Oct 6, 2015
I have an assignment where I am asked to create a test report with Cascaded parameters in a report for use on an Intranet. Found a good guide on a site named slqtips. The only problem is, that when I have created my data source, my data sets and my queries, I should go to the window "Report parameter properties", for specifing the data which should be included in the choices in the report, and I cannot find it! As a matter of fact the milieu I work in, Report designer in Visual Basic Studio Shell 2013, on a MS SQL 2012 Server, looks different in many way compared to the guide. It actually also differs from the Pictures in the book "Microsoft SQL Server 2012 Reporting Services" I also try to use for the purpose.Am I perhaps working in the wrong place, or what can the problem be? Is this Visual basic 2013 Window some kind of upgrade which is different from the original version where you used to work with Report designer?
View 6 Replies
View Related
Oct 28, 2015
I've used the Balanced Data Distributor with Visual Studio 2010 and SQL Server 2012 successfully. I've now installed BIDS 2013 and I'm trying to get the Balanced Data Distributor to appear again in the SSIS Toolbox.
I've installed the x86 and x64 version and it won't appear. I've tried the new version which is supposed to have a fix for some SQL Server 2008 issues but I get the message:
The installation is not successful. Check the following prerequisites: 1. Either Integration Services or BIDS has to be installed. 2. The version of these components has to be either SQL Server 2008 SP2 (or future SPs) or SQL Server 2008 R2 (or future SPs).
That seems this version only works for SQL Server 2008.
View 2 Replies
View Related
Sep 22, 2015
Basically i'm trying to create an SSIS workflow to download Sharepoint List data to SQL Server on a schedule of some kind.do we actually have to use the GAC install approach in order to get the Sharepoint List Destination and Sharepoint List Source entries to appear on the SSIS Project workflow entities?
View 4 Replies
View Related
May 25, 2008
...and Report Builder?
I have SQL Server 2005 Express and Reporting Services and Report Manager up and running...
Thanks
View 5 Replies
View Related
Nov 21, 2007
How do I install the report designer in Visual Studio 2008?
Edit: I mean, how do I install the SQLRS 2005 Report Designer in Visual Studio 2008?
View 24 Replies
View Related
Jan 18, 2007
Hi all
I have some performance issues when developing Integration Service Package ...
It is very very slow for example when I try to add new connection in
Connection Manages, it takes about 2 minutes just to open the property window.
On another pc in the same environment it works ok.
In the past I have doing a lot of SSIS Packages ... Is there any cache to empty ??
Thanks for any comments
Best regards
Frank Uray
View 8 Replies
View Related
Aug 17, 2007
Hi,
I'm building a custom Data Processing Extension (DPE), and I was hoping test it inside Visual Studio report designer, instead of doing it on the server side in Reporting Services.
Note that I have gotten the RS configuration working.
Does anyone know how to set this up for VS?
Thanks!
View 1 Replies
View Related
Jan 22, 2007
Hi all
I have some performance issues when developing Integration Service Package ...
It is very very slow for example when I try to add new connection in
Connection Manages, it takes about 2 minutes just to open the property window.
On another pc in the same environment (Domain etc.) it works ok.
In the past I have doing a lot of SSIS Packages ... Is there any cache to empty ??
Thanks for any comments
Best regards
Frank Uray
View 1 Replies
View Related
Apr 7, 2008
Hi everyone!
I'm using Microsoft Visual Studio 2005 to design reports. Is there any way to use one single image as background for a whole report-page? I only managed to set seperate background images for page header, body and footer, so the only 2 possibilities to solve this problem would be to either
* divide the image into 3 parts so that they fit exactly to the page parts or
* not use any page header and footer.
Is there another possibility that I've missed?
Any help is highly appreciated!
Thanks in advance,
Calad
View 1 Replies
View Related
Jan 21, 2008
Using SQL Server Management Studio Express 2005 for the first time and have a question. After creating a query using the Design Query, can the same query be visually modified using the Design Query again?
Seems whenever the Design Query is used again with an open query, the tool opens empty ready for a new query instead of the open query.
Thanks
View 5 Replies
View Related
Apr 29, 2008
Hello,
I know this question has been asked here before, but it was ridiculously answered : http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=98764&SiteID=1
I have a text object on my crystal report, to which I programmatically want to assign text in CS. It all works fine, except that if I have html tags in there, the text doesn't get formatted, it just displays the html tags as text as well.
Now in thread linked above, the answer was: right click the text object, and format the text object, hit paragraph text and select text interpretation to HTML. The only problem is, that for a text object, it doesn't have the text interpretation option. It's only an option for a formula field. It says so in the tech support link posted inside the post itself!!!
So if you have any idea how I can do this, please someone help me out. I am new to crystal, and there's not much helpful info on it online. I've searched for this for hours, and no solution.
Thanks
View 3 Replies
View Related
Feb 29, 2008
I have SSRS in Visual Studio. I created a query that works fine in SQL Server Management Studio, but when pasted into Visual Studio I get the error "An expression of non-boolean type specified in a context where a condition is expected, near '('.
Here is the query. Can anyone help on why this isn't working? Thanks.
SELECT CASE WHEN MONTH(dbo.MAS_CCS_ARN_InvHistoryHeader.SOTransDate) = MONTH(GETDATE()) AND YEAR(dbo.MAS_CCS_ARN_InvHistoryHeader.SOTransDate) = YEAR(GETDATE())
THEN dbo.MAS_CCS_ARO_InvHistoryDetail.SOExtChargeAmount ELSE 0 END AS CurrentMonth,
CASE WHEN SubString(dbo.MAS_CCS_GL_Account.Account,1,3) = '400' THEN 'ALEDO' ELSE ' ' END AS Location,
dbo.MAS_CCS_ARN_InvHistoryHeader.SOTransDate, dbo.MAS_CCS_ARN_InvHistoryHeader.InvoiceNumber,
dbo.MAS_CCS_AR1_CustomerMaster.CustomerName, dbo.MAS_CCS_ARO_InvHistoryDetail.DetailSeqNumber,
dbo.MAS_CCS_ARO_InvHistoryDetail.LineType, dbo.MAS_CCS_GL_Account.Account, dbo.MAS_CCS_ARO_InvHistoryDetail.SOExtChargeAmount
FROM dbo.MAS_CCS_AR1_CustomerMaster, dbo.MAS_CCS_ARN_InvHistoryHeader, dbo.MAS_CCS_ARO_InvHistoryDetail,
dbo.MAS_CCS_GL_Account
WHERE dbo.MAS_CCS_AR1_CustomerMaster.CustomerNumber = dbo.MAS_CCS_ARN_InvHistoryHeader.CustomerNumber AND
dbo.MAS_CCS_ARN_InvHistoryHeader.InvoiceNumber = dbo.MAS_CCS_ARO_InvHistoryDetail.InvoiceNumber AND
dbo.MAS_CCS_ARO_InvHistoryDetail.SOGLSalesAcct = dbo.MAS_CCS_GL_Account.AccountKey
View 1 Replies
View Related
Jan 19, 2006
I ask because I'm still looking for the source of interface problems I have in using the SSIS designer.
View 4 Replies
View Related
Mar 11, 2008
I am used to run SQL server 2005 RDBMS with Visual studio 205 for development. recently, i wanted to try it with the inbuilt sql server express and being able to run the membership query / membership functionality. the proble is that i couldn't run the query using 'aspnet_regsql' from command prompt. It always throw error. please, can anybody help me out. Any suggestion will be highly appreciated and welcome. Kayode Banjo
View 2 Replies
View Related
Jul 23, 2005
Good day. I was able to connect to a database server using SQL ServerEnterprise Manager. The Server name specified on the tree isJOMARGON(Windows NT). But no server was detected using either VisualStudio .NET and SQL Server's query analyzer.I highlighted one database (master) on the SQL Server EnterpriseManager and chose 'SQL Query Analyzer' under the 'Tools' menu. Itworked. The Title of the Query Analyzer window isSQL Server Analyzer - [Query- JOMARGON.master.JOMARGONJM Gonzalezand below on the status bar, I can seeJOMARGON(8.0) and JOMARGONJM Gonzalez(52)But again, I cannot connect manually using Query Analyzer as nothing islisted in the SQL Server drop-down listThanks
View 3 Replies
View Related
Aug 10, 2007
Our Visual Studio installation suddenly starting producing the error below upon trying to open any .dtsx package; although by "suddenly" I'm sure it was due to some Windows update or other program install, update, or uninstall. I've spent two days uninstalling, reinstalling, and repairing everything that is seemingly related to VS, but no luck. I've searched the forums and could not find this specific error mentioned, although I have tried some of the suggestions to fix possibly related 'class not registered' errors, but again no luck.
===================================
There was an error displaying the layout. (Microsoft Visual Studio)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.762&EvtSrc=Microsoft.DataTransformationServices.Design.SR&EvtID=DDSErrorDeserializeDiagram&LinkId=20476
===================================
Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)) (msddsp)
------------------------------
Program Location:
at MSDDS.IDdsDiagram.CreateShape(String ProgID, Boolean Visible, Int32 X, Int32 Y)
at Microsoft.DataWarehouse.Controls.Interop.AxMSDDS.CreateShape(String progID, Boolean visible, Int32 x, Int32 y)
at Microsoft.DataWarehouse.Design.ComponentDiagram.OnCreateShape(Object logicalObject, Int32 x, Int32 y, Boolean visible)
at Microsoft.DataTransformationServices.Design.DtsComponentDiagram.OnCreateShape(Object component, Int32 x, Int32 y, Boolean visible)
at Microsoft.DataWarehouse.Design.ComponentDiagram.CreateShape(Object logicalObject, Int32 x, Int32 y)
at Microsoft.DataTransformationServices.Design.DtrControlFlowDiagram.CreateExecutableShape(DtsContainer dtsContainer, Int32 x, Int32 y, Int32 width, Int32 height)
at Microsoft.DataTransformationServices.Design.DtrControlFlowDiagram.RefreshSequenceExecutables(IDTSSequence sequence)
at Microsoft.DataTransformationServices.Design.DtrControlFlowDiagram.AfterDeserialize()
Any help would be greatly appreciated.
TIA,
Scott
View 7 Replies
View Related
Apr 29, 2008
I am trying to send a variable selected by the user and have all of the results that match that selection show in a datagridview. I tried using this query but it gives me not result.
//code
SELECT wasteDate, wasteFeed, wasteLbs
FROM tbWaste
WHERE (wasteDate = 'date1')
//code
date1 is being set by a datetimepicker
I am getting no results when I run the program
I have tried out every different combination of ways of coding it i can think of
if anyone can help it would be greatly appriciated.
View 1 Replies
View Related
Mar 17, 2007
I have a database in my "App_Data" folder of my visual studio project. I can view it fine in Visual Studio's built-in tools for managing a database attached to a solution. However i recently started playing around with the SQL Server Management Studio Express program. When i attach my database to Management Studio, and try to run my program it crashes. I think it might be a permissions error?!? When i detatch it and reattach it in visual studio it runs fine again. Any suggestions? ThanksJason
View 1 Replies
View Related
Apr 16, 2007
I recently installed the Evaluation Edition of SQL Server 2005 x64 and it appears that MS Visual Studio 2005 is installed in stead of SQL Server Business Intelligence Development Studio. When I choose new project the only template available is "Blank Solution". How do I get all the templates (i.e. Analysis Server Project, Integration Services Project, Report Model Project, Report Server Wizard project, etc.)?
Or would it be better to uninstall MS Visual Studio 2005 and attempt to reinstall BIDS?
View 4 Replies
View Related
Sep 4, 2007
I am new to visual studio and I am still not sure of all its components and features.
I installed visual studio 2005 standard edition but cannot find SQL Server Management Studio?
I guess this must be because it is not included with Visual studio 2005 standard. Is it included with VS 2005 professional?
I want to add pictures of products to my shopping site using an SQL database and I’ve been told that SQL Server Management studio is required as it is a graphical tool.
How would I go about obtaining the SQL server management studio. There seems to be different versions of SQL server that it is confusing to know which one to purchase.
Will the SQL server 2005 version that comes with Visual studio standard be sufficient for me now right? I want to create a shopping site with hundreds, perhaps even thousands of products. I want to use an SQL server 2005 database. The database will include ‘dynamically generated’ product images if that is the correct terminology.
My goodness, it seems I still have so much to learn.
Thanks
View 1 Replies
View Related
May 13, 2008
I have created a database under management studio and i want it to be connected in visual studio but it failed
the error msgs said that the database can't be connected coz the database with same name exits but that is not true
View 2 Replies
View Related
May 21, 2008
Hi all!On a server computer, I have SQL server 2005 express edition installed, and am using that for my web server, but I want to develop the applications in Visual Web Developer on a remote machine on my LAN. This means I will have to connect VWD to the remote SQL server, to work with the databases.How do you connect VWD to a Remote SQL server?Thanks!
View 3 Replies
View Related
Sep 12, 2007
How do i get the database that i am using in visual studio into my SQL server management studio?
i need to create some scripts to create stored procedures on a live server.
View 1 Replies
View Related
Sep 13, 2006
I have installed Visual Studio 2005 which includes SQL Server Express but not the Management Studio.
Can I install SQL Server Management Studio Express?
View 1 Replies
View Related
Apr 15, 2008
I would like to break a large table into multiple pages when previewing in the designer. Any ideas?
View 10 Replies
View Related
Apr 25, 2007
I have created two tables and receive a "columns in table ... do not match an existing primary key or UNIQUE constraint." error message.
Table1: GOSMapping
PK: AuthInd (bigint)
PK: GLCode (nchar(8))
-both columns were set as PK simultaneously
Table2: GOSTracking
PK: AdjID
FK: AuthInd (bigint)
FK: GLCode (nchar(8))
I open Table2 in the designer and right click, then select Relationships. I choose both of the columns that are the PK in Table1, and set the exact fields as the FK in Table2. I get the message when trying to save this relationship. All data types are congruent, and the primary key has been set as the combination of the two PK columns in Table1. Any ideas?
View 4 Replies
View Related
Dec 11, 2007
Is there a way to display and manage Jobs in SQL Server Management Studio at the same level of detail as existed in Enterprise Manager?
In Enterprise Manager, when I clicked on Jobs, it displayed Name, Category, Enabled, Status, Next Run Date, etc. All very useful when managing many jobs. I particularly used the ability to sort my jobs by category.
In Management Studio, I click on Jobs in Object Explorer, and all I see in Object Explorer Details is Name and Status, with an icon that has a tiny read arrow that is almost invisible that apparently tells me if the job is not enabled.
I can right-click on Jobs and Manage Job Categories, which allows me to View Jobs, but that doesn't help me much unless I do a screen print so that I can go back to Object Explorer and manage the jobs that I want.
Perhaps I am missing something, but this is just one of several areas where it feels like Microsoft has made my job more difficult with this tool rather than easier.
Thanks for any suggestions that may help make this easier. Otherwise I am to the point where I'm going to have to rename all of my jobs beginning with the category so I can use the alphabetical sort.
Cliff
View 4 Replies
View Related
May 5, 2006
I'm very confused. I installed Visual Studio 2005 and thought I understood that SQL Server 2005 came with it, but it appears that it's SQL Server 2005 - Express. Can anyone tell me what I need to do in order to get Data Transformation Services loaded or the equivalent of DTS in SQL Express?
View 1 Replies
View Related
Oct 1, 2015
I created a simple procedure in SQL Server Management Studio 2014. When I run it I see my query results but not my return value. Do I have to change settings to see the return value?
CREATE PROCEDURE temp
AS
BEGIN
SELECT GetDate()
FROM mytable
RETURN 1
END
EXEC temp
View 4 Replies
View Related
Jun 17, 2008
Hi,
I am new to this environment, Can Someone help me in how to write the SSIS Packages using the Visual Studio in STEPS or using any links.
Thanks in Advance.
View 2 Replies
View Related
