3 Replies Latest reply on Feb 10, 2009 12:35 PM by Newsgroup_User

    Possible for AIR app connecting to SQL 2005 server

    kamaljeetsinghsaini
      Is it possible using Flex AIR to connection to SQL 2005 server and fetch data ?
      If YES, whats step / process we need to follow please.

      We have the DB in sql 2005 and we want to develop desktop client and fetch the records from DB to AIR app.
        • 1. Re: Possible for AIR app connecting to SQL 2005 server
          Level 7

          "kamaljeetsinghsaini" <webforumsuser@macromedia.com> wrote in message
          news:gmq88m$khf$1@forums.macromedia.com...
          > Is it possible using Flex AIR to connection to SQL 2005 server and fetch
          > data ?
          > If YES, whats step / process we need to follow please.
          >
          > We have the DB in sql 2005 and we want to develop desktop client and fetch
          > the
          > records from DB to AIR app.

          Just use whatever backend technology you normally use and call it from
          HTTPService.


          • 2. Re: Possible for AIR app connecting to SQL 2005 server
            kamaljeetsinghsaini Level 1
            As we know that AIR supports SQlite only but in our case we want to fetch data from server that is using SQL 2005 as DB. So are you saying we can directly send the HTTP service to that server and fetch data from it ?
            • 3. Re: Possible for AIR app connecting to SQL 2005 server
              Level 7

              "kamaljeetsinghsaini" <webforumsuser@macromedia.com> wrote in message
              news:gmsmnc$non$1@forums.macromedia.com...
              > As we know that AIR supports SQlite only but in our case we want to fetch
              > data
              > from server that is using SQL 2005 as DB. So are you saying we can
              > directly
              > send the HTTP service to that server and fetch data from it ?

              You can send the HTTPService request to whatever back end technology you are
              currently using to access it. For example, if you are using ASP.net, you
              would still use ASP.net, but you would send back something that Flex
              understands, such as XML, instead of the HTML that the browser client
              understands.