Re: [flexcoders] Dot NET or JAVA example to give output as WSDL

2009-09-07 Thread Suresh G
Hi All,
Thanks a lot for your answers My Main need is...

I have remote SQL server need to connect using flex and give the output in
various charts...

For which i found flashbuilder 4 is easy but i am blank... i thought if i
can generate a WSDL file then it would be easy to bind in flashbuilder ie.
flex builder 4

Thanks
Suresh

On Sun, Sep 6, 2009 at 12:25 PM, Sam Lai samuel@gmail.com wrote:



 If you are developing the .NET web service using the standard method,
 it would have generated a WSDL for you which is accessible at the web
 service URL (ends with .asmx).

 As far as I know, SQL server does not do web services natively (maybe
 with the Data Services component...).

 2009/9/6 Suresh G suresh@gmail.com suresh.sci%40gmail.com:

 
 
  My Dear Coders,
  I am a newbie in coding, good in designing.
  I need one help, i wanted to connect Microsoft SQL server, finally i am
 able
  to connect with a  dotnet web service and return as XML, but how to
 connect
  a SQL server so that i get the output as WSDL  please help me
  Any other method or suggestion is always welcome. Need an output of WSDL
  after connecting SQL
  Suresh
 
 
 
 

  



Re: [flexcoders] Dot NET or JAVA example to give output as WSDL

2009-09-07 Thread Sam Lai
2009/9/7 Suresh G suresh@gmail.com:


 Hi All,
 Thanks a lot for your answers My Main need is...
 I have remote SQL server need to connect using flex and give the output in
 various charts...
 For which i found flashbuilder 4 is easy but i am blank... i thought if i
 can generate a WSDL file then it would be easy to bind in flashbuilder ie.
 flex builder 4

You need to have something in between to manage the connection between
Flex and SQL Server. That could be a .NET or Java web service. Which
framework/language do you prefer?

There are plenty of examples for writing .NET web services out there -
http://www.codeproject.com/KB/webservices/myservice.aspx

Just add code to connect to the SQL server in there (again, plenty of
examples), host the web service somewhere, and it'll work. The WSDL is
generated automatically when you navigate to the web service.


Re: [flexcoders] Dot NET or JAVA example to give output as WSDL

2009-09-07 Thread Sam Lai
2009/9/8 Sam Lai samuel@gmail.com:
 2009/9/7 Suresh G suresh@gmail.com:


 Hi All,
 Thanks a lot for your answers My Main need is...
 I have remote SQL server need to connect using flex and give the output in
 various charts...
 For which i found flashbuilder 4 is easy but i am blank... i thought if i
 can generate a WSDL file then it would be easy to bind in flashbuilder ie.
 flex builder 4

 You need to have something in between to manage the connection between
 Flex and SQL Server. That could be a .NET or Java web service. Which
 framework/language do you prefer?

Actually, looks like SQL Server 2005 and up does it itself too -
http://www.developer.com/db/article.php/3390241

You'll need the right permissions and have HTTP endpoints setup, so
that means admin access to the database. Haven't had any experience
with this though.


Re: [flexcoders] Dot NET or JAVA example to give output as WSDL

2009-09-06 Thread Sam Lai
If you are developing the .NET web service using the standard method,
it would have generated a WSDL for you which is accessible at the web
service URL (ends with .asmx).

As far as I know, SQL server does not do web services natively (maybe
with the Data Services component...).

2009/9/6 Suresh G suresh@gmail.com:


 My Dear Coders,
 I am a newbie in coding, good in designing.
 I need one help, i wanted to connect Microsoft SQL server, finally i am able
 to connect with a  dotnet web service and return as XML, but how to connect
 a SQL server so that i get the output as WSDL  please help me
 Any other method or suggestion is always welcome. Need an output of WSDL
 after connecting SQL
 Suresh