Re: I can't syncdb via django_pyodbc of Django.

I use SQL Server Japanese edition.

So, I also wrote Japanese error message here.

django.db.utils.ProgrammingError: ('42000', '[42000] [Microsoft][ODBC SQL Server Driver][SQL Server]このログインで要求されたデータベース "db_test"   を開けません。ログインに失敗しました。 (4060) (SQLDriverConnect);  [01S00] [Microsoft][ODBC SQL Server Driver]接続文字列の属性が正しくありません。 (0);  [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]  このログインで要求されたデータベース "shannon_test" を開けません。ログインに失敗しました。 (4060); [01S00] [Microsoft][ODBC SQL Server Driver]接続文字列の属性が正しくありません。 (0)')  

更新 時間を記録 ウォッチをやめる コピー

2014年12月11日木曜日 1時58分58秒 UTC+9 pythonista:

I can actually help you here.

I had the same problem and tried 4 different modules.

The only module that works with sql server is 

https://github.com/michiya/django-pyodbc-azure

I am running it both on windows and linux, simultaneously.

The settings components are displayed on the web site.

Works like a charm

One dependency is pyodbc to be installed.

On Wednesday, December 10, 2014 4:22:44 AM UTC-5, Sugita Shinsuke wrote:

Hi there.    Could you tell me a good way to use Django with Micro Soft DB SQL server. I tried django_pyodbc. Any suggestion is appreciated.    my PC of Environment is below.    Database:  SQL Server 2014 Express    OS:  Windows 7 Home Premium SP1    I used the django module, django_pyodbc.  And, I tried to run syncdb but I couldn't.    My settings.py is below.    DATABASES = {     'default': {         'ENGINE': "django_pyodbc",         'HOST': "localhost",         'USER': "djangouser",         'PASSWORD': "xxxxx",         'NAME': "db_test",         'OPTIONS': {              'host_is_server': True,              'autocommit': True,              'unicode_results': True,              'extra_params': 'tds_version=8.0'          },     }  }    Things I tried and did not work:  1,change "localhost" to "127.0.0.1,1433" in the HOST property of the code.  2,removed 'OPTIONS'.      However, I tried the module pyodbc of pure python like below. It was fine.    ---  conn = pyodbc.connect('driver={SQL Server};server=localhost;UID=djangouser;PWD=xxxxx;DATABASE=shannon_test;Trusted_Connection=yes')  ---    But, DB connection is not established without "Trusted_Connection=yes".  At least I do not know any other way. Anyone who know this matter, please help.


The error message is here.
----
pyodbc.ProgrammingError: ('42000', '[42000] [Microsoft][ODBC SQL Server Driver][  SQL Server]\x82\xb1\x82\xcc\x83\x8d\x83O\x83C\x83\x93\x82\xc5\x97v\x8b\x81\x82\x  b3\x82\xea\x82\xbd\x83f\x81[\x83^\x83x\x81[\x83X "shannon_test" \x82\xf0\x8aJ\x8  2\xaf\x82\xdc\x82\xb9\x82\xf1\x81B\x83\x8d\x83O\x83C\x83\x93\x82\xc9\x8e\xb8\x94  s\x82\xb5\x82\xdc\x82\xb5\x82\xbd\x81B (4060) (SQLDriverConnect); [01S00] [Micro  soft][ODBC SQL Server Driver]\x90\xda\x91\xb1\x95\xb6\x8e\x9a\x97\xf1\x82\xcc\x9  1\xae\x90\xab\x82\xaa\x90\xb3\x82\xb5\x82\xad\x82\xa0\x82\xe8\x82\xdc\x82\xb9\x8  2\xf1\x81B (0); [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]\x82\xb1\  x82\xcc\x83\x8d\x83O\x83C\x83\x93\x82\xc5\x97v\x8b\x81\x82\xb3\x82\xea\x82\xbd\x  83f\x81[\x83^\x83x\x81[\x83X "shannon_test" \x82\xf0\x8aJ\x82\xaf\x82\xdc\x82\xb  9\x82\xf1\x81B\x83\x8d\x83O\x83C\x83\x93\x82\xc9\x8e\xb8\x94s\x82\xb5\x82\xdc\x8  2\xb5\x82\xbd\x81B (4060); [01S00] [Microsoft][ODBC SQL Server Driver]\x90\xda\x  91\xb1\x95\xb6\x8e\x9a\x97\xf1\x82\xcc\x91\xae\x90\xab\x82\xaa\x90\xb3\x82\xb5\x  82\xad\x82\xa0\x82\xe8\x82\xdc\x82\xb9\x82\xf1\x81B (0)')  ----  

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/e7ec8df4-307b-451f-bcf4-b01dfa57f6bc%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.