Showing posts with label ado. Show all posts
Showing posts with label ado. Show all posts

Friday, March 23, 2012

How to use SqlCE 3.5 with in Visual Studio 2005?

Dear All,

I have downloaded Microsoft Synchronization Services for ADO.NET CTP from:

http://www.microsoft.com/downloads/details.aspx?FamilyId=75FEF59F-1B5E-49BC-A21A-9EF4F34DE6FC&displaylang=en

This download package contains the SQL Server Compact Edition 3.5 and I have installed the same. Before that I was having SqlCE 3.1 and able to work with that fine from C# application on Desktop.

After installing the new one I could see V3.1 and V3.5 folders at: C:\Program Files\Microsoft SQL Server Compact Edition\. But when I tried to create a new data connection from Visual Studio 2005, it directly making use of V3.1.

Does anybody know how to make use of this newer version in my C# application with in Visual Studio 2005 and also enabling the same in SQL Server Management Studio?

It’s an urgent requirement for me; please do spend couple of minutes in providing the solution for this.

Thanks in advance

Hi,
Can some one help me if you have a solution for the above one|||

The development environment for SQL Server Compact 3.5 is Visual Studio 2008 Beta 1. The Beta is available for download at http://msdn2.microsoft.com/en-us/vstudio/aa700831.aspx

Visual Studio 2008 Beta 1 can be installed side-by-side with Visual Studio 2005 SP1. Visual Studio 2008 Beta 1 also installs SQL Server Compact 3.5. Prior to installing Visual Studio 2008 Beta 1 uninstall SQL Server Compact 3.5 Beta.

Regards

Ambrish

Wednesday, March 21, 2012

How to use SqlCE 3.5 with in Visual Studio 2005?

Hi,

I have downloaded Microsoft Synchronization Services for ADO.NET CTP from:

http://www.microsoft.com/downloads/details.aspx?FamilyId=75FEF59F-1B5E-49BC-A21A-9EF4F34DE6FC&displaylang=en

This download package contains the SQL Server Compact Edition 3.5 and I have installed the same. Before that I was having SqlCE 3.1 and able to work with that fine from C# application on Desktop.

After installing the new one I could see V3.1 and V3.5 folders at: C:\Program Files\Microsoft SQL Server Compact Edition\. But when I tried to create a new data connection from Visual Studio 2005, it directly making use of V3.1.

Does anybody know how to make use of this newer version in my C# application with in Visual Studio 2005 and also enabling the same in SQL Server Management Studio?

It’s an urgent requirement for me; please do spend couple of minutes in providing the solution for this.

Thanks in advance

Hi,
Can some one help me if you are aware of this situation|||

Moving to CE related forums.

Have you checked whether the newest components related services are restarted successfully.

for the VS issue you might check under VS related forums.

How to use SqlCE 3.5 with in Visual Studio 2005?

Dear All,

I have downloaded Microsoft Synchronization Services for ADO.NET CTP from:

http://www.microsoft.com/downloads/details.aspx?FamilyId=75FEF59F-1B5E-49BC-A21A-9EF4F34DE6FC&displaylang=en

This download package contains the SQL Server Compact Edition 3.5 and I have installed the same. Before that I was having SqlCE 3.1 and able to work with that fine from C# application on Desktop.

After installing the new one I could see V3.1 and V3.5 folders at: C:\Program Files\Microsoft SQL Server Compact Edition\. But when I tried to create a new data connection from Visual Studio 2005, it directly making use of V3.1.

Does anybody know how to make use of this newer version in my C# application with in Visual Studio 2005 and also enabling the same in SQL Server Management Studio?

It’s an urgent requirement for me; please do spend couple of minutes in providing the solution for this.

Thanks in advance

Hi,
Can some one help me if you have a solution for the above one|||

The development environment for SQL Server Compact 3.5 is Visual Studio 2008 Beta 1. The Beta is available for download at http://msdn2.microsoft.com/en-us/vstudio/aa700831.aspx

Visual Studio 2008 Beta 1 can be installed side-by-side with Visual Studio 2005 SP1. Visual Studio 2008 Beta 1 also installs SQL Server Compact 3.5. Prior to installing Visual Studio 2008 Beta 1 uninstall SQL Server Compact 3.5 Beta.

Regards

Ambrish

Friday, February 24, 2012

How to use ADO.NET DataSets in Sql Server Reporting Services ?

Hi All,
Anybody know how to use already developed Business Layer / ADO,NET
DataSets in Sql Server Reporting Services ?
How to attach XSD containing information about Report fields same as
in ADO.NET DataSet to Report at Design time ?
Regards
AmitUsing existing datasets/bo layer requires non-trivial implementation of a
data processing extension. However, with RS 2005 and VS 2005 there will be
another option. VS 2005 delivers a winform and webform control that can work
in local mode. In local mode you are responsible for the dataset and handing
it the report (i.e. no server is involved at all).
There is no support for XSD in 2000 or 2005.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"AmitK" <amitkarnik78@.gmail.com> wrote in message
news:1126779473.203596.246570@.g49g2000cwa.googlegroups.com...
> Hi All,
> Anybody know how to use already developed Business Layer / ADO,NET
> DataSets in Sql Server Reporting Services ?
> How to attach XSD containing information about Report fields same as
> in ADO.NET DataSet to Report at Design time ?
> Regards
> Amit
>|||Hi Bruce L-C...
I have created my own DPE & get success to attach xsd to the
report. When I execute the DataSet using Generic Query Designer.. It
executes the xml file. Shows Records in Result Pane but... It does not
show Fields in Fields Pane.. Thats why I can not Design the Report...
Could you please help me ?
Regards
Amit