Re: Alternate to RDA

Thanks much for the reply. Saves me a lot of time on researching.

But out of curiosity, I wonder, knowing many of the big corporations have
strict group and local policies (machine and user) rights, why was IIS chosen
as a medium.

I understand that https is a choice for safe transfer - RDA does encryption
while transferring etc etcetera.

But I personally think, there must been a way to transfer and/or talk to a
SQL installation through a "hard wire" mechanism without IIS, Something that
uses software like Active sync etc.

Thanks for your reply anways, I appreciate that.



"Ginny Caughey [MVP]" wrote:

> Boris,
>
> Other than web services (which also requires IIS or some other web server)
> I'm not aware of any other way to connect to SQL Server. Usually people in
> your situation use XML or CSV files as an intermediate format between SQL
> Server and SQL CE.
>
> Ginny Caughey
> ..NET Compact Framework MVP
>
> "Boris" <Boris@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:2BAD5402-C134-4E28-A79C-ABD5CBC9026E@xxxxxxxxxxxxxxxx
> > Greetings,
> >
> > I am trying to develop an application that synches to a desktop
> > application.
> > As far as i have researched RDA and Merge replication are the only two
> > options that i have come across. Both required IIS.
> >
> > Given the policy issues of installing IIS based application at my client
> > location, Is there no alternate way.
> > I can ask my client to always use a Active Sync to connect to the desktop
> > application. so I do NOT need any wireless or stuff like that.
> >
> > Can i not use ACTIVE SYNC or some other mode that does not use IIS to
> > connect to an SQL Server 2000 database?
> >
> > Thanks in advance
>
>
>
.

Relevant Pages

  • Re: PROBLEM: ASP on IIS 5 secured via "Windows Integrated Authentication" accessing "
    ... uses NT group based permissons on the SQL Server, ... > transfered to the IIS box and IIS does a local logon. ... > delegation for all accounts. ...
    (microsoft.public.inetserver.iis.security)
  • Re: Standalone IIS server access to sql in Domain
    ... There is no way to "trust" a domain from a non-domain machine - the only workaround is to replicate the account used on both ends. ... That means you need an account on IIS and the same account on the sql server machine. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Active sync and SQL CE
    ... IIS is a requirement for either merge replication or RDA. ... ActiveSync to play with take a look at the Data Port line of products ... These work over ActiveSync to port SQL CE databases to ... and from SQL Server 2000 and Access. ...
    (microsoft.public.pocketpc.developer)
  • Re: PROBLEM: ASP on IIS 5 secured via "Windows Integrated Authentication" accessing "
    ... You can fix the problem by using IIS 6.0 on Windows.NET with Windows.NET ... Domain Controllers using constrained delegation - but I assume this is out ... > uses NT group based permissons on the SQL Server, ...
    (microsoft.public.inetserver.iis.security)
  • dbcc utility
    ... I have a ms sql 2000 log file that has grown to 50gb in sizes. ... researching the web on how i would be able to shrink the log. ... part of the installation of SQL 2000 server or on the SQL server cd. ...
    (microsoft.public.sqlserver.server)