MSSQL_connect problem

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Ciary
    Recognized Expert New Member
    • Apr 2009
    • 247

    MSSQL_connect problem

    hi all,

    i've encountered a new problem. i was trying to connect to a ms sql server (9.0) to connect i use this:
    Code:
    mssql_connect("***.***.***.***","User","userpw");
    and i got this error:
    -------------------------------------------------------------------------------------------------------------------------
    Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: ***.***.***.***
    -------------------------------------------------------------------------------------------------------------------------

    so i thought: "server is down", and i tried connecting with sql management studio. this worked. so now im search why php tells me it can't connect.

    also, i tried adding the port (which i think is standard 1433) to the IP address without any luck.

    can anyone help me with this matter?
  • Markus
    Recognized Expert Expert
    • Jun 2007
    • 6092

    #2
    Maybe mssql_get_last_ message() will hold the error.

    Comment

    • Dormilich
      Recognized Expert Expert
      • Aug 2008
      • 8694

      #3
      if you're using PDO, the thrown PDOException might hold additional info.

      Comment

      • Ciary
        Recognized Expert New Member
        • Apr 2009
        • 247

        #4
        well, i found the source of my problem. it was an invalid dll.

        tnx anyway guys

        Comment

        Working...