Hi. This is my first question about working with Flex. I just started
experimenting with it, and I'm pretty excited over it.

I'm trying to create a little form and populate it with data from a SQL Server
database via ASP.NET. I created a project in Flex Builder 3 Pro, chose Desktop
application (runs in Adobe AIR), and selected Application server type ASP.NET.
On the next page, I selected "Use ASP.NET Development Server", since I just
want to test it on my desktop. After creating the project, I go to the Data
menu and select "Create Application from Database". I select my project, and
then click "New" on the data source page to create the connection to the data.
I give my new connection a name, and click next. I enter my server name,
database name, and login info. When I click Test Connection, I get an error
"Unable to connect to database". I click Details, and the info starts with
java.sql.SQLException... Connection refused. Then it traces through a zillion
details.

I have tested this connection in SQL Server and Visual Studio 2005, so I know
the connection information is valid. I have never tried connecting through
anything that uses Java before. Is there some configuration issue I am missing?
Is there some way I can troubleshoot the connection problem? I don't know much
about Java.

Are there any step-by-step examples out there of connecting to a SQL Server
database (or other database) via ASP.NET from a Flex project? This is all new
to me (I'm a .NET developer).

My ultimate goal is to replace the web-based front end of a .NET application
with an AIR-based front end.

BTW, I have Visual Studio 2005 Pro and SQL Server 2005 Developer installed on
my workstation.

Thanks for any help.

Peter

hi can you solve this problem?

i have this problem too, i can connect sql express 2005 db if my project is a flex project by using "create application from database" wizard. but there is a problem when i create a project as an air application that i cannot connect database .it says a problem occur ?!)(+^/&+') anyway if you find a solution for this please share it with me, or if i can find sth. about this issue i will share it with you

Yes, I have the same question. I hope this isn't another dead end of functionality offered, but not delivered. The other one: The automated actionscipt classes that are generated for a web service don't work for datasets, but only in a distant bug list is this acknowledged (with an obtuse workaround that doesn't work).