views:

63

answers:

1

I am using django-mssql and SQL Server 2008, but I found that it always errors when I do some commands,for example:

python manage.py syncdb

the error is below:

raise OperationalError(e, "Error opening connection: " + connection_string) sqlserver_ado.dbapi.OperationalError: (com_error(-2147352567, '\xb7\xa2\xc9\xfa\ xd2\xe2\xcd\xe2\xa1\xa3', (0, u'Microsoft OLE DB Provider for SQL Server', u"\u7 528\u6237 'sa' \u767b\u5f55\u5931\u8d25\u3002", None, 0, -2147217843), None), 'E rror opening connection: PROVIDER=SQLOLEDB;DATA SOURCE=115.238.106.101,60433;Net work Library=DBMSSOCN;Initial Catalog=rvdb_2;UID=sa;PWD=xxx')

When I use Microsoft SQL Server Management studio client, I can successfully connect the database.

I got some infomation from: http://code.google.com/p/django-mssql/issues/detail?id=76 but I still tried I got wrong and I think the solution provided is wrong.

A: 

@Daniel DiPaolo Thant's the message I copied from consle. and I am sure that's all.... as I know this is because the newer mssql2008 is hardcoded.. you can see the url http://code.google.com/p/django-mssql/issues/detail?id=76 but I can't get it out...I think his code is wrong

It can't possibly be, part of the traceback is quite obviously cut off: `ngo.db.backends.sqlserver_ado.dbapi.OperationalError:` should be `django.db.backends.sqlserver_ado.dbapi.OperationalError:` - if you used the Windows console I'm guessing you missed the first three columns of copying.
Daniel DiPaolo
this one.....and I have change password raise OperationalError(e, "Error opening connection: " + connection_string)sqlserver_ado.dbapi.OperationalError: (com_error(-2147352567, '\xb7\xa2\xc9\xfa\xd2\xe2\xcd\xe2\xa1\xa3', (0, u'Microsoft OLE DB Provider for SQL Server', u"\u7528\u6237 'sa' \u767b\u5f55\u5931\u8d25\u3002", None, 0, -2147217843), None), 'Error opening connection: PROVIDER=SQLOLEDB;DATA SOURCE=115.238.106.101,60433;Network Library=DBMSSOCN;Initial Catalog=rvdb_2;UID=sa;PWD=xxx')
this problem is obviously the code error.and I google tell me the newer mssql2008 is hardcode,can't change it...AND I use django1.1 toconnect it