Custom library Use

When I had used SQL2K5 Sept. CTP there was an issue using custom .net framework 2.0 library. I had to register the library in GAC + had to copy the dll into .Net framework 2.0 folder structure. I understand why we need to copy the dll on the development box so we can build packages, but why do I need to copy the dll in framework folder for production environment. Should GAC registration be enough?

If this is a feature, what's the purpose of registering the dll in GAC if it requires it to be in folder hierarchy. Especially in .net framework 2.0 so that the reference dialog box can display the component.

The question is if I have custom dll how do I deploy it so that it works with the package? How can I use the same dll in development environment without having to copy it in .net framework folder?

You need to put the DLL in the Framework folder if you are calling it from a script task or script component. You only have to do this on your development workstation.

More info here: http://blogs.conchango.com/jamiethomson/archive/2005/11/02/2341.aspx

-Jamie|||

The DLL should be in Frameworks folder at runtime only if the script task's or component's PreCompile option is set to FALSE. In this case the script is compiled at runtime, and the dependency needs to be in the Frameworks folder due to VSA limitations.

In default case when PreCompile is TRUE, the DLL only needs to be deployed to GAC at runtime.

|||That was it. I found a script task that did not have PreCompile set to True.

Thank you.

Custom Desktop Application

Hi All,

Today we are very pleased to announce the CTP release of Microsoft SQL Server 2005 Everywhere Edition Access Database Synchronizer (ADS) for which many of you been waiting eagerly. To download the product you can visit the SQL Server Mobile Edition/SQL Server Everywhere Edition product page or click on this link to Access Database Synchronizer reach the download page directly.

Access Database Synchronizer provides a way to synchronize data between Microsoft Access database on a desktop and Microsoft SQL Server 2005 Everywhere Edition database on a device.

For more details you can visit our blog - http://blogs.msdn.com/sqlservereverywhere/archive/2006/08/29/729730.aspx

I urge you all to install and try out the solution. We look forward to you providing us feedback about this solution so that we can make it better and as close to customer’s requirements as possible.

You can provide us feedback at SQL Server Mobile Edition/SQL Server Everywhere Edition MSDN Forum or SQL Server Everywhere Edition Blog - Microsoft SQL Server 2005 Everywhere Edition Access Database Synchronizer (ADS) or email me directly manish.agnihotri@.microsoft.com

Thanks,

Manish

Manish Agnihotri, Program Manager, SQL Server 2005 Everywhere Edition

Good news. But I want to know wherether this ADS can sync over air (Wi-Fi / TCP/IP) by Dll ?

Thanks

|||

Hi

Great news but what about SQL Express

Most serious developers dont touch Access

1. Can we modify this to access sql express

2. Or can we do SQL Everywhere synch to another SQL Everywhere database

Thanks

|||

No, you cannot sync over the air. One needs to establish a USB Active sync connection to sync

Regards

Manish

|||

No this cannot be modified to work with SQL Express or SQL Server Everywhere on desktop. This solution is targeted for Microsoft Access only. We had a big ask for this feature from developer community

Regards

Manish

|||

It is so strange that I can't use this tool to convert Access database into SQL mobile database?

I can't find any "Destop Data Sync Wizard" under Start--> Programs. (the readme file tells me to look for this)

The file I installed is SyncWithAccess-EN.msi

|||

Finally, after looked through the posts here, I understand now, I need to compile that sample program then use it. But when I try to open the project, it prompts me an error:

Error retrieving information from user datastore. Platform not found.

Then it said:

The project could not be opened because it refers to a device platform that does not exist in your datastore.

I already installed the WM5 Emulator, when I tried to use Visual Studio to connect to the "WM5 Device", it said sucessfully connected.

I don't have a WM5 PDA yet. The Visual Studio.net 2005 product I installed includes: VB, C#, VC++. I never used C# or VC++ though.

Can anyone tell me what is wrong?

Thanks!

|||

Try installing this:

http://www.microsoft.com/downloads/details.aspx?FamilyID=83a52af2-f524-4ec5-9155-717cbe5d25ed&DisplayLang=en

and this:

http://www.microsoft.com/downloads/details.aspx?FamilyID=dc6c00cb-738A-4B97-8910-5cd29ab5f8d9&DisplayLang=en

Thanks,

Laxmi

|||Consider that SQL Compact is designed to be used "Everywhere" shouldn't you spend a little time designing a device to desktop 1-to-1 sync capability?

Currently most of my work is done on larger Mobile > SQL 2000 / 2005 merge applications, but I would like to leverage the embeddable capabilites of SQL Compact to build a desktop app that communicates to a single mobile device.

