Re: web app for RDA pull

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Gil Lapid Shafriri (gilsh_at_online.microsoft.com)
Date: 03/27/04 

Date: Fri, 26 Mar 2004 18:00:16 -0800

Currently we don't have win32 version of our client side components (This is
on out list for the next release).
So you can't run them on the IIS machine. Also we don't think that sqlce
database should be used as a web server database. If that what you are
trying to do - you have better alternatives.
Simply use SQL SERVER or MSDE (SQL SERVER free version) and write ADO.NET in
your asp page to access the database. 

-- 
Gil Lapid Shafriri
SQL Server for CE
----------------------------------------------------------------------------
-------------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights
"Carlo" <c.allegretti@multimodo.it> wrote in message
news:uBY3xgDCEHA.3360@TK2MSFTNGP11.phx.gbl...
>
> 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: Problems with WebParts
    ... to a database called aspnetdb. ... > The connection string specifies a local SQL Server Express instance using a ... > server account must have read and write access to the applications directory. ... > This is necessary because the web server account will automatically create ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Remote development advice
    ... We are using IIS as the web server. ... The IIS and SQL Server is setup in his ... I want to be able to access the pages that my friend has done remotely ... Then whichever web site he has configured as the default site on IIS should appear, assuming the web server was configured correctly. ...
    (microsoft.public.dotnet.general)
  • Re: How to Sync Relational Data via RDA?
    ... The following code is from our app where we pull data from 3 related ... Indicates that SQL Server CE does not track changes to the pulled table. ... No PRIMARY KEY constraints are created locally. ... If you use "TrackingOffWithIndexes", the primary key and indices will be ...
    (microsoft.public.sqlserver.ce)
  • RE: Can i use embedded visual c++ 4.0 ?
    ... Please Note to pull and push, ... RDA, and RDA requires SQL Server CE on the PDA, But within your requirements ... > As you have suggested i had already downloaded the ppc 2003 sdk for evc++ 4.0 ...
    (microsoft.public.sqlserver.ce)
  • Re: SQL2K WIN2K3 CONNECTION SECURITY
    ... My own benchmarking indicates that TCP/IP is faster than named pipes. ... the benchmark stats as the starting point... ... Perfmon and SQL Server Profiler along with SQL Server Query Analyser. ... encrypted on the web server. ...
    (microsoft.public.security)