I can tell you what I am doing... using different versions of SQL Server
as backend (SQL Server 2000 and 2005, MSDE, and Express, and MS Access):
* First: SQL 2005 Express does NOT support web services endpoints
only the full versions do.
* Keep SQL server hidden (either via firewall and perimeter network,
no remote access, windows authentication, etc.)
* Data is read & written via ASP scripts (classic or .NET) which run
under IIS
* Flex/Flash client use HTTPService to POST requests to ASP scripts
* ASP scripts handle sessions and authentication (you can either
trust IIS session management or write your own, e.g. using encrypted
cookies)
Maybe this works for you too...
--- In flexcoders@yahoogroups.com, Ray Horn <[EMAIL PROTECTED]> wrote:
>
> Yes, but doing what you suggest means you must expose your database
server to the outside world and for some this is simply unacceptable.
>
>
> ----- Original Message ----
> From: Paul Wright [EMAIL PROTECTED]
> To: flexcoders@yahoogroups.com
> Sent: Thursday, April 5, 2007 9:02:44 AM
> Subject: RE: [flexcoders] Re: Connect and Retrieve from MS SQL Server
2005
>
> This is a bit off topic
>
> The quote from this article regarding SQL Server 2005 & HTTP requests
(http://msdn2. microsoft. com/en-us/ library/ms345123 .aspx) that is
relevant here is "Any device that can parse XML and submit HTTP
requests can now access SQL Server."
>
> Enjoy!
>
> Paul
>
>
>
>
> From: [EMAIL PROTECTED] ups.com [mailto:flexcoders@ yahoogroups.
com] On Behalf Of Shaun
> Sent: Thursday, April 05, 2007 10:18 AM
> To: [EMAIL PROTECTED] ups.com
> Subject: [flexcoders] Re: Connect and Retrieve from MS SQL Server 2005
>
> The CLR is Microsoft's Common Language Runtime. It allows for
> language interoperability (write components in one language, use them
> in another, as well as many other benefits). The most common
> languages used with it are C#, Visual Basic, and managed C++
> (probably in that order - I use C#), though I believe you can use
> more than just those.
>
> You can do a google search for Microsoft CLR and find out plenty of
> additional information.
>
> Shaun
>
> --- In [EMAIL PROTECTED] ups.com, "hugocorept" hugocore@ .> wrote:
> >
> > Why i don´t choose ASP.NET ?
> >
> > Because i havent any experecience with it :P
> >
> > But i promisse i will give it a chance . Just a quick doubt, can
> you
> > give a quick knowlodge about CLR, What you all mean with "you use
> > any CLR compatible language " ? Whats the benifts ?
> >
> > Tkz for all
> >
> > --- In [EMAIL PROTECTED] ups.com, "Shaun" <sthalberstadt@ > wrote:
> > >
> > > Yes, Fluorine uses ASP.NET. So you can use any CLR compatible
> > > language. (Fluorine itself is written in C#)
> > >
> > > It also has an installer that creates a web site template project
> > and
> > > comes with samples.
> > >
> > > I highly recommend it.
> > >
> > > Shaun
> > >
> > >
> > > --- In [EMAIL PROTECTED] ups.com, "hugocorept" <hugocore@>
wrote:
> > > >
> > > > Hey many thanks
> > > >
> > > > Point 1.
> > > >
> > > > So, you in general point the new feutures of SQL Server Web
> > > Services.
> > > >
> > > > Is that suported by either Express and Full Version?
> > > >
> > > > Can someone support me with some tutorials of any kind ?
> > > >
> > > > Point 2.
> > > >
> > > > I have tried by : PHP (with result in a difficul process
> because
> > > the
> > > > DSN requirements) and ColdFusion 7 ( still in research but
> seams
> > > > pretty good)
> > > >
> > > > Point 3
> > > >
> > > > Fluorine project use witch languague ? Asp.NET?
> > > >
> > > > Thanks For All
> > > >
> > > > --- In [EMAIL PROTECTED] ups.com, "hugocorept" <hugocore@>
> > wrote:
> > > > >
> > > > >
> > > > > Hello all,
> > > > >
> > > > > In your opnion, witch is the simple/best way to connect a
> > > > MSSQLServer
> > > > > 2005.
> > > > >
> > > > > I prefer java-less..
> > > > >
> > > > > Thank you , Very Much!
> > > > >
> > > >
> > > >
> > > >
> > > >
> > > > --- In [EMAIL PROTECTED] ups.com, "iko_knyphausen" <iko@>
> wrote:
> > > > >
> > > > >
> > > > > If you are using the full version of SQL 2005 (meaning not
> > > > Express) you
> > > > > may be able to use the built-in Web Services Endpoints ...
> > Have
> > > not
> > > > > tried it myself, but I think in theory that should work.
> > > > >
> > > > > -Iko
> > > > > --- In [EMAIL PROTECTED] ups.com, "Clint Tredway" <grumpee@>
> > > > wrote:
> > > > > >
> > > > > > you can use just about any server side language
> (ColdFusion,
> > > > PHP, ASP,
> > > > > .NET,
> > > > > > etc) to connect to SQL Server
> > > > > >
> > > > > > On 3/28/07, hugocorept hugocore@ wrote:
> > > > > > >
> > > > > > >
> > > > > > > Hello all,
> > > > > > >
> > > > > > > In your opnion, witch is the simple/best way to connect a
> > > > > MSSQLServer
> > > > > > > 2005.
> > > > > > >
> > > > > > > I prefer java-less..
> > > > > > >
> > > > > > > Thank you , Very Much!
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > --
> > > > > > http://indeegrumpee .spaces.live. com/
> > > > > >
> > > > >
> > > >
> > >
> >
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.446 / Virus Database: 268.18.26/746 - Release Date:
4/4/2007 1:09 PM
>
>
>
> --
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.5.446 / Virus Database: 268.18.26/746 - Release Date:
4/4/2007 1:09 PM
>
