Archive for September, 2012
Oh yes..! Finally I have installed Windows 8 release preview with dual boot on my laptop! I have faced several issues while installing Windows 8 on separate partition, but the following issue gave me a very bad experience!
“Windows cannot be installed to this hard disk space. The Partition contains one or more dynamic volumes that are not supported for installation”
I have tried my best to keep my previous Windows 7, but I could not convert dynamic volumes to Basic volumes without deleting them. So I have formatted and installed both operating systems from the scratch! 😦 If you face any problem like this just try this and this! 🙂
Okay, here are some nice screen shots from Windows 8 release preview!
1. Dual boot screen, we can choose either 7 Or 8 within 60 secs
“The .Net Framework installed on this machine does not meet the minimum required version: 4.5.50709” Visual Studio 2012
I wanted to develop a metro style application using Visual Studio 2012 on Windows 8 and I have already installed the Windows 8 release preview on my laptop! (Dual boot with Windows 7, you can see some screen shots here :)). I was trying to install the Visual Studio 2012 express edition and I have got the following error message! 🙂
I have spent few minutes on the web and found out there are some versions conflict, so we have to choose the correct version with operating system! ( The latest Visual Studio RTM versions won’t install on Windows 8 Release Preview)
So I need to install either one of the RC versions of Visual Studio OR the 90 day evaluation version of Windows 8 version! I will choose the Microsoft Visual Studio Express 2012 RC for Windows 8!
That’s all guys! Happy Installing..!
I have selected all the features including SSRS and SSIS, and the event log was showing like below.
After spending few minutes on the web, I realized the problem with my performance counters and I wanted to rebuild it on my laptop. Here is the steps to rebuild the performance counters!
Step 1: Open the command prompt (Make sure to Run As Administrator otherwise you will get an error :))
Step 2: Enter the “LODCTR /R” command and hit Enter key
You will be getting the following success message!
That’s all, try to install the SQL Server again, No problem at all!
Accessing the data from the database Or some other external data source and display on a SharePoint site is not a big deal these days. As developers we can create a web part and deploy it on the SharePoint but without writing any code, how we can display? BDC is the way to do so…!
Business Data Catalog
I am going to use very basic steps to create the BDC on my SharePoint 2007. If you want to create from the scratch without using any tools such as Application Definition Designer then you can follow this post.
These are the simple 4 steps I am going to use:
- Create a table and insert some values in SQL Server database
- Create an ADF using Application Definition Designer
- Import the ADF file into the Shared Service Provider(SSP)
- Configure the BDC on SharePoint
CREATE A TABLE AND INSERT SOME VALUES IN SQL SERVER DATABASE
You can see this post to create a sample database and we will retrieve this data using BDC. I have named Database1 and Table1
CREATE AN APPLICATION DEFINITION FILE (ADF) USING APPLICATION DEFINITION DESIGNER (ADD)
You can see this post to create an ADF sample and the file name is ADF_Table1
IMPORT THE ADF FILE INTO THE SHARED SERVICE PROVIDER (SSP)
Go to Central Administration (CA) and click your shared service provider (SSP) (Mine is SharedServices2)
Click Import application definition in the Business Data Catalog section
Click Browse, and select the ADF which we have created in the previous step
Click OK to finish the process!
If you want to manage the security just click the manage permissions and do so, that’s all we are done with the step 3! 🙂
CONFIGURE THE BDC ON SHAREPOINT
The last step is to use the Business Data List Web Part to show our data, go to any site and add a Business Data List Web Part to the page.
Open the tool pane
In the Business Data List task pane, click the browse button
The following Business Data Type Picker popup window will appear, you could see our Application Data File, Select the ADF_Table1_Instance
Click OK and publish the page, you can see the data on the web part!
That’s all guys! Happy BDC ing, we will see next BCS on SharePoint 2010! Ensoy..!!
What is ADF?
This is an XML file that describes your data source, how to connect to it, and the various queries, actions, and filters to display and sort the data. There are many way to create this ADF such as Application Definition Designer (ADD) and BDCMetaMan, I am going to use ADD to create the ADF.
Okay, we will see the steps here:
1. Installing and configuring the “Application Definition Designer” tool.
Please follow the steps in my previous post.
2. Creating the ADF using Application Definition Designer
Step 1: Open the ADD start –> programs –> Application Definition Designer
Step 2: You will be getting the designer and click on “Add LOB System”
Step 3: Then click on Connect to Database, you will be getting this dialog box to select the DB connection
Step 4: Choose connection type and enter connection string (I have created a database sample for this, you can see here)
Connection Type: SQL Server Connection String: “Data Source=<ServerName>;Initial Catalog=Database1;Integrated Security=True”
Step 5: Click Connect button and you will be getting this window
Step 6: Click Add table tab and drag & drop the Database1.dbo.Table1 on the Design Surface
Step 7: Click Ok and then you will prompt to get the name of LOB, enter the name and click OK (I have given ADF_Table1)
Step 8: You will get the screen like this
Please note: We need to do few modifications to complete this task, otherwise we will be getting the following error when we use this ADF on the SharePoint1 😦
“There are no Business Data Types loaded in the Catalog – Business Data Type Picker”
I have a post about this error in my previous article, please check it out.
Step 9: So Expand “FindAll_[Database1].[dbo].[Table1]” node under Methods and click Instances
In the Instances node click “FindAll_[Database1].[dbo].[Table1]_Instance” and you can see the properties of this method.
You can see the “MethodInstanceType” property has “IdEnumerator” method instead of the “Finder”. So just click the drop down list and select the Finder method.
Step 10: That’s all we done with the ADF now, just click the export button and get the file
You can see the ADF (xml) file now 🙂
This is for my testing and re-blogging purpose, I just want to create a database table and then insert few values. The reason I need this database, to create a BDC (Business Data Catalog) in SharePoint 2007. If anyone need to create a sample database then you can simply execute these scripts. 🙂
Step 1: Create a database
CREATE DATABASE Database1
Step 2: Create a Table
CREATE TABLE Table1( Column1 int Primary Key NOT NULL, Column2 varchar(10) )
Step 3: Insert values into the table
INSERT INTO Table1 (Column1, Column2) VALUES (1, 'A') INSERT INTO Table1 (Column1, Column2) VALUES (2, 'B') INSERT INTO Table1 (Column1, Column2) VALUES (3, 'C') INSERT INTO Table1 (Column1, Column2) VALUES (4, 'D') INSERT INTO Table1 (Column1, Column2) VALUES (5, 'E') INSERT INTO Table1 (Column1, Column2) VALUES (6, 'F')
That’s all, we will execute these two scripts (1 and then 2)
IF NOT EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'Database1') CREATE DATABASE Database1 GO
Use Database1 GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'Table1')) CREATE TABLE Table1( Column1 int Primary Key NOT NULL, Column2 varchar(10) ) GO INSERT INTO Table1 (Column1, Column2) VALUES (1, 'A') INSERT INTO Table1 (Column1, Column2) VALUES (2, 'B') INSERT INTO Table1 (Column1, Column2) VALUES (3, 'C') INSERT INTO Table1 (Column1, Column2) VALUES (4, 'D') INSERT INTO Table1 (Column1, Column2) VALUES (5, 'E') INSERT INTO Table1 (Column1, Column2) VALUES (6, 'F') GO
Copy and Paste these scripts in a Query Analyzer and execute from the menu or just press F5 to run the script!