I have solved my problems. Linux -> go through this: https://github.com/intellectsoft-uk/MssqlBundle and make sure you have the FreeTDS package installed and configured correctly.
Windows -> Even though my sql server was at the default port of 1433, you have to make sure you aren't sending the port in the dsn for some reason. Since I'm using symfony2, I commented out database_port: in parameters.yml and port: in config.yml. On Tuesday, May 5, 2015 at 3:30:35 PM UTC-4, Andrew Monkiewicz wrote: > > I downloaded that driver and now have the following error message: > > [PDOException] > SQLSTATE[08001]: [Microsoft][ODBC Driver 11 for SQL Server]TCP Provider: > No > connection could be made because the target machine actively refused it. > > I can get to the server with sql server management studio and tsql, and > other web apps pointing at it work fine. > > > On Tuesday, May 5, 2015 at 2:56:23 PM UTC-4, kontakt wrote: >> >> pdo_sqlsrv only runs on Windows. >> >> You should follow that link the error message about the old ODBC driver >> 11. >> >> sqlsrv is a different extension called "sqlsrv", which you dont have >> installed (hence the errors). >> >> On Tue, May 5, 2015 at 8:32 PM, Andrew Monkiewicz <[email protected]> >> wrote: >> >>> As I'm completely stuck in linux, I thought I'd try and give windows a >>> shot: >>> >>> I have php_pdo_sqlsrv_55_nts.dll in my ext directory >>> >>> php -m reports that PDO and pdo_sqlsrv are loaded >>> >>> phpinfo shows the pdo_sqlsrv drivers loaded: >>> >>> PDO drivers => sqlsrv >>> >>> pdo_sqlsrv >>> >>> pdo_sqlsrv support => enabled >>> >>> Directive => Local Value => Master Value >>> pdo_sqlsrv.client_buffer_max_kb_size => 10240 => 10240 >>> pdo_sqlsrv.log_severity => 0 => 0 >>> >>> php app/console doctrine:mapping:import --force SomethingSomethingBundle >>> >>> so with database_driver: pdo_sqlsrv >>> >>> I get: >>> >>> [PDOException] >>> SQLSTATE[IMSSP]: This extension requires the Microsoft ODBC Driver 11 >>> for S >>> QL Server to communicate with SQL Server. Access the following URL to >>> downl >>> oad the ODBC Driver 11 for SQL Server for x86: >>> http://go.microsoft.com/fwli >>> nk/?LinkId=163712 >>> >>> >>> And with database_driver: sqlsrv >>> >>> I get: >>> >>> [Symfony\Component\Debug\Exception\UndefinedFunctionException] >>> Attempted to call function "sqlsrv_configure" from namespace >>> "Doctrine\DBAL >>> \Driver\SQLSrv". >>> >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "doctrine-user" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> To post to this group, send email to [email protected]. >>> Visit this group at http://groups.google.com/group/doctrine-user. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- You received this message because you are subscribed to the Google Groups "doctrine-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/doctrine-user. For more options, visit https://groups.google.com/d/optout.
