mirkin93

mirkin93

Member Since 4 Months Ago

Experience Points 90
Experience Level 1

4,910 experience to go until the next level!

In case you were wondering, you earn Laracasts experience when you:

  • Complete a lesson — 100pts
  • Create a forum thread — 50pts
  • Reply to a thread — 10pts
  • Leave a reply that is liked — 50pts
  • Receive a "Best Reply" award — 500pts
Lessons Completed 0
Lessons
Completed
Best Reply Awards 0
Best Reply
Awards
  • Start Your Engines Achievement

    Start Your Engines

    Earned once you have completed your first Laracasts lesson.

  • First Thousand Achievement

    First Thousand

    Earned once you have earned your first 1000 experience points.

  • One Year Member Achievement

    One Year Member

    Earned when you have been with Laracasts for 1 year.

  • Two Year Member Achievement

    Two Year Member

    Earned when you have been with Laracasts for 2 years.

  • Three Year Member Achievement

    Three Year Member

    Earned when you have been with Laracasts for 3 years.

  • Four Year Member Achievement

    Four Year Member

    Earned when you have been with Laracasts for 4 years.

  • Five Year Member Achievement

    Five Year Member

    Earned when you have been with Laracasts for 5 years.

  • School In Session Achievement

    School In Session

    Earned when at least one Laracasts series has been fully completed.

  • Welcome To The Community Achievement

    Welcome To The Community

    Earned after your first post on the Laracasts forum.

  • Full Time Learner Achievement

    Full Time Learner

    Earned once 100 Laracasts lessons have been completed.

  • Pay It Forward Achievement

    Pay It Forward

    Earned once you receive your first "Best Reply" award on the Laracasts forum.

  • Subscriber Achievement

    Subscriber

    Earned if you are a paying Laracasts subscriber.

  • Lifer Achievement

    Lifer

    Earned if you have a lifetime subscription to Laracasts.

  • Laracasts Evangelist Achievement

    Laracasts Evangelist

    Earned if you share a link to Laracasts on social media. Please email [email protected] with your username and post URL to be awarded this badge.

  • Chatty Cathy Achievement

    Chatty Cathy

    Earned once you have achieved 500 forum replies.

  • Laracasts Veteran Achievement

    Laracasts Veteran

    Earned once your experience points passes 100,000.

  • Ten Thousand Strong Achievement

    Ten Thousand Strong

    Earned once your experience points hits 10,000.

  • Laracasts Master Achievement

    Laracasts Master

    Earned once 1000 Laracasts lessons have been completed.

  • Laracasts Tutor Achievement

    Laracasts Tutor

    Earned once your "Best Reply" award count is 100 or more.

  • Laracasts Sensei Achievement

    Laracasts Sensei

    Earned once your experience points passes 1 million.

  • Top 50 Achievement

    Top 50

    Earned once your experience points ranks in the top 50 of all Laracasts users.

22 Feb
4 months ago

mirkin93 left a reply on Illuminate\Database\QueryException SQLSTATE[HYT00]: [unixODBC][Microsoft][ODBC Driver 17 For SQL Server]Login Timeout Expired

@MUNAZZIL - I read the article yesterday, with sqlcmd the connection is successful. I already reinstalled the pdo_sqlsrv & sqlsrv driver.

When I try the follow PHP script:

<?php
$serverName = "172.20.2.10";
$connectionOptions = array(
    "Database" => "DATA",
    "Uid" => "saWeb",
    "PWD" => "PASSWORD"
);

//Establishes the connection
$conn = sqlsrv_connect($serverName, $connectionOptions);
//Select Query
$tsql= "SELECT @@Version as SQL_VERSION;";
//Executes the query
$getResults= sqlsrv_query($conn, $tsql);
//Error handling

if ($getResults == FALSE)
    die(FormatErrors(sqlsrv_errors()));
?>
<h1> Results : </h1>
<?php
while ($row = sqlsrv_fetch_array($getResults, SQLSRV_FETCH_ASSOC)) {
    echo ($row['SQL_VERSION']);
    echo ("<br/>");
}
sqlsrv_free_stmt($getResults);
function FormatErrors( $errors )
{
    /* Display errors. */
    echo "Error information: <br/>";

    foreach ( $errors as $error )
    {
        echo "SQLSTATE: ".$error['SQLSTATE']."<br/>";
        echo "Code: ".$error['code']."<br/>";
        echo "Message: ".$error['message']."<br/>";
    }
}
?>

It gives the following output:

Microsoft SQL Server 2014 (SP1-GDR) (KB4019091) - 12.0.4237.0 (X64) Jul 5 2017 22:03:42 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.3 (Build 9600: ) (Hypervisor) 

That output shows me that the drivers installed correctly and there is a problem with Laraval and MS SQL?

mirkin93 left a reply on Illuminate\Database\QueryException SQLSTATE[HYT00]: [unixODBC][Microsoft][ODBC Driver 17 For SQL Server]Login Timeout Expired

I don't understand what you're try to say/test. When I change it to 127.0.0.1, it's my localhost. (My own server).

On the localhost there isn't a MS SQL Server installed, the MS SQL Server is installed on 172.20.2.10. Why should I change my DB_HOST to 172.0.0.1?

mirkin93 left a reply on Illuminate\Database\QueryException SQLSTATE[HYT00]: [unixODBC][Microsoft][ODBC Driver 17 For SQL Server]Login Timeout Expired

I'm connecting with a external MS SQL server, on ip 172.20.2.10 and the TCP port 1433.

mirkin93 left a reply on Illuminate\Database\QueryException SQLSTATE[HYT00]: [unixODBC][Microsoft][ODBC Driver 17 For SQL Server]Login Timeout Expired

My .env file.

APP_NAME=Laravel
APP_ENV=local
APP_KEY=base64:s9/HEFeFdMltze4NxAKacADUAuwGeOQl+SjYUSF3z/0=
APP_DEBUG=true
APP_URL=http://localhost

LOG_CHANNEL=stack

DB_CONNECTION=sqlsrv
DB_HOST=127.20.2.10
DB_PORT=1433
DB_DATABASE=DATA
DB_USERNAME=saWeb
DB_PASSWORD='PASSWORD'

BROADCAST_DRIVER=log
CACHE_DRIVER=file
QUEUE_CONNECTION=sync
SESSION_DRIVER=file
SESSION_LIFETIME=120

REDIS_HOST=127.0.0.1
REDIS_PASSWORD=null
REDIS_PORT=6379

MAIL_DRIVER=smtp
MAIL_HOST=localhost
MAIL_PORT=25
MAIL_USERNAME=null
MAIL_PASSWORD=null
MAIL_ENCRYPTION=null

PUSHER_APP_ID=
PUSHER_APP_KEY=
PUSHER_APP_SECRET=
PUSHER_APP_CLUSTER=mt1

MIX_PUSHER_APP_KEY="${PUSHER_APP_KEY}"
MIX_PUSHER_APP_CLUSTER="${PUSHER_APP_CLUSTER}"
21 Feb
4 months ago

mirkin93 started a new conversation Illuminate\Database\QueryException SQLSTATE[HYT00]: [unixODBC][Microsoft][ODBC Driver 17 For SQL Server]Login Timeout Expired

When I try to connect to my SQL Server with my Laravel App I got the error: Illuminate\Database\QueryException SQLSTATE[HYT00]: [unixODBC][Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired.

When I try to the same connection on my server with sqlcmd -S {host} -d {database} -U {user} -P {pass} -I -Q {query} I got a result.

How can I fix the error in the Laravel App?