1 Reply Latest reply on Dec 22, 2010 11:26 AM by Developer504

    Trouble connecting to SQL 2005

    Developer504 Level 1

      I'm using Flex 3, trying to connect to SQL 2005 via ASP with IIS7.


      I was following the instructions listed [url=http://livedocs.adobe.com/flex/3/html/help.html?content=data_3.html]here [/url] under the section "Generating an ASP .NET database application", I attempted to Create an Application from Database, following all the steps as listed, but Flex is failing to connet to my database.


      I specified a name for the connection profile (I assume this can be anything - maybe this is my mistake), on the next screen under server name I put in the name of my local SQL 2005 Server on my machine: DAVE-PC\SQLEXPRESS, I put in the name of the database AIS1010 and user ID: sa and password 1234 (these all match the credentials on my local SQL Server) and I clicked the button 'Test connection', I get the message unable to connect to database.


      I looked at the logs under the detail button, and I can see that Flex is failing to find "DAVE-PC\SQLEXPRESS'.  What am I doing wrong here?


      Is there something specific I need to do in IIS?



        • 1. Re: Trouble connecting to SQL 2005
          Developer504 Level 1

          I should add:


          The first line of the error details reads:


          java.sql.SQLException: Unknown server host name 'DAVE-PC\SQLEXPRESS'.


          but this is the correct server name in SQL 2005.




          In the Projects Flex Server Properties root folder is: C:\inetpub\wwwroot\


          root URL is: http://localhost/


          these locations do 'validate' in Flex.


          IIS Server is running and I'm able to run other applications through it using some other applications, both in Flex and in Unipaas..