Hello, Could you give us a little more information about your setup? OS, PHP Version, etc.
The only time I needed to create a symfony project that talked to a MSSQL instance I used pdo_mssql on Windows (dev machine) and pdo_dblib on the production server (Linux). I won't say it was an easy thing to do, specially since pdo_mssql suffers from the same problems that the traditional mssql driver had (probably because it's simply a wrapper around mssql using PDO and not a new implementation, I guess). One issue that is still present on my nightmares at night is the one where you cannot reference database objects (like fields and tables) using their names, if their names are more than 30 characters long. Something along the lines of: SELECT really_long_column_name_for_example FROM example Even though this query would be executed normally, when trying to access the column value by it's index name, it would fail. That happens because what the driver would actually return is a column name truncated on 30 characters, or using the above example, really_long_column_name_for_ex. This is more of a problem when you start using something like Doctrine, because it creates and returns an alias for the column field based on its name AND the alias of the table that contains it. Which would produce even longer indexes... To summarize, it's a PITA to use pdo_mssql. Thank God Doctrine 2 will be using sqlsvr instead of this s**tty solution. Hope I could have been of any help. =) On Sep 9, 8:18 am, ziclo <[email protected]> wrote: > Hi everybody, > > I'm trying to add a new database to my symfony project. One managed by > mysql and the other by MS SQL server. I get an error about mssql > driver when i rebuild all (schema, etc..)I do not know which driver to > use for MS SQL. Here is my database.yml > > An idea ? > > Symfony version : 1.4 > Here is my database.yml > > all: > doctrine: > class: sfDoctrineDatabase > param: > dsn: mysql:host=localhost;dbname=tracker > username: rfghj > password: jkkhf > doctrine1: > class: sfDoctrineDatabase > param: > dsn: mssqll:host=localhost;dbname=asadata > username: rdfgh > password: dfgjh -- If you want to report a vulnerability issue on symfony, please send it to security at symfony-project.com You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en
