You are trying to use the TCP/IP method to connect to SQL Server in your Django app (network library=dbmssocn). Have you configured TCP/IP access in SQL Server Configuration Manager? It is disabled by default for security reasons.
By default, SQL Server Management Studio uses named pipes to connect to your SQL Server instance. This is enabled by default. If you want to try using named pipes, change the Network library parameter in your connection string from DBMSSOCN to DBNMPNTW. 2010/6/9 CCC <qq263020...@gmail.com>: > .... That's the error message I copied from console... > I think it's a bug... > and unluckly django can't connect the newset mssql2008 success... > > On 6月8日, 下午4时48分, Sam Lai <samuel....@gmail.com> wrote: >> If you provide the entire error message, it might help. >> >> The excerpt you provided looks like it wasn't copied properly from the >> console - it is missing characters from the start of each line. >> >> 2010/6/8 CCC <qq263020...@gmail.com>: >> >> > ..... >> > I use mssql not mysql................ >> >> > On 6月8日, 下午3时57分, kanniga sivasubramanian <kskanniga...@gmail.com> >> > wrote: >> >> hello CCC, >> >> I think you didn't create the database in the mysql. >> >> First you create the database in mysql. And then you will >> >> change settings.py as a same database name. >> >> Finally you give the command python manage.py syncdb. >> >> >> On Tue, Jun 8, 2010 at 11:50 AM, CCC <qq263020...@gmail.com> wrote: >> >> > hi,now I use django-mssql and sqlserver2008, >> >> > but I found that it always appear some errors when I do some >> >> > command,for example:python manage.py syncdb >> >> > the error likes coding error is blow: >> >> > raise OperationalError(e, "Error opening connection: " + >> >> > connection_string) >> >> > ngo.db.backends.sqlserver_ado.dbapi.OperationalError: >> >> > (com_error(-2147352567, >> >> > xb7\xa2\xc9\xfa\xd2\xe2\xcd\xe2\xa1\xa3', (0, u'Microsoft OLE DB >> >> > Provider for >> >> > L Server', u'[DBNETLIB][ConnectionOpen (Connect()).]SQL Server \u4e0d >> >> > \u5b58\u >> >> > 8\u6216\u62d2\u7edd\u8bbf\u95ee\u3002', None, 0, -2147467259), None), >> >> > 'Error >> >> > ning connection: PROVIDER=SQLOLEDB;DATA >> >> > SOURCE=115.238.106.100,60433;Network >> >> > rary=DBMSSOCN;Initial Catalog=rvdb_1;UID=sa;PWD=asd.1234') >> >> >> > When I use Microsoft SQL Server Management studio client ,I can >> >> > success connect the database. >> >> > anyone can help ?Thanks >> >> >> > -- >> >> > You received this message because you are subscribed to the Google >> >> > Groups "Django users" group. >> >> > To post to this group, send email to django-us...@googlegroups.com. >> >> > To unsubscribe from this group, send email to >> >> > django-users+unsubscr...@googlegroups.com. >> >> > For more options, visit this group >> >> > athttp://groups.google.com/group/django-users?hl=en. >> >> > -- >> > You received this message because you are subscribed to the Google Groups >> > "Django users" group. >> > To post to this group, send email to django-us...@googlegroups.com. >> > To unsubscribe from this group, send email to >> > django-users+unsubscr...@googlegroups.com. >> > For more options, visit this group >> > athttp://groups.google.com/group/django-users?hl=en. > > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To post to this group, send email to django-us...@googlegroups.com. > To unsubscribe from this group, send email to > django-users+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/django-users?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-us...@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
