[flexcoders] Re: Connecting to a sql or an access database through flex

2006-06-06 Thread Tim Hoff
Yeah,  you're right Tracy.  The HTTPService route may be better in 
this case.  Thanks for the input.

Tim

--- In flexcoders@yahoogroups.com, "Tracy Spratt" <[EMAIL PROTECTED]> 
wrote:
>
> I recommend HTTPService.  Web services are unnecessarily 
complicated if
> you have control of both client and server.  To use HTTPService, 
just
> create an aspx application with the content-type ="text/xml".  
Then use
> the .net data access objects to talk to the database, and return 
XML to
> the calling Flex client.  If your data requirements are simple 
enough,
> use FOR XML [raw, auto, explicit] in the SQL queries, and you 
won't even
> need to massage the data into xml.
> 
>  
> 
> Set resultType="e4x" in the HTTPService tag.
> 
>  
> 
> I would post an example, but my current exampl is so old, it uses 
Flex
> 1.5, and classic ASP.  I am using .net in production, but haven't
> created an example yet.
> 
>  
> 
> Tracy
> 
>  
> 
> 
> 
> From: flexcoders@yahoogroups.com 
[mailto:[EMAIL PROTECTED] On
> Behalf Of Tim Hoff
> Sent: Tuesday, June 06, 2006 11:01 AM
> To: flexcoders@yahoogroups.com
> Subject: [flexcoders] Re: Connecting to a sql or an access database
> through flex
> 
>  
> 
> Hi Rama,
> 
> Getting SQL Server or Access data into Flex isn't that difficult.
> However, it's not that easy either.  There are currently several
> different technologies that you can use to get .NET data into 
Flex. They
> include: Web Services, HTTPService, Flash Remoting, WebOrb and 
Fluorine.
> In addition, the Flex RPC components may be combined with Flex Data
> Services (FDS) to provide integrated enterprise functionality.
> 
> My guess is that all of this is too much information.  You 
probably just
> want to connect Flex to a SQL or Access database, right?   Well, 
to get
> your feet wet, I would recommend reading the following two
> articles/examples.  They are not current with F2B3, but little 
change is
> required.
> 
> Andrew Stepford's Weblog - Flex and .NET web services pt1.
> <http://weblogs.asp.net/astopford/articles/105551.aspx>  
> Andrew Stepford's Weblog - Flex and .NET web services pt2.
> <http://weblogs.asp.net/astopford/articles/106476.aspx>  
> 
> Using .NET web services to get data into Flex is probably the 
easiest
> approach to learn.  However, it's also the slowest data transfer 
method.
> I'm not recommending that you choose web services for your data 
needs.
> But, for learning purposes, you should be able to get up-to-speed, 
in a
> short amount of time.  At the same time, I would start reading the 
Flex
> Help Documentation.  It contains just about everything that you 
might
> need to know about "Working with Data."  Once you have a data
> connection, you can look into the other technologies to determine 
which
> approach is right for your application.
> 
> Best Regards,
> Tim Hoff
> 
> 
> --- In flexcoders@yahoogroups.com, "rama satoskar" 
> wrote:
> >
> > Hi all,
> > Can anyone teach a way to connect the flex application to an 
access
> > database or sql database.What i need is a simple tutorial or a 
sample
> > example. 
> > Kindly help.
> > Thanks in advance.
> > 
> > Rama.
> >
>






 Yahoo! Groups Sponsor ~--> 
Everything you need is one click away.  Make Yahoo! your home page now.
http://us.click.yahoo.com/AHchtC/4FxNAA/yQLSAA/nhFolB/TM
~-> 

--
Flexcoders Mailing List
FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt
Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/flexcoders/

<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
 




RE: [flexcoders] Re: Connecting to a sql or an access database through flex

2006-06-06 Thread Tracy Spratt










I recommend HTTPService.  Web
services are unnecessarily complicated if you have control of both client and
server.  To use HTTPService, just create an aspx application with the
content-type =”text/xml”.  Then use the .net data access
objects to talk to the database, and return XML to the calling Flex
client.  If your data requirements are simple enough, use FOR XML [raw,
auto, explicit] in the SQL queries, and you won’t even need to massage
the data into xml.

 

Set resultType=”e4x” in the
HTTPService tag.

 

I would post an example, but my current
exampl is so old, it uses Flex 1.5, and classic ASP.  I am using .net in
production, but haven’t created an example yet.

 

Tracy

 









From: flexcoders@yahoogroups.com [mailto:flexcoders@yahoogroups.com] On Behalf Of Tim Hoff
Sent: Tuesday, June 06, 2006 11:01
AM
To: flexcoders@yahoogroups.com
Subject: [flexcoders] Re:
Connecting to a sql or an access database through flex



 







Hi Rama,

Getting
SQL Server or Access data into Flex isn't that difficult.  However,
it's not that easy either.  There are currently several different
technologies that you can use to get .NET data into Flex. They include: Web
Services, HTTPService, Flash Remoting, WebOrb and Fluorine.  In addition,
the Flex RPC components may be combined with Flex Data Services (FDS) to
provide integrated enterprise functionality.

My guess
is that all of this is too much information.  You probably just want to
connect Flex to a SQL or Access database, right?   Well, to get your
feet wet, I would recommend reading the following two articles/examples. 
They are not current with F2B3, but little change is required.

Andrew Stepford's
Weblog - Flex and .NET web services pt1. 
Andrew
Stepford's Weblog - Flex and .NET web services pt2. 

Using
.NET web services to get data into Flex is probably the easiest approach to
learn.  However, it's also the slowest data transfer method.  I'm not
recommending that you choose web services for your data needs.  But, for
learning purposes, you should be able to get up-to-speed, in a short amount of
time.  At the same time, I would start reading the Flex Help Documentation. 
It contains just about everything that you might need to know about
"Working with Data."  Once you have a data connection, you can
look into the other technologies to determine which approach is right for your
application.

Best
Regards,
Tim Hoff


--- In flexcoders@yahoogroups.com,
"rama satoskar" <[EMAIL PROTECTED]> wrote:
>
> Hi all,
> Can anyone teach a way to connect the flex application to an access
> database or sql database.What i need is a simple tutorial or a sample
> example. 
> Kindly help.
> Thanks in advance.
> 
> Rama.
>






__._,_.___





--
Flexcoders Mailing List
FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt
Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com








   






  
  
SPONSORED LINKS
  
  
  

Web site design development
  
  
Computer software development
  
  
Software design and development
  
  


Macromedia flex
  
  
Software development best practice
  

   
  







  
  
  YAHOO! GROUPS LINKS



   Visit your group "flexcoders" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



  






__,_._,___






[flexcoders] Re: Connecting to a sql or an access database through flex

2006-06-06 Thread Tim Hoff



Hi Rama,
Getting SQL Server or Access data into Flex isn't that difficult.  However, it's not that easy either.  There are currently several different technologies that you can use to get .NET data into Flex. They include: Web Services, HTTPService, Flash Remoting, WebOrb and Fluorine.  In addition, the Flex RPC components may be combined with Flex Data Services (FDS) to provide integrated enterprise functionality.
My guess is that all of this is too much information.  You probably just want to connect Flex to a SQL or Access database, right?   Well, to get your feet wet, I would recommend reading the following two articles/examples.  They are not current with F2B3, but little change is required.
Andrew Stepford's Weblog - Flex and .NET web services pt1. Andrew Stepford's Weblog - Flex and .NET web services pt2. 
Using .NET web services to get data into Flex is probably the easiest approach to learn.  However, it's also the slowest data transfer method.  I'm not recommending that you choose web services for your data needs.  But, for learning purposes, you should be able to get up-to-speed, in a short amount of time.  At the same time, I would start reading the Flex Help Documentation.  It contains just about everything that you might need to know about "Working with Data."  Once you have a data connection, you can look into the other technologies to determine which approach is right for your application.
Best Regards,Tim Hoff
--- In flexcoders@yahoogroups.com, "rama satoskar" <[EMAIL PROTECTED]> wrote:>> Hi all,> Can anyone teach a way to connect the flex application to an access> database or sql database.What i need is a simple tutorial or a sample> example. > Kindly help.> Thanks in advance.> > Rama.>

__._,_.___





--
Flexcoders Mailing List
FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt
Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com








   






  
  
SPONSORED LINKS
  
  
  

Web site design development
  
  
Computer software development
  
  
Software design and development
  
  


Macromedia flex
  
  
Software development best practice
  

   
  







  
  
  YAHOO! GROUPS LINKS



   Visit your group "flexcoders" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



  






__,_._,___



[flexcoders] Re: Connecting to a sql or an access database through flex

2006-06-06 Thread iuliub
Hi Rama,

Check this out:
http://fluorine.thesilentgroup.com/fluorine/index.html
(you may want to see "Using Flash Remoting" section)

Iuliu

--- In flexcoders@yahoogroups.com, "rama satoskar" <[EMAIL PROTECTED]> 
wrote:
>
> Hi all,
> Can anyone teach a way to connect the flex application to an access
> database or sql database.What i need is a simple tutorial or a sample
> example. 
> Kindly help.
> Thanks in advance.
> 
> Rama.
>







 Yahoo! Groups Sponsor ~--> 
You can search right from your browser? It's easy and it's free.  See how.
http://us.click.yahoo.com/_7bhrC/NGxNAA/yQLSAA/nhFolB/TM
~-> 

--
Flexcoders Mailing List
FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt
Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/flexcoders/

<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
 




[flexcoders] Re: Connecting to a sql or an aCcess database through flex

2006-06-06 Thread Iuliu Burtoiu
Hi Rama,

Check this out:
http://fluorine.thesilentgroup.com/fluorine/index.html
(you may want to see "Using Flash Remoting" section)

Iuliu


__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 


 Yahoo! Groups Sponsor ~--> 
Everything you need is one click away.  Make Yahoo! your home page now.
http://us.click.yahoo.com/AHchtC/4FxNAA/yQLSAA/nhFolB/TM
~-> 

--
Flexcoders Mailing List
FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt
Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/flexcoders/

<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/