Here is an example of how I do it with coldfusion Everything should be pretty much the same im guessing:
//just some variables var webServer:String = 'http://domainOrIPAddress/'; //directory where service lives var srvDir:String = 'CFC.' // Set Connector Properties myRemConn_rc.addEventListener("result",newsResult); myRemConn_rc.addEventListener("status",newsStatus); myRemConn_rc.gatewayUrl = _root.webServer+"flashservices/gateway/"; myRemConn_rc.methodName = "getBlurb"; myRemConn_rc.serviceName = _root.srvDir+"news"; myRemConn_rc.suppressInvalidCalls = true; // Set Parameter Required by Remoting Service myRemConn_rc.params = {locale:"en_US"}; // Trigger Connector myRemConn_rc.trigger(); //result handlers function newsResult(ev:Object) { if(ev.target.results.ERROR > 0){ status_txt.text = 'News can not be retrived at this time.'; } //include that processes the data retrived #include "as/_engineNews.as" } function newsStatus(stat:Object) { trace("News Error - " + stat.code + " - " + stat.data.faultstring); } //remove event listeners this.onUnload = function(){ myRemConn_rc.removeEventListener('newsResult',result); myRemConn_rc.removeEventListener('newsStatus',status); } -----Original Message----- From: Gabe Varela [mailto:[EMAIL PROTECTED] Sent: Monday, January 23, 2006 10:24 AM To: Flashcoders mailing list Subject: RE: [Flashcoders] remoting.net with mssql Can you provide examples of what you have attempted. -----Original Message----- From: Gavin Lilley [mailto:[EMAIL PROTECTED] Sent: Monday, January 23, 2006 9:13 AM To: Flashcoders mailing list Subject: [Flashcoders] remoting.net with mssql After a few years of php, I am (re)learning asp.net and have started to convert php to asp as I find that working with my own code is a great help (although it is a gif and a curse at times)! I am unable to connect to a MSSQL2000 database in order to either call a stored procedure or inline sql code and I have searched everywhere to find some examples. Can anyone please help me? Regards, -- Gavin Lilley. _______________________________________________ Flashcoders mailing list Flashcoders@chattyfig.figleaf.com http://chattyfig.figleaf.com/mailman/listinfo/flashcoders
