Lívio Rodrigues
unread,Jul 13, 2017, 10:50:30 AM7/13/17Sign in to reply to author
Sign in to forward
You do not have permission to delete messages in this group
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to Symfony Brasil
Ola devs!
Meu problema é conectar no sqlserver!
O que fiz ate agora foi:
1 - Verifiquei se o drive estava instalado: OK
$ Php -i | Grep PDO
PDO
PDO suporte => habilitado
PDO drivers => dblib, firebird, mysql, odbc, pgsql, sqlite
PDO Driver para FreeTDS / Sybase DB-lib => habilitado
PDO_Firebird
PDO Driver para Firebird => habilitado
PDO Driver para MySQL => habilitado Driver
PDO_ODBC
PDO para ODBC (unixODBC) =>
driver PDO habilitado para PostgreSQL =>
driver PDO habilitado para SQLite 3.x => habilitado
Tudo OK
________________________________________________
$tsql -C
Compile-time settings (established with the "configure" script)
Version: freetds v0.91
freetds.conf directory: /etc/freetds
MS db-lib source compatibility: no
Sybase binary compatibility: yes
Thread safety: yes
iconv library: yes
TDS version: 4.2
iODBC: no
unixodbc: yes
SSPI "trusted" logins: no
Kerberos: yes
_____________________________________________________
Meu arquivo /etc/freetds/freetds.conf
[sqlserver]
Driver = FreeTDS
host = 192.168.98.199
port = 1433
tds version = 8.0
_________________________________________
QUANDO RODO ESTE COMANDO ELE CONECTA NORMAL E RODA A SQL QUE EU COLOCAR NA SHELL
$isql -v sqlserver syscpd '(sw):$ajr:(*)'
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL>
__________________________________________________________
QUANDO RODO ESTE NA SHELL DO SYMFONY
$bin/console doctrine:query:sql "select * from [pm01estoque].[dbo].[cadcop00]" --connection=sqlserver
GERA ESTE ERRO
[PDOException]
SQLSTATE[01002] Adaptive Server connection failed (severity 9)
ALGUEM PODE ME AJUDAR EM ACHAR UMA SOLUÇÃO PRA ISSO????