Announcement

Collapse
No announcement yet.

MSSQL database connection

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • MSSQL database connection

    Please could someone offer some advise. I am developing on Mac OSX and up until now using MySQL which is fine, however i have a specific requirement to connect to MSSQL database and i am now starting to struggle, when using the MSSQL Server DBMS Driver i get the following error when trying to connect.

    Connection Error

    mssql_connect(): Unable to connect to server: 10.5.1.102

    I have tested the connection credentials and all are correct.


    I would be most grateful for some help and advice.

    Thanks.

  • #2
    Has ser ver ports opened? Maybe some firewall locking connection?
    /Giuseppe

    Professional Scriptcase Services
    Some Customers opinions

    Comment


    • #3
      The SQL Server is on the same subnet there is no firewall involved. Are there any MSSQL drivers needed to connect ?

      Comment


      • #4
        Are you using Scriptcase conneon manager or is it a connection string made on your own? If the latest, share your connection string.

        regards

        Comment


        • #5
          I am connecting to the database using the Scriptcase connection manager.

          Comment


          • #6
            I assume that you have the right licence to use SQL Server. Try to connect to this server by writing a few lines of code. If that works then it's likely a SC problem. We have an enterprise licence and connection to sqlserver is running w.o. problems, even in combination with oracle.
            Albert Drent
            aducom software netherlands
            scriptcase partner, reseller, support and (turn-key) development
            www.scriptcase.eu / www.scriptcase.nl

            Comment


            • #7
              Wich kind of connection are you using?

              http://support.scriptcase.net/index....mssql-database
              /Giuseppe

              Professional Scriptcase Services
              Some Customers opinions

              Comment


              • #8
                Ok .... I have the enterprise version of script case installed on a MAC running yosemite. I have attempted to use the scriptcase MSSQL Server connection option but get

                mssql_connect(): Unable to connect to server: 10.5.1.102.

                In addition I have installed and verified the FreeTDS and can verify and connect to an MSSQL server via terminal . However i cannot get Scriptcase to connect. I just don't know what i am missing and where.

                I have installed SC on a windows PC and all works fine but i would rather not commit such a sin and move to the dark side !!!

                I would be most grateful for any advice.

                Thanks

                Comment


                • #9
                  lmfao... the dark side... lol... come on Luke... you know you wanna use that dirty windowsy hard drive. lmfao.

                  Comment


                  • #10
                    Hmm I found one reference that may be usefull:
                    http://www.glatter-gotz.com/blog/201...osx-and-xampp/
                    But I havent tested it at all.
                    Be aware that you then also have to set the proper rights for homebrew.

                    Maybe this one: http://stackoverflow.com/questions/1...c-with-php-pdo

                    I suggest you make a simple connection with straight php first before trying scriptcase. Specially since OSX kinda blocks various stuff since php and so is not an officially OSX certified which you may need to set by hand as well.

                    I found a link here: http://lkrms.org/php-with-freetds-on-os-x-mavericks/

                    Comment

                    Working...
                    X