Alian

Where's the MXML code?

You could send it too, it would must to see what's going on out there.

Best.
--Igor Costa

On 2/14/07, Alain Henner <[EMAIL PROTECTED]> wrote:

    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




--
----------------------------
Igor Costa
www.igorcosta.org
www.igorcosta.com
skype: igorpcosta

Reply via email to