Re: MS SQLServer syncdb problem
On Nov 2, 11:40 am, MikeHowarth <[EMAIL PROTECTED]> wrote: > As far as I'm aware SQL Server isn't supported, there was a project > going a while ago but I think it has lost momentum. No, I think is supported right now: http://www.djangoproject.com/documentation/settings/#database-engine --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~--~~~~--~~--~--~---
Re: MS SQLServer syncdb problem
As far as I'm aware SQL Server isn't supported, there was a project going a while ago but I think it has lost momentum. On Nov 2, 11:36 am, lopes <[EMAIL PROTECTED]> wrote: > Hi, > I'm trying to make a syncdb and I've got the following message on > creating "auth_user" table, i've already installed pywin32-210.win32- > py2.5.exe and adodbapi. > > Any ideas? > > >python manage.py syncdb > > Creating table auth_message > Creating table auth_group > Creating table auth_user > Traceback (most recent call last): > File "manage.py", line 11, in > execute_manager(settings) > File "C:\Python25\lib\site-packages\django\core\management.py", line > 1672, in execute_manager > execute_from_command_line(action_mapping, argv) > File "C:\Python25\lib\site-packages\django\core\management.py", line > 1571, in execute_from_command_line > action_mapping[action](int(options.verbosity), > options.interactive) > File "C:\Python25\lib\site-packages\django\core\management.py", line > 534, in syncdb > cursor.execute(statement) > File "C:\Python25\lib\site-packages\django\db\backends\util.py", > line 12, in execute > return self.cursor.execute(sql, params) > File "build\bdist.win32\egg\adodbapi\adodbapi.py", line 713, in > execute > File "build\bdist.win32\egg\adodbapi\adodbapi.py", line 664, in > _executeHelper > File "build\bdist.win32\egg\adodbapi\adodbapi.py", line 474, in > _raiseCursorError > File "build\bdist.win32\egg\adodbapi\adodbapi.py", line 60, in > standardErrorHandler > adodbapi.adodbapi.DatabaseError: > --ADODBAPI > Traceback (most recent call last): >File "build\bdist.win32\egg\adodbapi\adodbapi.py", line 650, in > _executeHelper > adoRetVal=self.cmd.Execute() >File "", line 3, in Execute >File "c:\python25\lib\site-packages\pywin32-210-py2.5-win32.egg > \win32com\client\dynamic.py", line 258, in _ApplyTypes_ > result = self._oleobj_.InvokeTypes(*(dispid, LCID, wFlags, > retType, argTypes) + args) > com_error: (-2147352567, 'Ocorreu uma excep\xe7\xe3o.', (0, > 'Microsoft OLE DB Provider for SQL Server', "Line 1: Incorrect syntax > near 'DEFERRABLE'.", None, 0, > -2147217900), None) > -- on command: "ALTER TABLE [auth_message] ADD CONSTRAINT > user_id_refs_id_650f49a6 FOREIGN KEY ([user_id]) REFERENCES > [auth_user] ([id]) DEFERRABLE INITIALLY DE > FERRED;" > -- with parameters: () --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~--~~~~--~~--~--~---
MS SQLServer syncdb problem
Hi, I'm trying to make a syncdb and I've got the following message on creating "auth_user" table, i've already installed pywin32-210.win32- py2.5.exe and adodbapi. Any ideas? >python manage.py syncdb Creating table auth_message Creating table auth_group Creating table auth_user Traceback (most recent call last): File "manage.py", line 11, in execute_manager(settings) File "C:\Python25\lib\site-packages\django\core\management.py", line 1672, in execute_manager execute_from_command_line(action_mapping, argv) File "C:\Python25\lib\site-packages\django\core\management.py", line 1571, in execute_from_command_line action_mapping[action](int(options.verbosity), options.interactive) File "C:\Python25\lib\site-packages\django\core\management.py", line 534, in syncdb cursor.execute(statement) File "C:\Python25\lib\site-packages\django\db\backends\util.py", line 12, in execute return self.cursor.execute(sql, params) File "build\bdist.win32\egg\adodbapi\adodbapi.py", line 713, in execute File "build\bdist.win32\egg\adodbapi\adodbapi.py", line 664, in _executeHelper File "build\bdist.win32\egg\adodbapi\adodbapi.py", line 474, in _raiseCursorError File "build\bdist.win32\egg\adodbapi\adodbapi.py", line 60, in standardErrorHandler adodbapi.adodbapi.DatabaseError: --ADODBAPI Traceback (most recent call last): File "build\bdist.win32\egg\adodbapi\adodbapi.py", line 650, in _executeHelper adoRetVal=self.cmd.Execute() File "", line 3, in Execute File "c:\python25\lib\site-packages\pywin32-210-py2.5-win32.egg \win32com\client\dynamic.py", line 258, in _ApplyTypes_ result = self._oleobj_.InvokeTypes(*(dispid, LCID, wFlags, retType, argTypes) + args) com_error: (-2147352567, 'Ocorreu uma excep\xe7\xe3o.', (0, 'Microsoft OLE DB Provider for SQL Server', "Line 1: Incorrect syntax near 'DEFERRABLE'.", None, 0, -2147217900), None) -- on command: "ALTER TABLE [auth_message] ADD CONSTRAINT user_id_refs_id_650f49a6 FOREIGN KEY ([user_id]) REFERENCES [auth_user] ([id]) DEFERRABLE INITIALLY DE FERRED;" -- with parameters: () --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~--~~~~--~~--~--~---