Using Access is not desireable. I don't mind that I would be limited to an ActiveSync connection, since only one device / one desktop is the core design consideration I am looking at. I'd would just rather avoid Access. Given the direction that SQL Compact is taking, it looks like the long term idea is to replace the Access engine anyway, why not throw us a bone...

Also, after reading up on the Access sync, it looks like it works very similar to merge replication anyway. Except instesad of running in IIS, it runs as its own service. Thats fine too.. But SQL > SQL is better.

Please let us know if SQL Compact > SQL Compact sync is in the works.|||
Is

there any chance that we could see a sample app or sample code

demonstrating how one might go about creating "Custom Desktop Sync App"

using ADS? There is a very brief explanation on how to do it on the

ADS Readme file which says something about using “ssevas31.dll" and the

ListenSyncRequest but I have not been successful in figuring it out.

Thanks!

Mike|||

I was getting the same message...

"Error retrieving information from user datastore. Platform not found."

... when opening the solution, until I added the WM5 SDK to my machine that alrady had VS2005 Sp1 on it.

However...

The ADS Wizard doesn't seem to be working at all.

My WM5 PPC phone has CF2, SQL CE 3, and the ADS Wizard. All installed without a problem. Laptop's Access 2003 is at SP2. Northwinds file is in c:\

When I go to the phone and connect to the access DB, it returns "Unspecified error [sqlceca30.dll]"

We are terribly interested in understanding more, and would like to see this working.

Anyone?

Cheers

A1ex wrote:

Finally, after looked through the posts here, I understand now, I need to compile that sample program then use it. But when I try to open the project, it prompts me an error:

Error retrieving information from user datastore. Platform not found.

Then it said:

The project could not be opened because it refers to a device platform that does not exist in your datastore.

|||

