Todd, Can you post an example of the PDO/dblib DSN you are using in database.yml?
Thanks! -pat On Mar 18, 6:17 pm, "Todd Mcneill" <todd.mcne...@pmigroup.com> wrote: > Actually, I was able to resolve the issue for pdo_dblib, but not for ODBC. > There are two issues, both with Doctrine, not Symfony. One is already fixed > in the latest Doctrine code base, but depending on how you deployed Doctrine > and Symfony, the fix may not be there. There is a TRAC ticket for this fix: > > http://trac.symfony-project.org/ticket/5853 > > My additional fix was to add the data type translation into the > doctrine/Doctrine/DataDict/Mssql.php file. Here is my diff: > > # diff Mssql.php Mssql.php.orig > 149,151d148 > < case 'bigint': > < $type[0] = 'integer'; > < break; > > The length (8 bytes) of the bigint data type is captured appropriately by the > Doctrine tools. > > Hope this helps. > > Todd > > -----Original Message----- > From: symfony-users@googlegroups.com [mailto:symfony-us...@googlegroups.com] > On Behalf Of umberleigh > Sent: Wednesday, March 18, 2009 9:41 AM > To: symfony users > Subject: [symfony-users] Re: symfony + doctrine + MS SQL Server > > Did you find a fix/workaround for this? I've run into the same problem > > On Mar 10, 4:32 pm, Todd McNeill <todd.mcne...@pmigroup.com> wrote: > > Hi - > > > I'm new to Symfony and I have a small project that I wanted to start, > > but I'm having trouble building the schema using Doctrine/PDO/SQL > > Server. I'm running Symfony 1.2.4 on RHEL 5 with Apache 2.2.3. I'm > > using FreeTDS to communicate to my SQL Server, and I'm successfully > > connecting to the database both natively via FreeTDS and using ODBC > > (unixODBC). A small database has already been built with a few tables > > containing test data and referential integrity. I'm attempting to > > build the schema using the following command: > > > symfony doctrine:build-schema > > > While using the dblib DSN in my config/databases.yml file, I get the > > following error: > > > [sfException] > > unknown database attribute type: bigint > > > With the ODBC DSN, I get the following error: > > > [sfException] > > SQLSTATE[24000]: Invalid cursor state: 0 [unixODBC][Driver Manager] > > Invalid cursor state (SQLFetchScroll[0] at /var/tmp/PDO_ODBC/ > > odbc_stmt.c:372) > > > Any insight on how I should proceed? > > > Thanks, > > Todd --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---