subject:"Trying to use Django 1.9.5, django_pyodbc, MS SQL Server 2012 on 64bit Windows 7"

Re: Trying to use Django 1.9.5, django_pyodbc, MS SQL Server 2012 on 64bit Windows 7

2016-08-11 Thread Constantine Covtushenko

Great job done.

You welcome!

Regards,

On Thu, Aug 11, 2016 at 8:46 PM, Evan Roberts 
wrote:

>
> Thanks for the help and guidance.  I found a solution. I installed these
> libs and was able to connect:
> Django (1.9.9)
> django-pyodbc-azure (1.9.9.0)
> pip (8.1.2)
> pyodbc (3.0.10)
>
> I connected using these settings:
> DATABASES = {
> 'default': {
> 'ENGINE': 'sql_server.pyodbc',
> 'HOST': '192.168.**.**',
> 'PORT': '1433',
> 'USER': '***',
> 'PASSWORD': '**',
> 'NAME': 'mydb',
> }
> }
>
> --
> 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 https://groups.google.com/group/django-users.
> To view this discussion on the web visit https://groups.google.com/d/
> msgid/django-users/d138baf7-f035-4b28-b6ab-0c279dbf5c0a%40googlegroups.com
> 
> .
>
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 https://groups.google.com/group/django-users.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/CAK52boX07%2BBV9wndgRzK49V%3DnuBvXePri3FBUZhsq42znErpMQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: Trying to use Django 1.9.5, django_pyodbc, MS SQL Server 2012 on 64bit Windows 7

2016-08-11 Thread Evan Roberts


Thanks for the help and guidance.  I found a solution. I installed these 
libs and was able to connect:
Django (1.9.9)
django-pyodbc-azure (1.9.9.0)
pip (8.1.2)
pyodbc (3.0.10)

I connected using these settings:
DATABASES = {
'default': {
'ENGINE': 'sql_server.pyodbc',
'HOST': '192.168.**.**',
'PORT': '1433',
'USER': '***',
'PASSWORD': '**',
'NAME': 'mydb',
}
}

-- 
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 https://groups.google.com/group/django-users.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/d138baf7-f035-4b28-b6ab-0c279dbf5c0a%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Trying to use Django 1.9.5, django_pyodbc, MS SQL Server 2012 on 64bit Windows 7

2016-08-11 Thread Evan Roberts


>
> Hi John,
>

Excellent suggestion.  Using python shell and pyodbc I was able to connect 
and perform several simple queries.  Just worked,  no heroics needed. I'm 
fairly sure my problem lies in django_pyodbc,  it is making sure the 
connection to the database is sane. I'm not sure the support for django 1.9 
is fully incorporated.

Here is my session with pyodbc:
PS F:\my_db\my_db> .\env\Scripts\Activate.ps1
(env) PS F:\my_db\my_db> python
Python 3.5.1 (v3.5.1:37a07cee5969, Dec  6 2015, 01:54:25) [MSC v.1900 64 
bit (AMD64)] on win32
Type "help", "copyright", "credits" or "license" for more information.
>>> import pyodbc
>>> cnxn = pyodbc.connect('DRIVER={SQL 
Server};SERVER=***;PORT=1433;DATABASE=my_db;UID=*;PWD=*')
>>> cursor = cnxn.cursor()
>>> cursor.execute("select name,siteid from cpd_customer")

>>> row=cursor.fetchone()
>>> row
('A***, *', '0001')
>>> row=cursor.fetchone()
>>> row
('A**', '00111')
>>> row = cursor.fetchone()
>>> row[0]
'A**'
>>> row[1]
'00111'
>>> row.name
'A**'
>>> row.siteid
'00111'
>>>


-- 
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 https://groups.google.com/group/django-users.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/6bbc3cdb-61e6-4c12-af4f-fdb7e1ee1d66%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Trying to use Django 1.9.5, django_pyodbc, MS SQL Server 2012 on 64bit Windows 7

2016-08-11 Thread Evan Roberts


>
> Hi Mike,


Thanks for the suggestion.  Yes, postgres would be a good answer, but not 
really a possibility at this point.  Let me give you the back ground. 
I inherited this project.  The original project is written using django 
0.95 and SQL Server 2003. The project that was written by a long departed 
employee in 2009.  Several other systems have started using the data in 
this database. Unless I want to update all of them to use the postgres, I'm 
stuck with MS SQL Server 2012.  

I'm also a big fan of not fighting your tools...

