Thank you all. Os : windows xp PHP : 5.2.9 Apache : 2.2.11 Symfony : 1.4.1 doctrine : ?
I tried using pdo_mssql and others like dlib but still the same error : "driver not found" or something like this. It's amazing because with other web applications (not with symfony) i can use pdo_mssql driver. I'm going to re check my configuration and tell you more. See you later On 14 sep, 02:55, "Daniel A.Tiecher" <datiec...@gmail.com> wrote: > 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 <lauren...@gmail.com> 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- Masquer le texte des messages précédents - > > - Afficher le texte des messages précédents - -- 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 symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en