Have you installed the SQL CE replication components: Either sqlce30.repl.phone.wce5.armv4i.CAB for SmartPhone (non touch screen) or sqlce30.repl.ppc.wce5.armv4i.CAB for PocketPC (touch screen). Sqlceca30.dll is included in these components (see http://www.microsoft.com/sql/editions/sqlmobile/installsdk.mspx)

|||Hi!

I have the following problem: the program runs perfectly in all cases, when my computer is connected to the LAN, without LAN connection the "A request to send data to the computer running IIS has failed" error presents. All settings are the same, IIS is running on the computer, from the computer I can see the http://(computer-name):1024 page... so the service is also running. How can I solve this problem, is there any solution for this? I'm using the program on a laptop, so it's needed....
Thanks|||

Have you added a firewall exception for the default port 1024 which ADS uses for communocating with the device? If not, adding the exception should solve your problem

|||

í can′t find the "Desktop Data Sync Wizard" either, i have installed the ADS without problems, but once done it, can′t find a way to configured it. I have installed it in a Windows XP Professional SP2 with MS Office 2003 and in the mobile device i′m running Windows CE 5.0. What i′m trying to do is to Sync an SDF database with MS Access 2003 in my PC. Is this posible? Should i installed in my PC or into the device or in both? Thank you very much for your help.

Regards,

Roberto.

Custom assemblies in July CTP 2005

Hi,
I was just trying to test my new custom assemblies on 2005 CTP July
version (I think). The usual directories are not there. I looked up
the documentation and the directories the documentation told me to put
the custom assemblies in are also not there...
Does anyone know where I should put the dll for custom assemblies for
2005 July CTP?
Thanks
Peter
www.peternolan.comI highly recommend downloading the September CTP. Especially if you are
using Reporting Services.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Peter Nolan" <peter@.peternolan.com> wrote in message
news:1127598946.821023.209470@.f14g2000cwb.googlegroups.com...
> Hi,
> I was just trying to test my new custom assemblies on 2005 CTP July
> version (I think). The usual directories are not there. I looked up
> the documentation and the directories the documentation told me to put
> the custom assemblies in are also not there...
> Does anyone know where I should put the dll for custom assemblies for
> 2005 July CTP?
> Thanks
> Peter
> www.peternolan.com
>|||Regarding custom assemblies on RS 2005 - please check the updated online
documentation for RS 2005: http://msdn2.microsoft.com/en-us/library/ms225486
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:O4KuhwWwFHA.900@.TK2MSFTNGP11.phx.gbl...
>I highly recommend downloading the September CTP. Especially if you are
>using Reporting Services.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Peter Nolan" <peter@.peternolan.com> wrote in message
> news:1127598946.821023.209470@.f14g2000cwb.googlegroups.com...
>> Hi,
>> I was just trying to test my new custom assemblies on 2005 CTP July
>> version (I think). The usual directories are not there. I looked up
>> the documentation and the directories the documentation told me to put
>> the custom assemblies in are also not there...
>> Does anyone know where I should put the dll for custom assemblies for
>> 2005 July CTP?
>> Thanks
>> Peter
>> www.peternolan.com
>|||Hi Bruce,
thanks...I got a note from dundas on their new beta and it being
recommended on the september CTP.....but I am travelling again so I
will fetch all the 'new stuff' next time I on my own dime...
Thanks
Peter|||Hi Robert,
I followed the documentation you pointed to and copied my custom
assembly as put new code groups into the config files as specified..I
still get the message 'The application for BI4ALL.rptproj is not
installed' when I try to open up my visual studio project.....I have
an old version and the only difference is the custom assembly (I
believe).
Do you (or anyone else) have any ideas what else I might have to do?
Thanks
Peter
To deploy a custom assembly in Reporting Services
Copy your custom assembly from your build location to the report server
bin folder or the Report Designer folder. The default location of the
bin folder for the report server is C:\Program Files\Microsoft SQL
Server\MSSQL.3\Reporting Services\ReportServer\bin. The default
location of the Report Designer is C:\Program Files\Microsoft Visual
Studio 8\Common7\IDE\PrivateAssemblies.
If you need to grant your custom assembly code permissions beyond the
default execute permissions:
Open the appropriate configuration file. The default location of
rssrvpolicy.config is C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\ReportServer. The default location of
rspreviewpolicy.config is C:\Program Files\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies.
Add a code group for your custom assembly. For more information, see
Understanding Code Access Security in Reporting Services.
<CodeGroup class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Name="MyCodeGroup"
Description="Code group for my data processing extension">
<IMembershipCondition class="UrlMembershipCondition"
version="1"
Url="C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\bin\Microsoft.Samples.ReportingServices.FsiDataExtension.dll"
/>
</CodeGroup>|||What do you mean with you "have an old version"? RS 2005 report projects
require the installation of BI Development Studio to open successfully. Can
you create report projects without custom assemblies in BI Development
Studio successfully?
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Peter Nolan" <peter@.peternolan.com> wrote in message
news:1127651973.385470.44280@.g49g2000cwa.googlegroups.com...
> Hi Robert,
> I followed the documentation you pointed to and copied my custom
> assembly as put new code groups into the config files as specified..I
> still get the message 'The application for BI4ALL.rptproj is not
> installed' when I try to open up my visual studio project.....I have
> an old version and the only difference is the custom assembly (I
> believe).
> Do you (or anyone else) have any ideas what else I might have to do?
> Thanks
> Peter
> To deploy a custom assembly in Reporting Services
> Copy your custom assembly from your build location to the report server
> bin folder or the Report Designer folder. The default location of the
> bin folder for the report server is C:\Program Files\Microsoft SQL
> Server\MSSQL.3\Reporting Services\ReportServer\bin. The default
> location of the Report Designer is C:\Program Files\Microsoft Visual
> Studio 8\Common7\IDE\PrivateAssemblies.
> If you need to grant your custom assembly code permissions beyond the
> default execute permissions:
> Open the appropriate configuration file. The default location of
> rssrvpolicy.config is C:\Program Files\Microsoft SQL
> Server\MSSQL\Reporting Services\ReportServer. The default location of
> rspreviewpolicy.config is C:\Program Files\Microsoft Visual Studio
> 8\Common7\IDE\PrivateAssemblies.
> Add a code group for your custom assembly. For more information, see
> Understanding Code Access Security in Reporting Services.
>
> <CodeGroup class="UnionCodeGroup"
> version="1"
> PermissionSetName="FullTrust"
> Name="MyCodeGroup"
> Description="Code group for my data processing extension">
> <IMembershipCondition class="UrlMembershipCondition"
> version="1"
> Url="C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer\bin\Microsoft.Samples.ReportingServices.FsiDataExtension.dll"
> />
> </CodeGroup>
>|||Hi Robert,
yes, projects without custom assemblies are fine..
What I meant was I have a version of our reports with no custom
assemblies and they upgrade and can be previewed in BI Dev studio just
fine...they can also be deployed to reporting services web server just
fine....
When I try to copy the version of our reports with the Custom Assembly
across to 2005 I get the message 'The application for BI4ALL.rptproj is
not installed' when I try to open up my visual studio project.....So,
I am guessing it is still the CA...
I have gone through all the steps in the documentation referenced but
still cannot get the project to open...
So, I am looking for hints as to whether it is the CA and if so how I
might get it it work..
Thanks
Peter|||Hi All,
I am still working on this...Has anyone else got custom assemblies
working on July CTP for SQL Server?
Thanks
Peter|||Hi All,
thought I would add my latest efforts to trying to get my reports to
migrate across. I have got my custom assembly working on 2005...I was
able to add the custom assembly to the old version of my project and
have it run and work...so I no longer think my error message is related
to the customer assembly.
I searched this group for the message 'The application for project
'xxx.rptproj' is not installed. Make sure the application for the
project type (.rptproj) is installed.
I found this entry on the group about clearing public and private cache
but how do I clear these caches?
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/7e68c4de6af07a72/7bed68d9e4214e23?q=make+sure+application+for+project+type+is+installed&rnum=1&hl=en#7bed68d9e4214e23
All ideas most welcome!!!
How did I get custom assemblies to work you may ask...
Well on CTP July.
I cannot find:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer
I can only find...
D:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportServer
where the following config files reside...
rsreportserver.config
rssrvpolicy.config
web.config
http://msdn2.microsoft.com/en-us/library/ms225486
says the following...
To deploy a custom assembly in Reporting Services
Copy your custom assembly from your build location to the report server
bin folder or the Report Designer folder. The default location of the
bin folder for the report server is C:\Program Files\Microsoft SQL
Server\MSSQL.3\Reporting Services\ReportServer\bin. The default
location of the Report Designer is C:\Program Files\Microsoft Visual
Studio 8\Common7\IDE\PrivateAssemblies.
If you need to grant your custom assembly code permissions beyond the
default execute permissions:
Open the appropriate configuration file. The default location of
rssrvpolicy.config is C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\ReportServer. The default location of
rspreviewpolicy.config is C:\Program Files\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies.
Add a code group for your custom assembly. For more information, see
Understanding Code Access Security in Reporting Services.
So I added these entries to my config files...
Snipped from my rssrvpolivy.config file..
<CodeGroup class="FirstMatchCodeGroup" version="1"
PermissionSetName="Nothing">
<IMembershipCondition class="AllMembershipCondition"
version="1" />
<CodeGroup class="UnionCodeGroup" version="1"
PermissionSetName="FullTrust" Name="IBIRSCustomClass"
Description="IBIRSCustomClass">
<IMembershipCondition class="UrlMembershipCondition"
version="1" Url="D:\Program Files\Microsoft SQL
Server\MSSQL.3\Reporting
Services\ReportServer\bin\IBIRSCustomClass.dll"/>
</CodeGroup>
<CodeGroup class="UnionCodeGroup" version="1"
PermissionSetName="Execution"
Name="Report_Expressions_Default_Permissions" Description="This code
group grants default permissions for code in report expressions and
Code element. ">
<IMembershipCondition
class="StrongNameMembershipCondition" version="1"
PublicKeyBlob="0024000004800000940000000602000000240000525341310004000001000100512C8E872E28569E733BCB123794DAB55111A0570B3B3D4DE3794153DEA5EFB7C3FEA9F2D8236CFF320C4FD0EAD5F677880BF6C181F296C751C5F6E65B04D3834C02F792FEE0FE452915D44AFE74A0C27E0D8E4B8D04EC52A8E281E01FF47E7D694E6C7275A09AFCBFD8CC82705A06B20FD6EF61EBBA6873E29C8C0F2CAEDDA2"
/>
</CodeGroup>
Snipped from my rspreviewpolicy.config file...
<CodeGroup class="FirstMatchCodeGroup" version="1"
PermissionSetName="Nothing">
<IMembershipCondition class="AllMembershipCondition"
version="1" />
<CodeGroup class="UnionCodeGroup" version="1"
PermissionSetName="FullTrust" Name="IBIRSCustomClass"
Description="IBIRSCustomClass">
<IMembershipCondition class="UrlMembershipCondition"
version="1" Url="D:\Program Files\Microsoft SQL
Server\MSSQL.3\Reporting
Services\ReportServer\bin\IBIRSCustomClass.dll"/>
</CodeGroup>
<CodeGroup class="UnionCodeGroup" version="1"
PermissionSetName="Execution"
Name="Report_Expressions_Default_Permissions" Description="This code
group grants default permissions for code in report expressions and
Code element. ">
<IMembershipCondition
class="StrongNameMembershipCondition" version="1"
PublicKeyBlob="0024000004800000940000000602000000240000525341310004000001000100512C8E872E28569E733BCB123794DAB55111A0570B3B3D4DE3794153DEA5EFB7C3FEA9F2D8236CFF320C4FD0EAD5F677880BF6C181F296C751C5F6E65B04D3834C02F792FEE0FE452915D44AFE74A0C27E0D8E4B8D04EC52A8E281E01FF47E7D694E6C7275A09AFCBFD8CC82705A06B20FD6EF61EBBA6873E29C8C0F2CAEDDA2"
/>
</CodeGroup>
And then it all seems to work ok.... :-)
Hope this helps someone else :-)
Peter
www.peternolan.com