-- 
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 https://groups.google.com/group/django-users.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/6df5929e-48b0-4b04-98ac-9f56f309330f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Trying to use Django 1.9.5, django_pyodbc, MS SQL Server 2012 on 64bit Windows 7

2016-08-11 Thread John Fabiani

Prove to yourself that the pyodbc connection is working correctly without
django.

On Wed, Aug 10, 2016 at 6:37 PM, Mike Dewhirst 
wrote:

> On 11/08/2016 5:11 AM, Evan Roberts wrote:
>
>> I'm struggling to get a project going. I'm new to python and django.
>>
>> Is django_pyodbc supported on Python 3.5.1 and django 1.9? If not could
>> you suggest a combination of python & django that is known to work with
>> MS SQL Server 2012?
>>
>
> Not an answer to your specific question but a recommendation to use
> PostgreSQL instead. It works brilliantly on Windows and makes life serene.
> Much easier to gain python and django experience when the environment isn't
> fighting back. You can dump and pump later when you really need SQL Server.
>
> Mike
>
>
>>
>> Here are the details of my virtual environmentÂ
>>
>> windows 7 64 bit,Â
>>
>> python 3.5.1 64 bit,Â
>>
>> packages installed:
>>
>> |Django (1.9) django-pyodbc (0.4.1) pip (8.1.2) pyodbc (3.0.10) pywin32
>> (219) setuptools (19.1) wheel (0.26.0) |
>>
>>
>>
>> The database definition in settings.py:
>>
>> |DATABASES = { 'default': { 'ENGINE': 'django_pyodbc', 'HOST':
>> '192.168.10.47', 'PORT': '1433', 'USER': '*', 'PASSWORD':
>> '***', 'NAME': 'my_db', 'OPTIONS' : { 'driver' : 'SQL Server Native
>> Client 11.0', 'MARS_Connection' : True, 'driver_supports_utf8' : True,
>> }, } } |
>>
>>
>>
>> When I try to run the development server I'm getting these errors:
>>
>> |(my_db) PS F:\my_db\my_db> python .\manage.py runserver Performing
>> system checks... System check identified no issues (0 silenced).
>> DRIVER={SQL Server Native Client
>> 11.0};SERVER=192.168.10.47;PORT=1433;UID=*;PWD=**;
>> DATABASE=my_db;MARS_Connection=yes
>> Unhandled exception in thread started by > check_errors..wrapper at 0x04000D90> Traceback (most
>> recent call last): File
>> "C:\Users\eroberts\AppData\Local\Programs\Python\Python35\
>> lib\site-packages\django\utils\autoreload.py",
>> line 226, in wrapper fn(*args, **kwargs) File
>> "C:\Users\eroberts\AppData\Local\Programs\Python\Python35\
>> lib\site-packages\django\core\management\commands\runserver.py",
>> line 117, in inner_run self.check_migrations() File
>> "C:\Users\eroberts\AppData\Local\Programs\Python\Python35\
>> lib\site-packages\django\core\management\commands\runserver.py",
>> line 163, in check_migrations executor =
>> MigrationExecutor(connections[DEFAULT_DB_ALIAS]) File
>> "C:\Users\eroberts\AppData\Local\Programs\Python\Python35\
>> lib\site-packages\django\db\migrations\executor.py",
>> line 20, in __init__ self.loader = MigrationLoader(self.connection) File
>> "C:\Users\eroberts\AppData\Local\Programs\Python\Python35\
>> lib\site-packages\django\db\migrations\loader.py",
>> line 49, in __init__ self.build_graph() File
>> "C:\Users\eroberts\AppData\Local\Programs\Python\Python35\
>> lib\site-packages\django\db\migrations\loader.py",
>> line 176, in build_graph self.applied_migrations =
>> recorder.applied_migrations() File
>> "C:\Users\eroberts\AppData\Local\Programs\Python\Python35\
>> lib\site-packages\django\db\migrations\recorder.py",
>> line 65, in applied_migrations self.ensure_schema() File
>> "C:\Users\eroberts\AppData\Local\Programs\Python\Python35\
>> lib\site-packages\django\db\migrations\recorder.py",
>> line 56, in ensure_schema with self.connection.schema_editor() as
>> editor: File
>> "C:\Users\eroberts\AppData\Local\Programs\Python\Python35\
>> lib\site-packages\django\db\backends\base\base.py",
>> line 604, in schema_editor 'The SchemaEditorClass attribute of this
>> database wrapper is still None') NotImplementedError: The
>> SchemaEditorClass attribute of this database wrapper is still None|
>>
>> --
>> 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 https://groups.google.com/group/django-users.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/django-users/90dab5d0-2f51
>> -4bab-8b93-bdb6e507d6c6%40googlegroups.com
>> > 1-4bab-8b93-bdb6e507d6c6%40googlegroups.com?utm_medium=email
>> _source=footer>.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
> --
> 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 https://groups.google.com/group/django-users.
> To view this discussion on the web visit

