Re: web app for RDA pull

From: Carlo (c.allegretti_at_multimodo.it)
Date: 03/12/04 

Date: Fri, 12 Mar 2004 14:44:42 +0100

I explain better my question.
I have a CE device with web server and SQL CE components installed.
On this device I can already do a pull from a VB.NET application but I want
to do it also from a asp file using IIS.
So what I think is that if the device has all components to do pull from VB
it would be possible to do it also from asp web application.
Is this correct ?

I tried to put this code in a asp file and run it with internet explorer but
it can't run.

<%
        If System.IO.File.Exists("\My Documents\test.sdf") Then
            System.IO.File.Delete("\My Documents\test.sdf")
        End If

        Dim engine As New SqlCeEngine("Data Source = \My
Documents\test.sdf")
        engine.CreateDatabase()
%>

If it is possible can I have a code example ?

Carlo

"Kevin Collins [MS]" <kevincol@online.Microsoft.COM> ha scritto nel
messaggio news:%23jAbQA5BEHA.3796@TK2MSFTNGP10.phx.gbl...
> Currently SQL Server CE client agent (which is necessary to do an RDA
PULL)
> is only available for WindowsCE.NET and PocketPC devices.
>
> So, it is not currently possible to do a pull on a IIS server.
>
> In the next release we will be offering a version of SQL Server CE that
will
> allow a user to do an RDA pull from a desktop machine, but ASP is not
> something that is currently planned for support in our next release.
>
>
> "Carlo" <c.allegretti@multimodo.it> wrote in message
> news:uYxOCF2BEHA.3784@TK2MSFTNGP10.phx.gbl...
> > Is it possible to create a web app to do RDA pull ?
> > In details, I have a CE device with IIS and SQL Server CE support and
> first
> > I would like to create an asp file to create the sdf database on the CE
> > device, then create other asp files to control via web a RDA pull.
> >
> > I see only .net applications with create and pull examples, can anybody
> help
> > me to find some web (.asp) examples ?
> >
> > Thanks
> > Carlo
> >
> >
> >
> >
> >
>
>

Relevant Pages

  • Re: Using the ISA reporting from a sql database
    ... I tried to do a report from the reports tab in ISA, ... It comes up empty like it doesnt know where to pull the information from ... since I am logging to another server into sql. ...
    (microsoft.public.isa.configuration)
  • Re: CE Emulator and RDA
    ... can you perhaps run SQL Profiler on the server to see which query ... > I am trying to make my first simple CE project that uses RDA. ... > 5) added a button to the form that executes the example pull code from CE ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Migrating away from MS-Access
    ... if you convert your Access tables directly over to SQL ... Regular SQL queries will still need to pull all the ... data down from the server before it can process it. ... SQL queries will need to be converted to stored procedures to see any ...
    (comp.databases.ms-access)
  • Empty Error Message when trying to pull Database with RDA
    ... I try to pull some tables from the SQL Server 2000 to the SQL Mobile Server 2005. ... ByVal Login As String, ByVal Password As String, _ ...
    (microsoft.public.windowsce.app.development)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)