Hello pythonista,
Thank you for replying.
I tried django-pyodbc-azure But syncdb didn't run yet.
As the website says, since I use Django 1.6.4,
I installed django-pyodbc-azure as "pip install "django-pyodbc-azure<1.2""
I checked the odbc driver by Control Panel > Administrative Tools > Data
Sources (ODBC) > "Driver" tab
My settings.py is as below.
DATABASES = {
'default': {
'ENGINE': 'sql_server.pyodbc',
'HOST': 'localhost', # I also tried 127.0.0.1
'PORT': '1433', # I also tried empty
'USER': 'djangouser',
'PASSWORD': 'xxxxx',
'NAME': 'db_test',
'OPTIONS': { # I also removed the OPTION
'driver': 'SQL Server Native Client 11.0', # I also change 'SQL
Server Native Client 10.0'
},
}
}
I tried to run syncdb command again, and then I got some errors again.
here are error messages.
django.db.utils.ProgrammingError: ('42000', '[42000] [Microsoft][ODBC SQL Server
Driver][SQL Server]
[42000] [Microsoft][ODBC SQL Server Driver][SQL Server]
[01S00] [Microsoft][ODBC SQL Server Driver]
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+unsubscr...@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/bc0eaa7a-3943-4091-a318-00c885352b0b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
