Re: [flexcoders] Dot NET or JAVA example to give output as WSDL
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/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/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
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