SQL 2012 connection issues

Results 1 to 7 of 7
  1. #1
    Account Upgraded | Title Enabled! Bl4ck I0t4 is offline
    True MemberRank
    Oct 2008 Join Date
    Moldova&IsraelLocation
    238Posts

    SQL 2012 connection issues

    hi guys please advise i am getting errors trying to connect to a database using SQL2012 and xampp 1.7.3
    PHP Code:
    $connect mssql_pconnect('127.0.0.1:','Anton','1993'); 
    what am i missing here


  2. #2
    Victus Mortuus Kreeate is offline
    LegendRank
    Aug 2010 Join Date
    2,350Posts

    Re: SQL 2012 connection issues

    Quote Originally Posted by Bl4ck I0t4 View Post
    hi guys please advise i am getting errors trying to connect to a database using SQL2012 and xampp 1.7.3
    PHP Code:
    $connect mssql_pconnect('127.0.0.1:','Anton','1993'); 
    what am i missing here
    Maybe try:

    PHP Code:
    $connect mssql_connect('127.0.0.1:','Anton','1993'); 
    So it's not looking for a persistent link.
    IXXI

  3. #3
    Account Upgraded | Title Enabled! Bl4ck I0t4 is offline
    True MemberRank
    Oct 2008 Join Date
    Moldova&IsraelLocation
    238Posts

    Re: SQL 2012 connection issues

    maybe now it will be more clearly what i am getting as an error
    sh attached
    Untitled.jpg

  4. #4
    Member bog7 is offline
    MemberRank
    Dec 2013 Join Date
    45Posts

    Re: SQL 2012 connection issues

    Make sure in your php.ini (in XAMPP config for Apache) you uncomment the line:

    extension=php_mssql.dll

  5. #5
    BadAss Gaming Team -Jumong- is offline
    True MemberRank
    Dec 2005 Join Date
    /f248/Location
    848Posts

    Re: SQL 2012 connection issues

    Quote Originally Posted by bog7 View Post
    Make sure in your php.ini (in XAMPP config for Apache) you uncomment the line:

    extension=php_mssql.dll
    not sure if webserver and php still have this functions i think its depreciated

  6. #6
    Fuck. SheenBR is offline
    ModeratorRank
    Feb 2008 Join Date
    Ja├║, BrazilLocation
    2,425Posts

    Re: SQL 2012 connection issues

    I would say you need to enable in sql settings to accept connections using this "127.0.0.1" IP. Enable tcp/ip and named pipes

  7. #7
    Ultimate Member BAVKAMU is offline
    MemberRank
    Jul 2020 Join Date
    166Posts

    Re: SQL 2012 connection issues

    on some servers sometime when i can't connect with the ip i connect with name of the sql server INSTANCE for example sqlexpress/pcname NOT the ip address ...



Advertisement