Urgent - SQLSTATE[01002] Adaptive Server connection failed (severity 9)

[Pablomarcolino]

does anyone know how to resolve this error?

[joelpk2r]

On 8/23/2023 at 7:27 PM, Pablomarcolino said:

does anyone know how to resolve this error?

Please attach the "log" file. You can find it in /application/logs. Maybe I can help you by seeing what problem the website throws up.

[Canabiz]

Open outgoing port from web hosting side. 

[DGN_Hoot]

On 8/23/2023 at 6:27 PM, Pablomarcolino said:

does anyone know how to resolve this error?

Unsure if you ended up figuring it out, how ever I suggest reaching out to your host for your website and use pdo_dblib.

Make this .php file and drop this into your root web folder -> fill out the information within that ?php script and after dropping the file into your ftp head over to your website and use that .php file it will either throw an error or will give you information from the SQL. Things to take note, make sure your webhost opens port 1433. 

Quote

<?php
$serverName = "ServerIP";
$uid = "username";
$pwd = "password!";
$db = "MuOnline";

try {
    $conn2 = new PDO("dblib:host=" . $serverName . ";dbname=" . $db . ";", "" . $uid . "", "" . $pwd . "");
    $conn2->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    
    $stmt = $conn2->prepare("SELECT TOP 1 Name from Character ORDER BY Name Desc");
    $stmt->execute();
    var_dump($stmt->fetchall());

}
catch(PDOException $e){
    echo "Connection failed: " . $e->getMessage();
}

 

[Todon]

port blocked on firewall or sql settings doesn't set to remote connection

[cvclics]

[url=https://samoylovaoxana.ru/tag/pohody-po-kavkazu/]походы по Кавказу[/url] или [url=https://samoylovaoxana.ru/tag/turizm-i-otdyh-v-italii/]туризм и отдых в Италии[/url]

[url=https://samoylovaoxana.ru/tag/aksessuary-v-dorogu/]аксессуары в дорогу[/url]

https://samoylovaoxana.ru/otdyh-v-tyrcii/

Ещё можно узнать: [url=http://yourdesires.ru/home-and-family/cookery/232-kak-prigotovit-shpikachki-v-domashnih-usloviyah.html]шпикачки в домашних условиях[/url]

Романтические путешествия

[ILoVeCarrots]

Anyone has a solution for it?