Conexão PDO SQL Server
14/09/2017
0
Mas está dando o seguinte erro:
Erro ao conectar: could not find driver
Fatal error: Uncaught TypeError: Argument 1 passed to Teste::__construct() must be an instance of PDO, null given, called in C:\\xampp\\htdocs\\web\\barbacena\\index.php on line 31 and defined in C:\\xampp\\htdocs\\web\\barbacena\\models\\teste.php:5 Stack trace: #0 C:\\xampp\\htdocs\\web\\barbacena\\index.php(31): Teste->__construct(NULL) #1 thrown in C:\\xampp\\htdocs\\web\\barbacena\\models\\teste.php on line 5
Estou utilizando o seguinte código:
class conexao { public function connect() { $caminho_banco = "ip"; $port = "porta"; $banco = "nome_do_banco"; $usuario = "usuario"; $senha = "senha"; try { $connection = new PDO("mssql:host={$caminho_banco}:{$port};dbname={$banco}", "{$usuario}", "{$senha}"); return $connection; } catch (PDOException $e) { echo "Erro ao conectar: " . $e->getMessage(); } } }
Samuel Lopes
Posts
15/09/2017
Fabio Rocha
Você precisa baixar os drivers do sqlserv da microsoft.
https://www.microsoft.com/en-us/download/details.aspx?id=20098
Abraços
15/09/2017
Samuel Lopes
Mas continua dando o seguinte erro:
Fatal error: Uncaught TypeError: PDO::__construct() expects parameter 4 to be array, string given in C:\\xampp\\htdocs\\web\\barbacena\\config\\conexao_pdo.php:14 Stack trace: #0 C:\\xampp\\htdocs\\web\\barbacena\\config\\conexao_pdo.php(14): PDO->__construct('mssql:host=ip', 'port=porta', 'usuario', 'senha') #1 C:\\xampp\\htdocs\\web\\barbacena\\index.php(29): conexao->connect() #2 thrown in C:\\xampp\\htdocs\\web\\barbacena\\config\\conexao_pdo.php on line 14
15/09/2017
Samuel Lopes
class conexao { public function connect() { $caminho_banco = "200.202.246.178"; $port = "1433"; $banco = "CORPORE_TESTE"; $usuario = "bpm"; $senha = "bpm$%t1un1p4c*321"; try { $connection = new PDO("mssql:host={$caminho_banco}:{$port};dbname={$banco}","{$usuario}", "{$senha}"); return $connection; } catch (PDOException $e) { echo "Erro ao conectar: " . $e->getMessage(); } } }
Erro:
Erro ao conectar: could not find driver
Fatal error: Uncaught TypeError: Argument 1 passed to Teste::__construct() must be an instance of PDO, null given, called in C:\\xampp\\htdocs\\web\\barbacena\\index.php on line 31 and defined in C:\\xampp\\htdocs\\web\\barbacena\\models\\teste.php:5 Stack trace: #0 C:\\xampp\\htdocs\\web\\barbacena\\index.php(31): Teste->__construct(NULL) #1 thrown in C:\\xampp\\htdocs\\web\\barbacena\\models\\teste.php on line 5
Clique aqui para fazer login e interagir na Comunidade :)