July 21, 2015 at 12:43 pm
Hello. I am trying to complete this Microsoft lesson at: https://technet.microsoft.com/en-us/library/ms167305(v=sql.110).aspx
I am on WIN 8.1 and using SQL Server 2014.
Step 1 is completed.
Step 2 is where my problem lies, I believe. Link is at: https://technet.microsoft.com/en-us/library/54405a3a-d7fa-4d95-8963-9aa224e5901e(v=sql.110)
Step 3 is completed. I copied the query but I have a problem with the optional step 6. Link is at https://technet.microsoft.com/en-us/library/ee93dfcb-8f52-4d63-b4f6-0d38e00fd350(v=sql.110)
I have created AdventureWorks2012 in the Data Sources folder.
I have created AdventureWorksDataset in the Datasets folder.
When I look at my Dataset Properties and click on the Query Designer button, I get a Query Designer window with four levels (rows) of information;
The files used in the query
The fields shown in the query
The query itself
The result of the query
Correct data appears in all the levels except for the last; No results for the query are shown. When I press the OK button, the Query Designer window goes away and another Window appears saying it could not update a list of fields for the query. Verify that you can connect to the data source and that your query is correct. , I copied the query directly from the Microsoft page in Step 3. So the connection is the problem, yes?
The connection in the Data Source Properties is “Data Source=TRACZEK-LAPTOP\\MSSQLEXPRESS;” . I eliminated the “catalogue=AdvetureWorks2012” because the data connection would not work with it.
My question is really: What should my connection be in the Data Source Properties?
Thanks for any help you can give me. Need more info, ask me. I will be gone for a few hours.
Tim
July 21, 2015 at 12:47 pm
traczek2 (7/21/2015)
Hello. I am trying to complete this Microsoft lesson at: https://technet.microsoft.com/en-us/library/ms167305(v=sql.110).aspxI am on WIN 8.1 and using SQL Server 2014.
Step 1 is completed.
Step 2 is where my problem lies, I believe. Link is at: https://technet.microsoft.com/en-us/library/54405a3a-d7fa-4d95-8963-9aa224e5901e(v=sql.110)
Step 3 is completed. I copied the query but I have a problem with the optional step 6. Link is at https://technet.microsoft.com/en-us/library/ee93dfcb-8f52-4d63-b4f6-0d38e00fd350(v=sql.110)
I have created AdventureWorks2012 in the Data Sources folder.
I have created AdventureWorksDataset in the Datasets folder.
When I look at my Dataset Properties and click on the Query Designer button, I get a Query Designer window with four levels (rows) of information;
The files used in the query
The fields shown in the query
The query itself
The result of the query
Correct data appears in all the levels except for the last; No results for the query are shown. When I press the OK button, the Query Designer window goes away and another Window appears saying it could not update a list of fields for the query. Verify that you can connect to the data source and that your query is correct. , I copied the query directly from the Microsoft page in Step 3. So the connection is the problem, yes?
The connection in the Data Source Properties is “Data Source=TRACZEK-LAPTOP\\MSSQLEXPRESS;” . I eliminated the “catalogue=AdvetureWorks2012” because the data connection would not work with it.
My question is really: What should my connection be in the Data Source Properties?
Thanks for any help you can give me. Need more info, ask me. I will be gone for a few hours.
Tim
We can't possibly tell you what the connection info should be. I have not taken the time to go looking through these links and try to determine where you may have gone wrong.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
July 21, 2015 at 1:00 pm
I believe it is working now because I do not get any window asking me to check to see if the connection works.
I added initial "catalog=AdventureWorks2012" back into the connection string.
Sorry I got too technical.
Thanks.
Tim
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply