[flexcoders] Flex and ASP

[Alain Henner]

 Hi guys,
 
I have some problems connecting flex app with a database SQL server 2005.
Here is the asp script I wrote:
<%@ LANGUAGE="VBSCRIPT" %>
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.ConnectionTimeout = 15
Conn.CommandTimeout = 30
Conn_Catalog = "---------"
Conn_UserID = "----------"
Conn_Password = "---------"
Conn_DataSource = "------------"
 
conn.Open "Provider=sqloledb; Data Source=" & Conn_DataSource & "; Initial
Catalog=" & Conn_Catalog & "; User Id=" & Conn_UserID & "; Password=" &
Conn_Password
 
SQL="SELECT * FROM [Membres]"
Set RS = server.createobject("ADODB.Recordset")
RS.Open SQL,Conn , 3, 3
 
 
while not RS.eof %>
   <%=RS("prenom")%> - <%=RS("nom")%> - <%=RS("courriel")%><br>
   <%RS.MOVENEXT ' fiche suivante
wend
 
 
RS.close
 
conn.close : Set conn=nothing 
%>
 
And it works but not with the flex app.
 
Any help will be welcome
Thanks
Alian