Hi
i have a database it's name is 'DrSharoof.sdf'
i have add a data source and select the the 'DrSharoof.sdf' and save the connection string
then i used the query builder wizard the final code in it is:
when i click next a message box has appear and said "Specified Method is not supported" ???
how to solve this problem ??
i try to make the same database tables with extension ".mdf"
and paste the same query builder code
and it's run successfully
so What's wrong ? please help me ...
Thanks in Advance
i have a database it's name is 'DrSharoof.sdf'
i have add a data source and select the the 'DrSharoof.sdf' and save the connection string
then i used the query builder wizard the final code in it is:
SELECT HOS_ID, HOS_NAMEFROM _HOSPITALSWHERE HOS_ID=@HospitalIDhow to solve this problem ??
i try to make the same database tables with extension ".mdf"
and paste the same query builder code
and it's run successfully
so What's wrong ? please help me ...
Thanks in Advance
5 Answers, 1 is accepted
0
Hi,
The problem you are experiencing is caused by a known bug in SQL Server Compact 3.5. In case you are interested, you can read more about this here: BUG: Error message when you try to obtain schema information from a SQL Server 2005 Compact Edition database or a SQL Server 2005 Mobile Edition database by using the SqlCeConnection.GetSchema method: "NotSupportedException"
According to our tests SqlDataSource works just fine with SQL Server Compact 4.0. It is the 3.5 version that is causing problems.
All the best,
Steve
the Telerik team
The problem you are experiencing is caused by a known bug in SQL Server Compact 3.5. In case you are interested, you can read more about this here: BUG: Error message when you try to obtain schema information from a SQL Server 2005 Compact Edition database or a SQL Server 2005 Mobile Edition database by using the SqlCeConnection.GetSchema method: "NotSupportedException"
According to our tests SqlDataSource works just fine with SQL Server Compact 4.0. It is the 3.5 version that is causing problems.
All the best,
Steve
the Telerik team
BLOGGERS WANTED! Write a review about Telerik Reporting or the new Report Designer, post it on your blog and get a complimentary license for Telerik Reporting. We’ll even promote your blog and help bring you a few fresh readers. Yes, it’s that simple. And it’s free. Get started today >
0
Tom
Top achievements
Rank 1
Rank 1
answered on 05 May 2014, 09:38 PM
Hi Steve!
But SQLCE 4.0 is not supported by my WinForms project. Or am I wrong?
Is there any chance to use SQLCE 3.5 with Telerik Reporting (Q1 2014) ?
Regards
Tom
But SQLCE 4.0 is not supported by my WinForms project. Or am I wrong?
Is there any chance to use SQLCE 3.5 with Telerik Reporting (Q1 2014) ?
Regards
Tom
0
KS
Top achievements
Rank 1
Rank 1
answered on 06 May 2014, 02:23 PM
Hi,
Q1 2013 is the last that supports .NET3.5. Use .NET4 - http://www.c-sharpcorner.com/blogs/6152/sql-server-ce-4-0-data-provider-not-available-in-visual-stud.aspx
-KS
Q1 2013 is the last that supports .NET3.5. Use .NET4 - http://www.c-sharpcorner.com/blogs/6152/sql-server-ce-4-0-data-provider-not-available-in-visual-stud.aspx
-KS
0
Tom
Top achievements
Rank 1
Rank 1
answered on 06 May 2014, 03:16 PM
Hi KS,
I'm talking about SQLCE3.5 - not the .NET-Version
I'v got a WinForms App (Telerik UI WF 2014 Q1 / .net 3.5 / VS 2010) which uses a local DB (SQLCE 3.5).
I wanted to integrate TR Reporting, which doesnt support SQLCE 3.5.
Upgrading the SQLCE from 3.5 to 4.0 (as described in the link you mentioned) enables TR Reporting, but is NOT supported by the WinForms project (only Web Projects).
So more exactly: Is there any chance to use SQLCE3.5 with TR Reporting Q3 2013?
Tom
I'm talking about SQLCE3.5 - not the .NET-Version
I'v got a WinForms App (Telerik UI WF 2014 Q1 / .net 3.5 / VS 2010) which uses a local DB (SQLCE 3.5).
I wanted to integrate TR Reporting, which doesnt support SQLCE 3.5.
Upgrading the SQLCE from 3.5 to 4.0 (as described in the link you mentioned) enables TR Reporting, but is NOT supported by the WinForms project (only Web Projects).
So more exactly: Is there any chance to use SQLCE3.5 with TR Reporting Q3 2013?
Tom
0
Hello Tom,
As of Q2 2013 Telerik Reporting is built against .NET4. Also Telerik UI for WPF Q1 2014 requires .NET 4 and later. Thus you will have to switch to SQLCE 4.0. Details about using it with Desktop applications are available in the Problems with CE4 and Windows Forms Project on VS2010SP1. Why ? msdn discussion.
You may find also helpful the following forum thread: Connect SQL Server Compact Database to Report.
Regards,
Stef
Telerik
As of Q2 2013 Telerik Reporting is built against .NET4. Also Telerik UI for WPF Q1 2014 requires .NET 4 and later. Thus you will have to switch to SQLCE 4.0. Details about using it with Desktop applications are available in the Problems with CE4 and Windows Forms Project on VS2010SP1. Why ? msdn discussion.
You may find also helpful the following forum thread: Connect SQL Server Compact Database to Report.
Regards,
Stef
Telerik
Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.