Re: Trying to use Django 1.9.5, django_pyodbc, MS SQL Server 2012 on 64bit Windows 7

2016-08-10 Thread Mike Dewhirst


On 11/08/2016 5:11 AM, Evan Roberts wrote:

I'm struggling to get a project going. I'm new to python and django.

Is django_pyodbc supported on Python 3.5.1 and django 1.9? If not could
you suggest a combination of python & django that is known to work with
MS SQL Server 2012?


Not an answer to your specific question but a recommendation to use 
PostgreSQL instead. It works brilliantly on Windows and makes life 
serene. Much easier to gain python and django experience when the 
environment isn't fighting back. You can dump and pump later when you 
really need SQL Server.


Mike




Here are the details of my virtual environmentÂ

windows 7 64 bit,Â

python 3.5.1 64 bit,Â

packages installed:

|Django (1.9) django-pyodbc (0.4.1) pip (8.1.2) pyodbc (3.0.10) pywin32
(219) setuptools (19.1) wheel (0.26.0) |



The database definition in settings.py:

|DATABASES = { 'default': { 'ENGINE': 'django_pyodbc', 'HOST':
'192.168.10.47', 'PORT': '1433', 'USER': '*', 'PASSWORD':
'***', 'NAME': 'my_db', 'OPTIONS' : { 'driver' : 'SQL Server Native
Client 11.0', 'MARS_Connection' : True, 'driver_supports_utf8' : True,
}, } } |



When I try to run the development server I'm getting these errors:

|(my_db) PS F:\my_db\my_db> python .\manage.py runserver Performing
system checks... System check identified no issues (0 silenced).
DRIVER={SQL Server Native Client
11.0};SERVER=192.168.10.47;PORT=1433;UID=*;PWD=**;DATABASE=my_db;MARS_Connection=yes
Unhandled exception in thread started by .wrapper at 0x04000D90> Traceback (most
recent call last): File
"C:\Users\eroberts\AppData\Local\Programs\Python\Python35\lib\site-packages\django\utils\autoreload.py",
line 226, in wrapper fn(*args, **kwargs) File
"C:\Users\eroberts\AppData\Local\Programs\Python\Python35\lib\site-packages\django\core\management\commands\runserver.py",
line 117, in inner_run self.check_migrations() File
"C:\Users\eroberts\AppData\Local\Programs\Python\Python35\lib\site-packages\django\core\management\commands\runserver.py",
line 163, in check_migrations executor =
MigrationExecutor(connections[DEFAULT_DB_ALIAS]) File
"C:\Users\eroberts\AppData\Local\Programs\Python\Python35\lib\site-packages\django\db\migrations\executor.py",
line 20, in __init__ self.loader = MigrationLoader(self.connection) File
"C:\Users\eroberts\AppData\Local\Programs\Python\Python35\lib\site-packages\django\db\migrations\loader.py",
line 49, in __init__ self.build_graph() File
"C:\Users\eroberts\AppData\Local\Programs\Python\Python35\lib\site-packages\django\db\migrations\loader.py",
line 176, in build_graph self.applied_migrations =
recorder.applied_migrations() File
"C:\Users\eroberts\AppData\Local\Programs\Python\Python35\lib\site-packages\django\db\migrations\recorder.py",
line 65, in applied_migrations self.ensure_schema() File
"C:\Users\eroberts\AppData\Local\Programs\Python\Python35\lib\site-packages\django\db\migrations\recorder.py",
line 56, in ensure_schema with self.connection.schema_editor() as
editor: File
"C:\Users\eroberts\AppData\Local\Programs\Python\Python35\lib\site-packages\django\db\backends\base\base.py",
line 604, in schema_editor 'The SchemaEditorClass attribute of this
database wrapper is still None') NotImplementedError: The
SchemaEditorClass attribute of this database wrapper is still None|

--
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 https://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/90dab5d0-2f51-4bab-8b93-bdb6e507d6c6%40googlegroups.com
.
For more options, visit https://groups.google.com/d/optout.


--
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 https://groups.google.com/group/django-users.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/69a83296-7540-755f-898c-241a831cb6bf%40dewhirst.com.au.
For more options, visit https://groups.google.com/d/optout.

