4 Replies Latest reply on Nov 30, 2012 4:07 PM by iccsi

    Database connection

    iccsi Level 1

      I would like to connect my MS SQL database from ColdFusion server.

      Can I use connection string to connect database or I need set up ODBC at ColdFusion level and use application paramter to connect database server?

      Your help and informaiton is great appreciated,

       

      Regards,

       

      Iccsi,

        • 1. Re: Database connection
          BKBK Adobe Community Professional & MVP

          There is a facility in the ColdFusion Administrator to enable you to connect to your MS SQL database.

          1 person found this helpful
          • 2. Re: Database connection
            iccsi Level 1

            Thanks for the message and help,

            Do you mean that developer can not use connection string to connect MS SQL server?

            Developer needs request ColdFusion Administrator to make the connection and in my application that I can use application parameter to connect MS SQL Server database.

             

            Thanks again for helping and information,

             

            Regards,

             

            Iccsi,

            • 3. Re: Database connection
              Carl Von Stetten Adobe Community Professional & MVP

              @iccsi,

              If you are asking whether you can create an ad-hoc database connection using a connection string inside of a .cfm or .cfc file, I think the answer is probably no.  A datasource can be programmatically created using teh CF Administrator API, but that would require granting the developer the permissions to use the API.

               

              The datasource connection configuration is behind the CF Administrator and the Administrator API by design for security.

              -Carl V.

              • 4. Re: Database connection
                iccsi Level 1

                Thanks a million for the information and help,

                 

                Regards,

                 

                Iccsi,