Trying to use Django 1.9.5, django_pyodbc, MS SQL Server 2012 on 64bit Windows 7

2016-08-10 Thread Evan Roberts



I'm struggling to get a project going. I'm new to python and django.

Is django_pyodbc supported on Python 3.5.1 and django 1.9? If not could you 
suggest a combination of python & django that is known to work with MS SQL 
Server 2012?


Here are the details of my virtual environment 

windows 7 64 bit, 

python 3.5.1 64 bit, 

packages installed:

Django (1.9)
django-pyodbc (0.4.1)
pip (8.1.2)
pyodbc (3.0.10)
pywin32 (219)
setuptools (19.1)
wheel (0.26.0)



The database definition in settings.py:

DATABASES = {
'default': {
'ENGINE': 'django_pyodbc',
'HOST': '192.168.10.47',
'PORT': '1433',
'USER': '*',
'PASSWORD': '***',
'NAME': 'my_db',
'OPTIONS' : {
'driver' : 'SQL Server Native Client 11.0',
'MARS_Connection' : True,
'driver_supports_utf8' : True,
},
}
}



When I try to run the development server I'm getting these errors:

(my_db) PS F:\my_db\my_db> python .\manage.py runserver
Performing system checks...

System check identified no issues (0 silenced).
DRIVER={SQL Server Native Client 
11.0};SERVER=192.168.10.47;PORT=1433;UID=*;PWD=**;DATABASE=my_db;MARS_Connection=yes
Unhandled exception in thread started by .wrapper at 0x04000D90>
Traceback (most recent call last):
  File 
"C:\Users\eroberts\AppData\Local\Programs\Python\Python35\lib\site-packages\django\utils\autoreload.py",
 line 226, in wrapper
fn(*args, **kwargs)
  File 
"C:\Users\eroberts\AppData\Local\Programs\Python\Python35\lib\site-packages\django\core\management\commands\runserver.py",
 line 117, in inner_run
self.check_migrations()
  File 
"C:\Users\eroberts\AppData\Local\Programs\Python\Python35\lib\site-packages\django\core\management\commands\runserver.py",
 line 163, in check_migrations
executor = MigrationExecutor(connections[DEFAULT_DB_ALIAS])
  File 
"C:\Users\eroberts\AppData\Local\Programs\Python\Python35\lib\site-packages\django\db\migrations\executor.py",
 line 20, in __init__
self.loader = MigrationLoader(self.connection)
  File 
"C:\Users\eroberts\AppData\Local\Programs\Python\Python35\lib\site-packages\django\db\migrations\loader.py",
 line 49, in __init__
self.build_graph()
  File 
"C:\Users\eroberts\AppData\Local\Programs\Python\Python35\lib\site-packages\django\db\migrations\loader.py",
 line 176, in build_graph
self.applied_migrations = recorder.applied_migrations()
  File 
"C:\Users\eroberts\AppData\Local\Programs\Python\Python35\lib\site-packages\django\db\migrations\recorder.py",
 line 65, in applied_migrations
self.ensure_schema()
  File 
"C:\Users\eroberts\AppData\Local\Programs\Python\Python35\lib\site-packages\django\db\migrations\recorder.py",
 line 56, in ensure_schema
with self.connection.schema_editor() as editor:
  File 
"C:\Users\eroberts\AppData\Local\Programs\Python\Python35\lib\site-packages\django\db\backends\base\base.py",
 line 604, in schema_editor
'The SchemaEditorClass attribute of this database wrapper is still None')
NotImplementedError: The SchemaEditorClass attribute of this database wrapper 
is still None

-- 
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 https://groups.google.com/group/django-users.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/90dab5d0-2f51-4bab-8b93-bdb6e507d6c6%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Trying to use Django 1.9.5, django_pyodbc, MS SQL Server 2012 on 64bit Windows 7

Re: Trying to use Django 1.9.5, django_pyodbc, MS SQL Server 2012 on 64bit Windows 7

Re: Trying to use Django 1.9.5, django_pyodbc, MS SQL Server 2012 on 64bit Windows 7

Re: Trying to use Django 1.9.5, django_pyodbc, MS SQL Server 2012 on 64bit Windows 7

Re: Trying to use Django 1.9.5, django_pyodbc, MS SQL Server 2012 on 64bit Windows 7

Re: Trying to use Django 1.9.5, django_pyodbc, MS SQL Server 2012 on 64bit Windows 7

Trying to use Django 1.9.5, django_pyodbc, MS SQL Server 2012 on 64bit Windows 7

7 matches

Site Navigation

Mail list logo

Footer information