Re: [42S22] [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Invalid column name 'p_comments'

[Dimitris Kougioumtzis]

I had the same  problem 

Some ware in  your code you  loop the model that you want to make the 
changes so a solution is to comment the code temporally so you can proceed 
with your migrations 



On Friday, January 31, 2020 at 5:29:20 PM UTC+2 mahesh goud wrote:

> Hi All,
>
> I am trying to add new fiels to mode and migrate these to db. it is giving 
> me below error. Can someone help me? I am blocked to 2 weeks. Screen shot 
> attached
>
> [image: djangomigrationerror.PNG]
>
>

-- 
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 view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/de963780-e0f3-4094-8e83-4bb621f540cbn%40googlegroups.com.

Re: Facing Issue with ODBC Driver 17 for SQL Server

[David Nugent]

Hi Sahan,

"the target machine actively refused it” - in TCP parlance, that means 
that there’s nothing listening on that port, aka “connection refused”. 
The server you are trying to connect to isn’t there (or there is a 
firewall similar blocking the connection - but doubt it).


IIRC by default SQL Server runs each instance on its own port, and uses 
a broker (aka “browser service”) to determine which instance you are 
connecting to (on port 1434?). See this link for more info:


https://learn.microsoft.com/en-us/sql/sql-server/install/configure-the-windows-firewall-to-allow-sql-server-access?view=sql-server-ver16

Again, from memory (which may not be accurate), each instance may have a 
“dynamic port” allocated but will consistently expose itself on the same 
port each time it is started. So locking in a particular port in Django 
is normally ok. You just need to determine what port that is. :-)


The db connector in Django knows or understands the dynamic connection 
strategy that SQL Server uses, but needs the port number directly 
assigned to the instance..


HTH,
/d


-- Original Message --

From "Sahan Srinivas" <26sa...@gmail.com>

To "Django users" 
Date 2/11/2023 3:48:49 AM
Subject Facing Issue with ODBC Driver 17 for SQL Server


Hi All,

I am facing an issue with the DJANGO SQL Driver below is the 
screenshot, It is showing the error as


django.db.utils.OperationalError: ('08001', '[08001] [Microsoft][ODBC 
Driver 17 for SQL Server]TCP Provider: No connection could be made 
because the target machine actively refused it.\r\n (10061) 
(SQLDriverConnect)


Below are my Database details in settings.py file.

DATABASES ={
'default':{
'ENGINE':"sql_server.pyodbc",
'NAME':"IRIS",
'USER':"sa",
'PASSWORD':'admin123#',
'HOST':'Pegasus\MSSQLSERVER2022',
'PORT':'1433',
'OPTIONS':{
'driver':'ODBC Driver 17 for SQL Server',
},
  },
}

Can anyone help me out? The driver's are installed, the same I can run 
using SQL alchemy


Kind Regards,
Sahan



--
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 view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/208fbabc-c1c9-4770-8428-0679927a6005n%40googlegroups.com 
<https://groups.google.com/d/msgid/django-users/208fbabc-c1c9-4770-8428-0679927a6005n%40googlegroups.com?utm_medium=email_source=footer>.


--
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 view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/em38f13ab2-5dc4-4215-bc66-117f4dd523a5%403845105e.com.


pgphTcO8orPEF.pgp
Description: PGP signature

Re: python manage.py magrate gives the below error with SQL SERVER (Please help)

['Amitesh Sahay' via Django users]

check your database table though some UI. make sure that the " polls_question" 
is not there  

On Tuesday, 10 August, 2021, 07:20:42 pm IST, Vikram Gajjala 
 wrote:  
 
 SQL Server 2019Python  3.9.6pip  21.2.3python -m django --version 3.2.6
asgiref              3.4.1astroid              2.6.6colorama             
0.4.4Django               3.2.6django-mssql-backend 2.8.1django-pyodbc        
1.1.3django-tastypie      0.14.3isort                5.9.3lazy-object-proxy    
1.6.0mccabe               0.6.1pip                  21.2.3pylint               
2.9.6pyodbc               4.0.31python-dateutil      2.8.2python-mimeparse     
1.6.0pytz                 2021.1setuptools           56.0.0six                  
1.16.0sqlparse             0.4.1toml                 0.10.2wrapt                
1.12.1

(mysite) C:\Python_Vik\mysite\myfirstsite>python manage.py migrateOperations to 
perform:  Apply all migrations: admin, auth, contenttypes, polls, 
sessionsRunning migrations:  Applying polls.0004_choice_question...Traceback 
(most recent call last):  File 
"C:\Python_Vik\mysite\lib\site-packages\django\db\backends\utils.py", line 82, 
in _execute    return self.cursor.execute(sql)  File 
"C:\Python_Vik\mysite\lib\site-packages\sql_server\pyodbc\base.py", line 553, 
in execute    return self.cursor.execute(sql, params)pyodbc.ProgrammingError: 
('42S01', "[42S01] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]There 
is already an object named 'polls_question' in the database. (2714) 
(SQLExecDirectW)")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):  File 
"C:\Python_Vik\mysite\myfirstsite\manage.py", line 22, in     main()  
File "C:\Python_Vik\mysite\myfirstsite\manage.py", line 18, in main    
execute_from_command_line(sys.argv)  File 
"C:\Python_Vik\mysite\lib\site-packages\django\core\management\__init__.py", 
line 419, in execute_from_command_line    utility.execute()  File 
"C:\Python_Vik\mysite\lib\site-packages\django\core\management\__init__.py", 
line 413, in execute    self.fetch_command(subcommand).run_from_argv(self.argv) 
 File "C:\Python_Vik\mysite\lib\site-packages\django\core\management\base.py", 
line 354, in run_from_argv    self.execute(*args, **cmd_options)  File 
"C:\Python_Vik\mysite\lib\site-packages\django\core\management\base.py", line 
398, in execute    output = self.handle(*args, **options)  File 
"C:\Python_Vik\mysite\lib\site-packages\django\core\management\base.py", line 
89, in wrapped    res = handle_func(*args, **kwargs)  File 
"C:\Python_Vik\mysite\lib\site-packages\django\core\management\commands\migrate.py",
 line 244, in handle    post_migrate_state = executor.migrate(  File 
"C:\Python_Vik\mysite\lib\site-packages\django\db\migrations\executor.py", line 
117, in migrate    state = self._migrate_all_forwards(state, plan, full_plan, 
fake=fake, fake_initial=fake_initial)  File 
"C:\Python_Vik\mysite\lib\site-packages\django\db\migrations\executor.py", line 
147, in _migrate_all_forwards    state = self.apply_migration(state, migration, 
fake=fake, fake_initial=fake_initial)  File 
"C:\Python_Vik\mysite\lib\site-packages\django\db\migrations\executor.py", line 
227, in apply_migration    state = migration.apply(state, schema_editor)  File 
"C:\Python_Vik\mysite\lib\site-packages\django\db\migrations\migration.py", 
line 126, in apply    operation.database_forwards(self.app_label, 
schema_editor, old_state, project_state)  File 
"C:\Python_Vik\mysite\lib\site-packages\django\db\migrations\operations\models.py",
 line 92, in database_forwards    schema_editor.create_model(model)  File 
"C:\Python_Vik\mysite\lib\site-packages\sql_server\pyodbc\schema.py", line 809, 
in create_model    self.execute(sql, params or None)  File 
"C:\Python_Vik\mysite\lib\site-packages\sql_server\pyodbc\schema.py", line 872, 
in execute    cursor.execute(sql, params)  File 
"C:\Python_Vik\mysite\lib\site-packages\django\db\backends\utils.py", line 98, 
in execute    return super().execute(sql, params)  File 
"C:\Python_Vik\mysite\lib\site-packages\django\db\backends\utils.py", line 66, 
in execute    return self._execute_with_wrappers(sql, params, many=False, 
executor=self._execute)  File 
"C:\Python_Vik\mysite\lib\site-packages\django\db\backends\utils.py", line 75, 
in _execute_with_wrappers    return executor(sql, params, many, context)  File 
"C:\Python_Vik\mysite\lib\site-packages\django\db\backends\utils.py", line 84, 
in _execute    return self.cursor.execute(sql, params)  File 
"C:\Python_Vik\mysite\lib\site-packages\django\db\utils.py", line 90, in 
__exit__    raise dj_exc_value.with_traceback(traceback) from exc_value  File 
"C:\Python_Vik\mysite\lib\site-packages\django\db\b

python manage.py magrate gives the below error with SQL SERVER (Please help)

[Vikram Gajjala]

SQL Server 2019
Python 3.9.6
pip 21.2.3
python -m django --version 3.2.6

asgiref  3.4.1
astroid  2.6.6
colorama 0.4.4
Django   3.2.6
django-mssql-backend 2.8.1
django-pyodbc1.1.3
django-tastypie  0.14.3
isort5.9.3
lazy-object-proxy1.6.0
mccabe   0.6.1
pip  21.2.3
pylint   2.9.6
pyodbc   4.0.31
python-dateutil  2.8.2
python-mimeparse 1.6.0
pytz 2021.1
setuptools   56.0.0
six  1.16.0
sqlparse 0.4.1
toml 0.10.2
wrapt1.12.1


(mysite) C:\Python_Vik\mysite\myfirstsite>*python manage.py migrate*
Operations to perform:
  Apply all migrations: admin, auth, contenttypes, polls, sessions
Running migrations:
  Applying polls.0004_choice_question...Traceback (most recent call last):
  File 
"C:\Python_Vik\mysite\lib\site-packages\django\db\backends\utils.py", line 
82, in _execute
return self.cursor.execute(sql)
  File "C:\Python_Vik\mysite\lib\site-packages\sql_server\pyodbc\base.py", 
line 553, in execute
return self.cursor.execute(sql, params)
pyodbc.ProgrammingError: ('42S01', "[42S01] [Microsoft][ODBC Driver 17 for 
SQL Server][SQL Server]There is already an object named 'polls_question' in 
the database. (2714) (SQLExecDirectW)")

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "C:\Python_Vik\mysite\myfirstsite\manage.py", line 22, in 
main()
  File "C:\Python_Vik\mysite\myfirstsite\manage.py", line 18, in main
execute_from_command_line(sys.argv)
  File 
"C:\Python_Vik\mysite\lib\site-packages\django\core\management\__init__.py", 
line 419, in execute_from_command_line
utility.execute()
  File 
"C:\Python_Vik\mysite\lib\site-packages\django\core\management\__init__.py", 
line 413, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
  File 
"C:\Python_Vik\mysite\lib\site-packages\django\core\management\base.py", 
line 354, in run_from_argv
self.execute(*args, **cmd_options)
  File 
"C:\Python_Vik\mysite\lib\site-packages\django\core\management\base.py", 
line 398, in execute
output = self.handle(*args, **options)
  File 
"C:\Python_Vik\mysite\lib\site-packages\django\core\management\base.py", 
line 89, in wrapped
res = handle_func(*args, **kwargs)
  File 
"C:\Python_Vik\mysite\lib\site-packages\django\core\management\commands\migrate.py",
 
line 244, in handle
post_migrate_state = executor.migrate(
  File 
"C:\Python_Vik\mysite\lib\site-packages\django\db\migrations\executor.py", 
line 117, in migrate
state = self._migrate_all_forwards(state, plan, full_plan, fake=fake, 
fake_initial=fake_initial)
  File 
"C:\Python_Vik\mysite\lib\site-packages\django\db\migrations\executor.py", 
line 147, in _migrate_all_forwards
state = self.apply_migration(state, migration, fake=fake, 
fake_initial=fake_initial)
  File 
"C:\Python_Vik\mysite\lib\site-packages\django\db\migrations\executor.py", 
line 227, in apply_migration
state = migration.apply(state, schema_editor)
  File 
"C:\Python_Vik\mysite\lib\site-packages\django\db\migrations\migration.py", 
line 126, in apply
operation.database_forwards(self.app_label, schema_editor, old_state, 
project_state)
  File 
"C:\Python_Vik\mysite\lib\site-packages\django\db\migrations\operations\models.py",
 
line 92, in database_forwards
schema_editor.create_model(model)
  File 
"C:\Python_Vik\mysite\lib\site-packages\sql_server\pyodbc\schema.py", line 
809, in create_model
self.execute(sql, params or None)
  File 
"C:\Python_Vik\mysite\lib\site-packages\sql_server\pyodbc\schema.py", line 
872, in execute
cursor.execute(sql, params)
  File 
"C:\Python_Vik\mysite\lib\site-packages\django\db\backends\utils.py", line 
98, in execute
return super().execute(sql, params)
  File 
"C:\Python_Vik\mysite\lib\site-packages\django\db\backends\utils.py", line 
66, in execute
return self._execute_with_wrappers(sql, params, many=False, 
executor=self._execute)
  File 
"C:\Python_Vik\mysite\lib\site-packages\django\db\backends\utils.py", line 
75, in _execute_with_wrappers
return executor(sql, params, many, context)
  File 
"C:\Python_Vik\mysite\lib\site-packages\django\db\backends\utils.py", line 
84, in _execute
return self.cursor.execute(sql, params)
  File "C:\Python_Vik\mysite\lib\site-packages\django\db\utils.py", line 
90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
  File 
"C:\Python_Vik\mysite\lib\site-packages\django\db\backends\utils.py", line 
82, in _execute
return self.cursor.execute(sql)
  File "C:\Python_Vik\mysite\lib\

Re: Connect Django with SQL Server 2012

[Maurizio Faccin]

Hi Kasper,
thank you for your suggestion.
I resolved deleting all the parameters in datase settings.py and I 
rewrite them.

After that it works fine.
I think I written samething wrong and I didn't able to find this error.

Best regards,

Maurizio Faccin


Il 22/03/2021 17:05, Kasper Laudrup ha scritto:

On 22/03/2021 15.57, Maurizio Faccin wrote:

I tried to use the parameters above in a python script and works correctly.

What I can do to resolve this issue?


I don't think I can solve the issue, but it might help if you post the
relevant part of the Python script?

Then someone might be able to spot the difference.

Kind regards,

Kasper Laudrup



--
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 view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/79c1fc91-a3ea-9b0a-13be-1d3bfade3f03%40tiscali.it.

Re: Connect Django with SQL Server 2012

[Kasper Laudrup]

On 22/03/2021 15.57, Maurizio Faccin wrote:
> I tried to use the parameters above in a python script and works correctly.
> 
> What I can do to resolve this issue?
> 

I don't think I can solve the issue, but it might help if you post the
relevant part of the Python script?

Then someone might be able to spot the difference.

Kind regards,

Kasper Laudrup

-- 
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 view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/5e56ac19-0d71-a7bc-aacb-67921ae08205%40stacktrace.dk.

Connect Django with SQL Server 2012

[Maurizio Faccin]

Hello,
I have a problem tryng to connect Django with a SQL Server 2012 runnig 
on my pc.
I installed pyodb package and this is my connection parameters in 
settings.py


DATABASES = {
    'default': {
    'ENGINE': "sql_server.pyodbc",
    'NAME': "CD",
    'USER': "sa",
    'PASSWORD': "secret",
    'HOST': "NB30",
    'PORT': "1433",
        'OPTIONS': {
    'driver': 'ODBC Driver 13 for SQL Server',
    },
    },
}

I get this error:
django.db.utils.InterfaceError: ('28000', "[28000] [Microsoft][ODBC 
Driver 13 for SQL Server][SQL Server]Login failed for user 'user'. 
(18456) (SQLDriverConnect); [28000] [Microsoft][ODBC Driver 13 for SQL Ser
ver]Attributo di stringa di connessione non valido. (0); [28000] 
[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Login failed for 
user 'user'. (18456); [28000] [Microsoft][ODBC Driver 13 for SQL Server]A

ttributo di stringa di connessione non valido. (0)")

I tried to use the parameters above in a python script and works correctly.

What I can do to resolve this issue?

Thank you in advance


Maurizio Faccin

--
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 view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/f98b9f4d-d779-4778-6037-b8db16ee1595%40tiscali.it.

Re: Need Guidance to setup Django with MS SQL server

[Dvs Khamele]

Hi do you hire contract based python/django freelancer?
 We can help you in this and related tasks at fair prices. Reply or send
email to divy...@pythonmate.com
Best Regards,
Divyesh Khamele,
Pythonmate

On Thu, 8 Oct 2020, 12:06 am arun sahu,  wrote:

> Hi Geeks,
>
> I need your support for setting up my django project with MS SQL server.
>
> As there is no proper tutorial how to setup with MS SQL server. I tried it
> many times but failed with same errors. Please help me to progress.
>
> Tried below :
>  'ods_database': {
> 'ENGINE': 'sql_server.pyodbc',
> 'NAME': 'test',
> 'HOST': '***',
> 'PORT':'1433',
> 'USER': '***',
> 'PASSWORD': '***',
>
> 'OPTIONS':{
>     'driver': 'ODBC Driver 17 for SQL Server',
> }
> }
>
> Error:
>
> File
> "C:\Dropbox\React\DjangoReact\backend\env\lib\site-packages\sql_server\pyodbc\base.py",
> line 12, in 
> raise ImproperlyConfigured("Django %d.%d.%d is not supported." %
> VERSION[:3])
> django.core.exceptions.ImproperlyConfigured: Django 3.1.2 is not supported.
>
> Thanks,
> Arun
>
> --
> 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 view this discussion on the web visit
> https://groups.google.com/d/msgid/django-users/8972677a-651e-4465-8a94-5787e9ab4df9n%40googlegroups.com
> <https://groups.google.com/d/msgid/django-users/8972677a-651e-4465-8a94-5787e9ab4df9n%40googlegroups.com?utm_medium=email_source=footer>
> .
>

-- 
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 view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/CAH9mneVYg6dX%3Du_-Uar3JM91-XbGzh9CiXdr1yDU8UMwm1HAUA%40mail.gmail.com.

Re: Need Guidance to setup Django with MS SQL server

[Eugene TUYIZERE]

try this
https://django-mssql.readthedocs.io/en/latest/quickstart.html#dependencies
OR
https://stackoverflow.com/questions/43430091/connecting-django-with-mssql-server

On Wed, 7 Oct 2020 at 20:36, arun sahu  wrote:

> Hi Geeks,
>
> I need your support for setting up my django project with MS SQL server.
>
> As there is no proper tutorial how to setup with MS SQL server. I tried it
> many times but failed with same errors. Please help me to progress.
>
> Tried below :
>  'ods_database': {
> 'ENGINE': 'sql_server.pyodbc',
> 'NAME': 'test',
> 'HOST': '***',
> 'PORT':'1433',
> 'USER': '***',
> 'PASSWORD': '***',
>
> 'OPTIONS':{
>     'driver': 'ODBC Driver 17 for SQL Server',
> }
> }
>
> Error:
>
> File
> "C:\Dropbox\React\DjangoReact\backend\env\lib\site-packages\sql_server\pyodbc\base.py",
> line 12, in 
> raise ImproperlyConfigured("Django %d.%d.%d is not supported." %
> VERSION[:3])
> django.core.exceptions.ImproperlyConfigured: Django 3.1.2 is not supported.
>
> Thanks,
> Arun
>
> --
> 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 view this discussion on the web visit
> https://groups.google.com/d/msgid/django-users/8972677a-651e-4465-8a94-5787e9ab4df9n%40googlegroups.com
> <https://groups.google.com/d/msgid/django-users/8972677a-651e-4465-8a94-5787e9ab4df9n%40googlegroups.com?utm_medium=email_source=footer>
> .
>


-- 
*TUYIZERE Eugene*



*Msc Degree in Mathematical Science*

*African Institute for Mathematical Sciences (AIMS Cameroon)Crystal
Garden-Lime, Cameroon*

Bsc in Computer Science

*UR-Nyagatare Campus*

Email: eugene.tuyiz...@aims-cameroon.org
   eugenetuyiz...@gmail.com

Tel: (+250) 7 88 26 33 38, (+250) 7 22 26 33 38

-- 
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 view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/CABxpZHuw4zWoUhvajNy1EnyRyCsDR76EZ%3DExegvmU8_B-XHSUQ%40mail.gmail.com.

Need Guidance to setup Django with MS SQL server

[arun sahu]

Hi Geeks,

I need your support for setting up my django project with MS SQL server.

As there is no proper tutorial how to setup with MS SQL server. I tried it 
many times but failed with same errors. Please help me to progress.

Tried below :
 'ods_database': {
'ENGINE': 'sql_server.pyodbc',
'NAME': 'test',
'HOST': '***',
'PORT':'1433',
'USER': '***',
'PASSWORD': '***',

'OPTIONS':{
'driver': 'ODBC Driver 17 for SQL Server',
}
}

Error: 

File 
"C:\Dropbox\React\DjangoReact\backend\env\lib\site-packages\sql_server\pyodbc\base.py",
 
line 12, in 
raise ImproperlyConfigured("Django %d.%d.%d is not supported." % 
VERSION[:3])
django.core.exceptions.ImproperlyConfigured: Django 3.1.2 is not supported.

Thanks,
Arun

-- 
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 view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/8972677a-651e-4465-8a94-5787e9ab4df9n%40googlegroups.com.

Re: Unable to establish odbc connection to MS SQL Server

[Darren Williams]

Lets

On Apr 27, 2020 10:31 PM, "Gurmeet Kaur" 
wrote:

Hi There,

I have also implemented this in my project. The code in my settings.py is
below. You could also try the same.

DATABASES = {
'default': {
'ENGINE': 'sql_server.pyodbc',
'NAME': 'MyDbName',

'USER': 'user',
'PASSWORD': 'password',
'HOST': 'DbHost',
'OPTIONS': {
'driver': 'ODBC Driver 13 for SQL Server',
'unicode_results': True,

},
}
}

On Mon, Apr 27, 2020 at 10:22 PM Kirk Brown 
wrote:

> I'm getting an error when I try to runserver. Here is my code in manage.py:
>
> DATABASES = {
> 'default': {
> 'ENGINE': 'sql_server.pyodbc',
> 'NAME': 'database',
> 'HOST': 'localhost',
> 'USER': 'user',
> 'PASSWORD': 'password',
>
>     'OPTIONS': {'ODBC Driver 17 for SQL Server',
> }
> }
> }
>
>
> And here is the error:
>
> (venv) C:\Users\Kirk\PycharmProjects\PyShop>manage.py runserver
> Unhandled exception in thread started by  check_errors..wrapper at 0x01770CD61438>
> Traceback (most recent call last):
>   File
> "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\utils\autoreload.py",
> line 225, in wrapper
> fn(*args, **kwargs)
>   File
> "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\core\management\commands\runserver.py",
> line 109, in inner_run
> autoreload.raise_last_exception()
>   File
> "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\utils\autoreload.py",
> line 248, in raise_last_exception
> raise _exception[1]
>   File
> "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\core\management\__init__.py",
> line 337, in execute
> autoreload.check_errors(django.setup)()
>   File
> "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\utils\autoreload.py",
> line 225, in wrapper
> fn(*args, **kwargs)
>   File
> "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\__init__.py",
> line 24, in setup
> apps.populate(settings.INSTALLED_APPS)
>   File
> "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\apps\registry.py",
> line 112, in populate
> app_config.import_models()
>   File
> "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\apps\config.py",
> line 198, in import_models
> self.models_module = import_module(models_module_name)
>   File
> "C:\Users\Kirk\AppData\Local\Programs\Python\Python37\lib\importlib\__init__.py",
> line 127, in import_module
> return _bootstrap._gcd_import(name[level:], package, level)
>   File "", line 1006, in _gcd_import
>   File "", line 983, in _find_and_load
>   File "", line 967, in
> _find_and_load_unlocked
>   File "", line 677, in _load_unlocked
>   File "", line 728, in exec_module
>   File "", line 219, in
> _call_with_frames_removed
>   File
> "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\contrib\auth\models.py",
> line 2, in 
> from django.contrib.auth.base_user import AbstractBaseUser,
> BaseUserManager
>   File
> "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\contrib\auth\base_user.py",
> line 47, in 
> class AbstractBaseUser(models.Model):
>   File
> "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\db\models\base.py",
> line 101, in __new__
> new_class.add_to_class('_meta', Options(meta, app_label))
>   File
> "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\db\models\base.py",
> line 305, in add_to_class
> value.contribute_to_class(cls, name)
>   File
> "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\db\models\options.py",
> line 203, in contribute_to_class
> self.db_table = truncate_name(self.db_table,
> connection.ops.max_name_length())
>   File
> "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\db\__init__.py",
> line 33, in __getattr__
> return getattr(connections[DEFAULT_DB_ALIAS], item)
>   File
> "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\db\utils.py",
> line 203, in __getitem__
> conn = backend.DatabaseWrapper(db, alias)
>   File
> "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\sql_server\pyodbc\base.py",
> line 193, in __init__
> self.driver_charset = opts.get('driver_charset', None)
> AttributeError: 'set' object has no attribu

Re: Unable to establish odbc connection to MS SQL Server

[Gurmeet Kaur]

Hi There,

I have also implemented this in my project. The code in my settings.py is
below. You could also try the same.

DATABASES = {
'default': {
'ENGINE': 'sql_server.pyodbc',
'NAME': 'MyDbName',
'USER': 'user',
'PASSWORD': 'password',
'HOST': 'DbHost',
'OPTIONS': {
'driver': 'ODBC Driver 13 for SQL Server',
'unicode_results': True,

},
}
}

On Mon, Apr 27, 2020 at 10:22 PM Kirk Brown 
wrote:

> I'm getting an error when I try to runserver. Here is my code in manage.py:
>
> DATABASES = {
> 'default': {
> 'ENGINE': 'sql_server.pyodbc',
> 'NAME': 'database',
> 'HOST': 'localhost',
> 'USER': 'user',
> 'PASSWORD': 'password',
>
> 'OPTIONS': {'ODBC Driver 17 for SQL Server',
> }
> }
> }
>
>
> And here is the error:
>
> (venv) C:\Users\Kirk\PycharmProjects\PyShop>manage.py runserver
> Unhandled exception in thread started by  check_errors..wrapper at 0x01770CD61438>
> Traceback (most recent call last):
>   File
> "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\utils\autoreload.py",
> line 225, in wrapper
> fn(*args, **kwargs)
>   File
> "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\core\management\commands\runserver.py",
> line 109, in inner_run
> autoreload.raise_last_exception()
>   File
> "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\utils\autoreload.py",
> line 248, in raise_last_exception
> raise _exception[1]
>   File
> "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\core\management\__init__.py",
> line 337, in execute
> autoreload.check_errors(django.setup)()
>   File
> "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\utils\autoreload.py",
> line 225, in wrapper
> fn(*args, **kwargs)
>   File
> "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\__init__.py",
> line 24, in setup
> apps.populate(settings.INSTALLED_APPS)
>   File
> "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\apps\registry.py",
> line 112, in populate
> app_config.import_models()
>   File
> "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\apps\config.py",
> line 198, in import_models
> self.models_module = import_module(models_module_name)
>   File
> "C:\Users\Kirk\AppData\Local\Programs\Python\Python37\lib\importlib\__init__.py",
> line 127, in import_module
> return _bootstrap._gcd_import(name[level:], package, level)
>   File "", line 1006, in _gcd_import
>   File "", line 983, in _find_and_load
>   File "", line 967, in
> _find_and_load_unlocked
>   File "", line 677, in _load_unlocked
>   File "", line 728, in exec_module
>   File "", line 219, in
> _call_with_frames_removed
>   File
> "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\contrib\auth\models.py",
> line 2, in 
> from django.contrib.auth.base_user import AbstractBaseUser,
> BaseUserManager
>   File
> "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\contrib\auth\base_user.py",
> line 47, in 
> class AbstractBaseUser(models.Model):
>   File
> "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\db\models\base.py",
> line 101, in __new__
> new_class.add_to_class('_meta', Options(meta, app_label))
>   File
> "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\db\models\base.py",
> line 305, in add_to_class
> value.contribute_to_class(cls, name)
>   File
> "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\db\models\options.py",
> line 203, in contribute_to_class
> self.db_table = truncate_name(self.db_table,
> connection.ops.max_name_length())
>   File
> "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\db\__init__.py",
> line 33, in __getattr__
> return getattr(connections[DEFAULT_DB_ALIAS], item)
>   File
> "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\db\utils.py",
> line 203, in __getitem__
> conn = backend.DatabaseWrapper(db, alias)
>   File
> "C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\sql_server\pyodbc\base.py",
> line 193, in __init__
> self.driver_charset = opts.get('driver_charset', None)
> AttributeError: 'set' object has no attribute 'get'
>
>
> Any help is much appreciated. Thank you.
&

Unable to establish odbc connection to MS SQL Server

[Kirk Brown]

I'm getting an error when I try to runserver. Here is my code in manage.py:

DATABASES = {
'default': {
'ENGINE': 'sql_server.pyodbc',
'NAME': 'database',
'HOST': 'localhost',
'USER': 'user',
'PASSWORD': 'password',

'OPTIONS': {'ODBC Driver 17 for SQL Server',
}
}
}


And here is the error:

(venv) C:\Users\Kirk\PycharmProjects\PyShop>manage.py runserver
Unhandled exception in thread started by .wrapper at 0x01770CD61438>
Traceback (most recent call last):
  File 
"C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\utils\autoreload.py",
 
line 225, in wrapper
fn(*args, **kwargs)
  File 
"C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\core\management\commands\runserver.py",
 
line 109, in inner_run
autoreload.raise_last_exception()
  File 
"C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\utils\autoreload.py",
 
line 248, in raise_last_exception
raise _exception[1]
  File 
"C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\core\management\__init__.py",
 
line 337, in execute
autoreload.check_errors(django.setup)()
  File 
"C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\utils\autoreload.py",
 
line 225, in wrapper
fn(*args, **kwargs)
  File 
"C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\__init__.py",
 
line 24, in setup
apps.populate(settings.INSTALLED_APPS)
  File 
"C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\apps\registry.py",
 
line 112, in populate
app_config.import_models()
  File 
"C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\apps\config.py",
 
line 198, in import_models
self.models_module = import_module(models_module_name)
  File 
"C:\Users\Kirk\AppData\Local\Programs\Python\Python37\lib\importlib\__init__.py",
 
line 127, in import_module
return _bootstrap._gcd_import(name[level:], package, level)
  File "", line 1006, in _gcd_import
  File "", line 983, in _find_and_load
  File "", line 967, in _find_and_load_unlocked
  File "", line 677, in _load_unlocked
  File "", line 728, in exec_module
  File "", line 219, in 
_call_with_frames_removed
  File 
"C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\contrib\auth\models.py",
 
line 2, in 
from django.contrib.auth.base_user import AbstractBaseUser, 
BaseUserManager
  File 
"C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\contrib\auth\base_user.py",
 
line 47, in 
class AbstractBaseUser(models.Model):
  File 
"C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\db\models\base.py",
 
line 101, in __new__
new_class.add_to_class('_meta', Options(meta, app_label))
  File 
"C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\db\models\base.py",
 
line 305, in add_to_class
value.contribute_to_class(cls, name)
  File 
"C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\db\models\options.py",
 
line 203, in contribute_to_class
self.db_table = truncate_name(self.db_table, 
connection.ops.max_name_length())
  File 
"C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\db\__init__.py",
 
line 33, in __getattr__
return getattr(connections[DEFAULT_DB_ALIAS], item)
  File 
"C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\django\db\utils.py",
 
line 203, in __getitem__
conn = backend.DatabaseWrapper(db, alias)
  File 
"C:\Users\Kirk\PycharmProjects\PyShop\venv\lib\site-packages\sql_server\pyodbc\base.py",
 
line 193, in __init__
self.driver_charset = opts.get('driver_charset', None)
AttributeError: 'set' object has no attribute 'get'


Any help is much appreciated. Thank you.

-- 
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 view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/7f003a10-2c5e-472f-9bdc-eca8a2e277c1%40googlegroups.com.

Sql server and django

[hajar Benjat]

Hello django users I hope you are doing well!
I want to connect my django application and makemigrations with sql server
2008.
But I get some errors you can see below.
I hope you can help me.

Cordially

-- 
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 view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/CAMcj6WeHpbybL2U55OvmUDKyxMB0UjJur33zqKg6mFkUzFU-8w%40mail.gmail.com.

Re: [42S22] [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Invalid column name 'p_comments'

[mahesh goud]

Yes I am using latest updates

On Saturday, 1 February 2020 09:32:38 UTC+5:30, jlgimeno71 wrote:
>
> I know that SQL Server 2008 and 2012 had a regression that would issue 
> this error in some cases.  Have you ensured you're using the latest 
> updates?  I'm not sure what else to suggest here.
>
> -Jorge
>
> On Fri, Jan 31, 2020 at 7:28 AM mahesh goud  > wrote:
>
>> Hi All,
>>
>> I am trying to add new fiels to mode and migrate these to db. it is 
>> giving me below error. Can someone help me? I am blocked to 2 weeks. Screen 
>> shot attached
>>
>> [image: djangomigrationerror.PNG]
>>
>> -- 
>> 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...@googlegroups.com .
>> To view this discussion on the web visit 
>> https://groups.google.com/d/msgid/django-users/28c90c68-dd8d-4b60-a3a0-fe6b0da9f21b%40googlegroups.com
>>  
>> <https://groups.google.com/d/msgid/django-users/28c90c68-dd8d-4b60-a3a0-fe6b0da9f21b%40googlegroups.com?utm_medium=email_source=footer>
>> .
>>
>

-- 
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 view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/e036f7d9-dfae-4357-afbc-bb5a5dd0e745%40googlegroups.com.

how to connect django with SQL Server ?

[leb dev]

i have a django project that need to be connected with MS SQL Server . Iam 
using pyodbc package in order to make the connection but the problem is 
that once i try it it crash and display the below error :

djago.db.utils.operationalError:('08001','[08001] [microsoft][odbc sql 
server driver]neither dsn nor server keyword supplied (0) 
(sqldriverconnect); [08001] [microsoft][odbc sql server driver] Invalid 
connection string attribute (0)').

i tried with both authentication mode 

this is the views.py

from django.shortcuts import render
import pyodbc

def connect(request):
conn = pyodbc.connect(
'Driver={SQL Server};'
'Server=ip address;'
'Database=I-Base_beSQL;'
'Trusted_Connection=yes;'

)


cursor = conn.cursor()
c = cursor.execute('SELECT "first name" FROM Person   WHERE id = 2 ')

return render (request,'connect.html',{"c":c})



or 

from django.shortcuts import render
import pyodbc

def connect(request):
conn = pyodbc.connect(
        'Driver={SQL Server};'
'Server=ip address;'
'Database=I-Base_beSQL;'
'Trusted_Connection=no;'

 'UID=SQLTest;'

  'PWD=;'

)


cursor = conn.cursor()
c = cursor.execute('SELECT "first name" FROM Person   WHERE id = 2 ')

return render (request,'connect.html',{"c":c})

-- 
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 view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/f2b220b3-be7a-47eb-a6ae-d4b040ef7cc1%40googlegroups.com.

Establish a connection between django and SQL Server using pyodbc

[leb dev]

I have a django project that make a connection between django and SQL 
server  the problem is that once the system run it display the below error:

> djago.db.utils.operationalError:('08001','[08001] [microsoft][odbc sql
> server driver]neither dsn nor server keyword supplied (0)
> (sqldriverconnect); [08001] [microsoft][odbc sql server driver]
> Invalid connection string attribute (0)')

I know that the code 08001 mean *Client unable to establish connection*

But all the credentials are correct. What am I missing here?



views.py

from django.shortcuts import render
import pyodbc
   
def connect(request):
conn = pyodbc.connect(
    'Driver={SQL Server};'
'Server=ip address;'
'Database=I-Base_beSQL;'
'Trusted_Connection=yes;'

)


cursor = conn.cursor()
c = cursor.execute('SELECT "first name" FROM Person   WHERE id = 2 
')

return render (request,'connect.html',{"c":c})

connect.html

{% for row in c %}
{{ row }}
{% endfor %}

-- 
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 view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/7da39e65-4304-4929-98bb-ce19edab7372%40googlegroups.com.

Re: Connecting to SQL Server

[Joe Reitman]

When does this error occur? During runserver or when executing a commit 
from your model?

On Thursday, July 4, 2019 at 11:48:40 AM UTC-5, John Burke wrote:
>
> For this particular instance, I don't need the port number.
>
> On Thu, Jul 4, 2019 at 11:47 AM Joe Reitman  > wrote:
>
>> Don't you need to assign a port number?
>>
>> On Wednesday, July 3, 2019 at 6:52:35 PM UTC-5, John Burke wrote:
>>>
>>> Trying to connect to SQL Server from Django
>>>
>>> DATABASES = {
>>> 'default': {
>>> 'ENGINE': 'sql_server.pyodbc',
>>> 'NAME': 'dbname',
>>> 'HOST': 'hostname',
>>> 'PORT': '',
>>>     'USER': 'user',
>>> 'PASSWORD': 'password',
>>> 'OPTIONS': {
>>> 'driver': 'ODBC Driver 13 for SQL Server',
>>> },
>>> }
>>> }
>>>
>>>
>>> I get the following error:
>>> File "...\venv\lib\site-packages\sql_server\pyodbc\base.py", line 362, 
>>> in init_connection_state
>>> val = cursor.execute('SELECT SYSDATETIME()').fetchone()[0]
>>> ValueError: hour must be in 0..23
>>>
>>>
>>> -- 
>> 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...@googlegroups.com .
>> To post to this group, send email to django...@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/60dae4de-82b0-472c-987d-9fab48c37f0f%40googlegroups.com
>>  
>> <https://groups.google.com/d/msgid/django-users/60dae4de-82b0-472c-987d-9fab48c37f0f%40googlegroups.com?utm_medium=email_source=footer>
>> .
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
> -- 
> Regards,
> John B
>

-- 
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/b9b209fc-5795-44b3-ab65-8ea8b10563f3%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Connecting to SQL Server

[Adnan Sadzak]

Hi John,

You are probably passing datefirst as string while in your database 
datefirst column is int.
Can you please confirm you are not passing different data types?

Cheers,
Adnan

On Thursday, July 4, 2019 at 6:48:21 PM UTC+2, John Burke wrote:
>
> I don't actually supply the hour.  This is code in base.py.  
>
> The prior code sets up formatting:
>
> datefirst = options.get('datefirst', 7)
> cursor.execute('SET DATEFORMAT ymd; SET DATEFIRST %s' % datefirst)
>
> I wonder if it is not getting executed successfully.
>
>
> On Thu, Jul 4, 2019 at 11:10 AM Charlotte Wood <
> charlo...@epiccharterschools.org > wrote:
>
>> It looks as if you have an odd value in there for the hour.  Do you?
>>
>>
>> Charlotte Wood, MEd
>>
>> Educator
>>
>> (405) 578-5701
>>
>> Zoom Meeting ID#: 4055785701
>>
>> *Zoom URL:* https://epiccharterschools.zoom.us/j/2970513912
>>
>> Classroom Google Site: 
>> https://sites.google.com/epiccharterschools.org/charlottewoodclassroom/home
>>
>> Epic Technical Support: (405) 652-0935
>>
>>
>>
>> Jordan McKesson Principal
>>
>> 405-749-4550 ext. 309
>>
>> jordan@epiccharterschools.org 
>>
>> <http://facebook.com/epiccharterschools> 
>> <https://twitter.com/epiccharter> 
>> <https://www.instagram.com/epiccharterschools/> 
>> <https://www.youtube.com/user/EpicCharterSchools>
>>
>>
>>
>>
>> On Wed, Jul 3, 2019 at 6:52 PM John Burke > 
>> wrote:
>>
>>> Trying to connect to SQL Server from Django
>>>
>>> DATABASES = {
>>> 'default': {
>>> 'ENGINE': 'sql_server.pyodbc',
>>> 'NAME': 'dbname',
>>> 'HOST': 'hostname',
>>> 'PORT': '',
>>> 'USER': 'user',
>>> 'PASSWORD': 'password',
>>> 'OPTIONS': {
>>> 'driver': 'ODBC Driver 13 for SQL Server',
>>> },
>>> }
>>> }
>>>
>>>
>>> I get the following error:
>>> File "...\venv\lib\site-packages\sql_server\pyodbc\base.py", line 362, 
>>> in init_connection_state
>>> val = cursor.execute('SELECT SYSDATETIME()').fetchone()[0]
>>> ValueError: hour must be in 0..23
>>>
>>>
>>> -- 
>>> 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...@googlegroups.com .
>>> To post to this group, send email to django...@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/58c14df7-0b4e-49dd-a19e-11c1101ff947%40googlegroups.com
>>>  
>>> <https://groups.google.com/d/msgid/django-users/58c14df7-0b4e-49dd-a19e-11c1101ff947%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...@googlegroups.com .
>> To post to this group, send email to django...@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/CAPZR0N6yPmqDRwfbSXNwUHOCR3%3DDcgTM_Ez_DcM7FbxjAsSFGA%40mail.gmail.com
>>  
>> <https://groups.google.com/d/msgid/django-users/CAPZR0N6yPmqDRwfbSXNwUHOCR3%3DDcgTM_Ez_DcM7FbxjAsSFGA%40mail.gmail.com?utm_medium=email_source=footer>
>> .
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
> -- 
> Regards,
> John B
>

-- 
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/c532c7ff-2635-4e7d-a393-206d6d01634b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Connecting to SQL Server

[John Burke]

For this particular instance, I don't need the port number.

On Thu, Jul 4, 2019 at 11:47 AM Joe Reitman  wrote:

> Don't you need to assign a port number?
>
> On Wednesday, July 3, 2019 at 6:52:35 PM UTC-5, John Burke wrote:
>>
>> Trying to connect to SQL Server from Django
>>
>> DATABASES = {
>> 'default': {
>> 'ENGINE': 'sql_server.pyodbc',
>> 'NAME': 'dbname',
>> 'HOST': 'hostname',
>> 'PORT': '',
>> 'USER': 'user',
>> 'PASSWORD': 'password',
>> 'OPTIONS': {
>> 'driver': 'ODBC Driver 13 for SQL Server',
>> },
>> }
>> }
>>
>>
>> I get the following error:
>> File "...\venv\lib\site-packages\sql_server\pyodbc\base.py", line 362, in
>> init_connection_state
>> val = cursor.execute('SELECT SYSDATETIME()').fetchone()[0]
>> ValueError: hour must be in 0..23
>>
>>
>> --
> 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/60dae4de-82b0-472c-987d-9fab48c37f0f%40googlegroups.com
> <https://groups.google.com/d/msgid/django-users/60dae4de-82b0-472c-987d-9fab48c37f0f%40googlegroups.com?utm_medium=email_source=footer>
> .
> For more options, visit https://groups.google.com/d/optout.
>


-- 
Regards,
John B

-- 
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/CAFhYZ6CVS%2B4bJs0OwxK7KbY-mMgurvibpGOcmdFLYC_zJO0d3w%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: Connecting to SQL Server

[John Burke]

I don't actually supply the hour.  This is code in base.py.

The prior code sets up formatting:

datefirst = options.get('datefirst', 7)
cursor.execute('SET DATEFORMAT ymd; SET DATEFIRST %s' % datefirst)

I wonder if it is not getting executed successfully.


On Thu, Jul 4, 2019 at 11:10 AM Charlotte Wood <
charlotte.w...@epiccharterschools.org> wrote:

> It looks as if you have an odd value in there for the hour.  Do you?
>
>
> Charlotte Wood, MEd
>
> Educator
>
> (405) 578-5701
>
> Zoom Meeting ID#: 4055785701
>
> *Zoom URL:* https://epiccharterschools.zoom.us/j/2970513912
>
> Classroom Google Site:
> https://sites.google.com/epiccharterschools.org/charlottewoodclassroom/home
>
> Epic Technical Support: (405) 652-0935
>
>
>
> Jordan McKesson Principal
>
> 405-749-4550 ext. 309
>
> jordan.mckes...@epiccharterschools.org
>
> <http://facebook.com/epiccharterschools> <https://twitter.com/epiccharter>
> <https://www.instagram.com/epiccharterschools/>
> <https://www.youtube.com/user/EpicCharterSchools>
>
>
>
>
> On Wed, Jul 3, 2019 at 6:52 PM John Burke  wrote:
>
>> Trying to connect to SQL Server from Django
>>
>> DATABASES = {
>> 'default': {
>> 'ENGINE': 'sql_server.pyodbc',
>> 'NAME': 'dbname',
>>     'HOST': 'hostname',
>> 'PORT': '',
>> 'USER': 'user',
>> 'PASSWORD': 'password',
>> 'OPTIONS': {
>> 'driver': 'ODBC Driver 13 for SQL Server',
>> },
>> }
>> }
>>
>>
>> I get the following error:
>> File "...\venv\lib\site-packages\sql_server\pyodbc\base.py", line 362, in
>> init_connection_state
>> val = cursor.execute('SELECT SYSDATETIME()').fetchone()[0]
>> ValueError: hour must be in 0..23
>>
>>
>> --
>> 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/58c14df7-0b4e-49dd-a19e-11c1101ff947%40googlegroups.com
>> <https://groups.google.com/d/msgid/django-users/58c14df7-0b4e-49dd-a19e-11c1101ff947%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
> https://groups.google.com/d/msgid/django-users/CAPZR0N6yPmqDRwfbSXNwUHOCR3%3DDcgTM_Ez_DcM7FbxjAsSFGA%40mail.gmail.com
> <https://groups.google.com/d/msgid/django-users/CAPZR0N6yPmqDRwfbSXNwUHOCR3%3DDcgTM_Ez_DcM7FbxjAsSFGA%40mail.gmail.com?utm_medium=email_source=footer>
> .
> For more options, visit https://groups.google.com/d/optout.
>


-- 
Regards,
John B

-- 
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/CAFhYZ6CjQwQz7zQNJ6BSjFHN%2B-aYXvp1a09ZX76x3dbc0kkjWw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: Connecting to SQL Server

[Joe Reitman]

Don't you need to assign a port number?

On Wednesday, July 3, 2019 at 6:52:35 PM UTC-5, John Burke wrote:
>
> Trying to connect to SQL Server from Django
>
> DATABASES = {
> 'default': {
> 'ENGINE': 'sql_server.pyodbc',
> 'NAME': 'dbname',
> 'HOST': 'hostname',
> 'PORT': '',
> 'USER': 'user',
> 'PASSWORD': 'password',
> 'OPTIONS': {
>     'driver': 'ODBC Driver 13 for SQL Server',
> },
> }
> }
>
>
> I get the following error:
> File "...\venv\lib\site-packages\sql_server\pyodbc\base.py", line 362, in 
> init_connection_state
> val = cursor.execute('SELECT SYSDATETIME()').fetchone()[0]
> ValueError: hour must be in 0..23
>
>
>

-- 
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/60dae4de-82b0-472c-987d-9fab48c37f0f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Connecting to SQL Server

[Charlotte Wood]

It looks as if you have an odd value in there for the hour.  Do you?


Charlotte Wood, MEd

Educator

(405) 578-5701

Zoom Meeting ID#: 4055785701

*Zoom URL:* https://epiccharterschools.zoom.us/j/2970513912

Classroom Google Site:
https://sites.google.com/epiccharterschools.org/charlottewoodclassroom/home

Epic Technical Support: (405) 652-0935



Jordan McKesson Principal

405-749-4550 ext. 309

jordan.mckes...@epiccharterschools.org

<http://facebook.com/epiccharterschools> <https://twitter.com/epiccharter>
<https://www.instagram.com/epiccharterschools/>
<https://www.youtube.com/user/EpicCharterSchools>




On Wed, Jul 3, 2019 at 6:52 PM John Burke  wrote:

> Trying to connect to SQL Server from Django
>
> DATABASES = {
> 'default': {
> 'ENGINE': 'sql_server.pyodbc',
> 'NAME': 'dbname',
> 'HOST': 'hostname',
> 'PORT': '',
> 'USER': 'user',
> 'PASSWORD': 'password',
> 'OPTIONS': {
> 'driver': 'ODBC Driver 13 for SQL Server',
> },
> }
> }
>
>
> I get the following error:
> File "...\venv\lib\site-packages\sql_server\pyodbc\base.py", line 362, in
> init_connection_state
> val = cursor.execute('SELECT SYSDATETIME()').fetchone()[0]
> ValueError: hour must be in 0..23
>
>
> --
> 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/58c14df7-0b4e-49dd-a19e-11c1101ff947%40googlegroups.com
> <https://groups.google.com/d/msgid/django-users/58c14df7-0b4e-49dd-a19e-11c1101ff947%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 
https://groups.google.com/d/msgid/django-users/CAPZR0N6yPmqDRwfbSXNwUHOCR3%3DDcgTM_Ez_DcM7FbxjAsSFGA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Connecting to SQL Server

[John Burke]

Trying to connect to SQL Server from Django

DATABASES = {
'default': {
'ENGINE': 'sql_server.pyodbc',
'NAME': 'dbname',
'HOST': 'hostname',
'PORT': '',
'USER': 'user',
'PASSWORD': 'password',
'OPTIONS': {
'driver': 'ODBC Driver 13 for SQL Server',
},
}
}


I get the following error:
File "...\venv\lib\site-packages\sql_server\pyodbc\base.py", line 362, in 
init_connection_state
val = cursor.execute('SELECT SYSDATETIME()').fetchone()[0]
ValueError: hour must be in 0..23


-- 
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/58c14df7-0b4e-49dd-a19e-11c1101ff947%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Connecting to SQL Server

[John Burke]

Getting the following error:

  File "...\venv\lib\site-packages\sql_server\pyodbc\base.py", line 362, in 
init_connection_state
val = cursor.execute('SELECT SYSDATETIME()').fetchone()[0]
ValueError: hour must be in 0..23

-- 
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/4498b3d6-d65e-4ef2-a11d-82cddcd1b6a7%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Django Project Using Azure App Services Not Connecting to Azure SQL Server Through Active Directory

[Jorge William Pava Hernández]

We are experiencing a problem with the Python connection to an Azure SQL 
Server, when trying to use the Active Directory as method for 
authentication. The error says that the user is blank and the domain name 
is malformed. Anyone having the same issue? 

-- 
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/72dcd20b-5ede-42ce-9d62-22306c90e7d5%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: ms sql server connectivity to django

[Ivan Martić]

Hi mate,

I had the same issue with MS SQL.

This worked for me:
DATABASES = {
'default': {
'ENGINE': 'sql_server.pyodbc',
'HOST': 'xxx',
'PORT': '1433',

'USER': 'xxx',
'PASSWORD': 'xxx',
'NAME': 'xx',#table name
'CONN_MAX_AGE': 0,
'AUTOCOMMIT': True,

'OPTIONS': {
'driver': 'ODBC Driver 17 for SQL Server',
'host_is_server': True,
'autocommit': True,
'driver_needs_utf8': True,
'use_legacy_date_fields' : True,
},
}
}

You need to have pyodbc azure installed.

GL,
Ivan

-- 
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/7b00ad3b-8964-4b39-9eaa-4a204f45eb92%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: ms sql server connectivity to django

[Ivan Martić]

Hi Mate,

I had the same issues with connecting to MS SQL.
This is the configuration which worked for me...

DATABASES = {
'default': {
'ENGINE': 'sql_server.pyodbc',
'HOST': 'XXX',
'PORT': '1433',

'USER': 'XXX',
'PASSWORD': 'XXX',
'NAME': 'XXX', #name of your table
'CONN_MAX_AGE': 0,
'AUTOCOMMIT': True,

'OPTIONS': {
'driver': 'ODBC Driver 17 for SQL Server',
'host_is_server': True,
'autocommit': True,
'driver_needs_utf8': True,
'use_legacy_date_fields' : True,
},
}
}
You need to have pyodbc installed.

BR,
Ivan

On Sunday, January 6, 2019 at 6:56:09 PM UTC+1, Praveen Kumar wrote:
>
> Hi All,
>
> Changed DATABASE code as under in setting.py in Django project. But not 
> getting able to connect to MS SQL Server. Please suggest.
>
> ATABASES = {
> 'default': {
> 'NAME': 'APJ_AIM_LITE',
> 'ENGINE': 'sqlserver_ado',
> 'HOST': 'DB_SERVER',
> 'USER': '',
> 'PASSWORD': '',
> }
> }
>

-- 
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/c8366067-faf8-426a-b6d1-3b0e37a35e15%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

RE: ms sql server connectivity to django

[pahlawanto.pancawindu]

Make sure the port MSSQL is open.

 

From: django-users@googlegroups.com  On Behalf 
Of BALA KRISHNAN
Sent: 07 January 2019 13:34
To: django-users@googlegroups.com
Subject: Re: ms sql server connectivity to django

 

Create your database in MySQL

Migrate your files 

 

On Sun, 6 Jan 2019 at 23:25, Praveen Kumar mailto:kumar.pravee...@gmail.com> > wrote:

Hi All,

 

Changed DATABASE code as under in setting.py in Django project. But not getting 
able to connect to MS SQL Server. Please suggest.

 

ATABASES = {

'default': {

'NAME': 'APJ_AIM_LITE',

'ENGINE': 'sqlserver_ado',

'HOST': 'DB_SERVER',

'USER': '',

'PASSWORD': '',

}

}

-- 
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 
<mailto:django-users+unsubscr...@googlegroups.com> .
To post to this group, send email to django-users@googlegroups.com 
<mailto: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/ee503251-d646-4585-b773-0b1fc5b11c66%40googlegroups.com
 
<https://groups.google.com/d/msgid/django-users/ee503251-d646-4585-b773-0b1fc5b11c66%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 
<mailto:django-users+unsubscr...@googlegroups.com> .
To post to this group, send email to django-users@googlegroups.com 
<mailto: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/CAGxtV7ZZ-kEPQ7xuyOa%2B6wOOdzJmcNcDR2vihNNPLuqyQ%3DCuOQ%40mail.gmail.com
 
<https://groups.google.com/d/msgid/django-users/CAGxtV7ZZ-kEPQ7xuyOa%2B6wOOdzJmcNcDR2vihNNPLuqyQ%3DCuOQ%40mail.gmail.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 
https://groups.google.com/d/msgid/django-users/002801d4a654%248f32ecd0%24ad98c670%24%40gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: ms sql server connectivity to django

[Jani Tiainen]

Hi,

What happens? Do you get errors? Nothing?

On Sun, Jan 6, 2019 at 7:56 PM Praveen Kumar 
wrote:

> Hi All,
>
> Changed DATABASE code as under in setting.py in Django project. But not
> getting able to connect to MS SQL Server. Please suggest.
>
> ATABASES = {
> 'default': {
> 'NAME': 'APJ_AIM_LITE',
> 'ENGINE': 'sqlserver_ado',
> 'HOST': 'DB_SERVER',
> 'USER': '',
> 'PASSWORD': '',
> }
> }
>
> --
> 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/ee503251-d646-4585-b773-0b1fc5b11c66%40googlegroups.com
> <https://groups.google.com/d/msgid/django-users/ee503251-d646-4585-b773-0b1fc5b11c66%40googlegroups.com?utm_medium=email_source=footer>
> .
> For more options, visit https://groups.google.com/d/optout.
>


-- 
Jani Tiainen

- Well planned is half done, and a half done has been sufficient before...

-- 
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/CAHn91odB0TRc%2BKK1F5aER0FFuW3afeYZSC7ZM9tzsT%3D_s6ZUBw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: ms sql server connectivity to django

[BALA KRISHNAN]

Create your database in MySQL
Migrate your files

On Sun, 6 Jan 2019 at 23:25, Praveen Kumar 
wrote:

> Hi All,
>
> Changed DATABASE code as under in setting.py in Django project. But not
> getting able to connect to MS SQL Server. Please suggest.
>
> ATABASES = {
> 'default': {
> 'NAME': 'APJ_AIM_LITE',
> 'ENGINE': 'sqlserver_ado',
> 'HOST': 'DB_SERVER',
> 'USER': '',
> 'PASSWORD': '',
> }
> }
>
> --
> 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/ee503251-d646-4585-b773-0b1fc5b11c66%40googlegroups.com
> <https://groups.google.com/d/msgid/django-users/ee503251-d646-4585-b773-0b1fc5b11c66%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 
https://groups.google.com/d/msgid/django-users/CAGxtV7ZZ-kEPQ7xuyOa%2B6wOOdzJmcNcDR2vihNNPLuqyQ%3DCuOQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

ms sql server connectivity to django

[Praveen Kumar]

Hi All,

Changed DATABASE code as under in setting.py in Django project. But not 
getting able to connect to MS SQL Server. Please suggest.

ATABASES = {
'default': {
'NAME': 'APJ_AIM_LITE',
'ENGINE': 'sqlserver_ado',
'HOST': 'DB_SERVER',
'USER': '',
'PASSWORD': '',
}
}

-- 
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/ee503251-d646-4585-b773-0b1fc5b11c66%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Connecting Sql server to Django

[Rakhee Menon]

> Hey Vineeth,
>
 

> The last link which you gave worked like a pro..Thanks a lot for 
> it...Could you please help me out with one more issue...
>
As all my tables have been created in my old project I just want to 
access those tables using Django so without creating models how to access 
the table data?

   For eg: If PartyMaster is a table Using ORM one would have used it as 
PartyMaster.objects.get() however in the same manner how can I get or 
access data from database with models in Django??

  Thank You
  Regards
  Rakhee

-- 
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/2cd0eb21-74ec-425a-a8f0-f47765ded96a%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Connecting Sql server to Django

[Rakhee Menon]

Hey!VineethThanks a lot...It worked...

-- 
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/7e0b624e-1ed4-4199-87b7-3b3175285e27%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Connecting Sql server to Django

[Pradeep Singh]

thanks ..@mateusz now its working

On Mon, 15 Oct 2018 at 07:20, sum abiut  wrote:

> You can try sqlalchemy
> https://docs.sqlalchemy.org/en/latest/dialects/mssql.html#module-sqlalchemy.dialects.mssql.pymssql
>
>
> using the pymssql driver, you can do something like this
>
> from sqlalchemy import create_engine
>
> def connect(request):
> engine=create_engine('mssql+pymssql://username:password@hostname /db')
> connection=engine.connect()
>
> hope this helps.
>
>
> On Fri, Oct 12, 2018 at 3:26 PM Rakhee Menon 
> wrote:
>
>>
>>
>> Hi Everyone,
>>
>> In my project I want to connect SQL Server 2014 with django, I tried with
>> the given link,
>>
>>https://django-mssql.readthedocs.io/en/latest/quickstart.html
>>
>> but it shows some error like,
>>
>> import pythoncom
>> ImportError: No module named 'pythoncom''
>>
>> When I goggled the error it says download pywin32 but I didn't get any
>> file or link to download .Please could anyone help me out with this issue.
>>
>> Thanks in Advance
>> Rakhee
>>
>> --
>> 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/b1fe3c06-4e5e-45f7-b675-d4751b94337f%40googlegroups.com
>> <https://groups.google.com/d/msgid/django-users/b1fe3c06-4e5e-45f7-b675-d4751b94337f%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
> https://groups.google.com/d/msgid/django-users/CAPCf-y4G8LNZFDWXwTpR%2B0tn7fiHj2029qjNVVXmr5WSxEcnkw%40mail.gmail.com
> <https://groups.google.com/d/msgid/django-users/CAPCf-y4G8LNZFDWXwTpR%2B0tn7fiHj2029qjNVVXmr5WSxEcnkw%40mail.gmail.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 
https://groups.google.com/d/msgid/django-users/CANwgZcbgPgaSA%2BBXK3yWw2Vgo3USCduM8jL_yaF5cXPhG4kqBg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: Connecting Sql server to Django

[sum abiut]

You can try sqlalchemy
https://docs.sqlalchemy.org/en/latest/dialects/mssql.html#module-sqlalchemy.dialects.mssql.pymssql


using the pymssql driver, you can do something like this

from sqlalchemy import create_engine

def connect(request):
engine=create_engine('mssql+pymssql://username:password@hostname /db')
connection=engine.connect()

hope this helps.


On Fri, Oct 12, 2018 at 3:26 PM Rakhee Menon 
wrote:

>
>
> Hi Everyone,
>
> In my project I want to connect SQL Server 2014 with django, I tried with
> the given link,
>
>https://django-mssql.readthedocs.io/en/latest/quickstart.html
>
> but it shows some error like,
>
> import pythoncom
> ImportError: No module named 'pythoncom''
>
> When I goggled the error it says download pywin32 but I didn't get any
> file or link to download .Please could anyone help me out with this issue.
>
> Thanks in Advance
> Rakhee
>
> --
> 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/b1fe3c06-4e5e-45f7-b675-d4751b94337f%40googlegroups.com
> <https://groups.google.com/d/msgid/django-users/b1fe3c06-4e5e-45f7-b675-d4751b94337f%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 
https://groups.google.com/d/msgid/django-users/CAPCf-y4G8LNZFDWXwTpR%2B0tn7fiHj2029qjNVVXmr5WSxEcnkw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: Connecting Sql server to Django

[Gurmeet Kaur]

Can you please share your settings.py file and requirements.txt?

On Sun, Oct 14, 2018, 12:51 PM Pradeep Singh  wrote:

> please help me why i am getting no change detected
>
> On Sat, 13 Oct 2018 at 01:33, Gurmeet Kaur 
> wrote:
>
>> I did it in my project. Use pyodbc to connect to sql server and i am
>> using django 2.0.8
>>
>> On Fri, Oct 12, 2018, 11:04 AM Pradeep Singh 
>> wrote:
>>
>>> bro...will you help me ...
>>> i am getting django 404 error ...please tell how to fix it...
>>> i am using python 3.6 + django 1.11
>>>
>>> On Fri, 12 Oct 2018 at 19:35, vineeth sagar 
>>> wrote:
>>>
>>>> I don't know if it works for 1.8, you would've tested it by now. The
>>>> link I haven given is a current method to connect with sql server with
>>>> newer versions of django, also I think it's about time your company updated
>>>> your django version.  For 2.1 the link I have given works seemlessly.
>>>>
>>>>
>>>> On Oct 12, 2018 5:38 PM, "Jason"  wrote:
>>>>
>>>>> well, considering that 1.8 is no longer supported, you're not getting
>>>>> any backports and updates.  which if you're doing a production level app,
>>>>> is pretty bad.
>>>>>
>>>>> Unfortunately, seems if you want to use the recent LTS or newer
>>>>> versions, SQL server is not an option unless you're willing to update 
>>>>> those
>>>>> packages yourself for compatibility.
>>>>>
>>>>> --
>>>>> 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/078b932f-fde5-4eb5-9d59-4d66f43ff6f0%40googlegroups.com
>>>>> <https://groups.google.com/d/msgid/django-users/078b932f-fde5-4eb5-9d59-4d66f43ff6f0%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
>>>> https://groups.google.com/d/msgid/django-users/CAMMZq8OKW5ODFZpcxHhJKF1RBKrBQWGB1dDKCd7iJ6bRc%3DcDrw%40mail.gmail.com
>>>> <https://groups.google.com/d/msgid/django-users/CAMMZq8OKW5ODFZpcxHhJKF1RBKrBQWGB1dDKCd7iJ6bRc%3DcDrw%40mail.gmail.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
>>> https://groups.google.com/d/msgid/django-users/CANwgZcaiLs3RqawFDzYX%3Dtz3B3ye_FW7nudgDEw6BqkBFJm0Dg%40mail.gmail.com
>>> <https://groups.google.com/d/msgid/django-users/CANwgZcaiLs3RqawFDzYX%3Dtz3B3ye_FW7nudgDEw6BqkBFJm0Dg%40mail.gmail.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.

Re: Connecting Sql server to Django

[Mateusz]

Do you remember to save your work, as Atom does not auto-save by default? I 
can see the blue dot near the filename on the screenshot, indicating 
changes in the file that were not saved.
Check if testapp/apps.py contains config class with a name variable. 
Something similar to the code below:
from django.apps import AppConfig

class TestappConfig(AppConfig):
   name = 'testapp'




W dniu niedziela, 14 października 2018 19:25:10 UTC+2 użytkownik Pradeep 
Singh napisał:
>
> no effect after capitilazation 
>
> On Sun, 14 Oct 2018 at 22:48, Mateusz > 
> wrote:
>
>> Line 2: models.Model (capitalize class name)
>>
>> W dniu niedziela, 14 października 2018 19:09:47 UTC+2 użytkownik Pradeep 
>> Singh napisał:
>>>
>>>
>>>
>>> On Sun, 14 Oct 2018 at 22:37, Pradeep Singh  wrote:
>>>
>>>> yes ..i have put the app name in setting.py .wait i will share all 
>>>> screen shot
>>>>
>>>> On Sun, 14 Oct 2018 at 22:34, vineeth sagar  
>>>> wrote:
>>>>
>>>>> Okay Did you put the app in installed_apps in settings.py of your 
>>>>> project? Also you are saying you're new to django why would you want to 
>>>>> use 
>>>>> a ms-sql server as the DB of you're choice? Not something as Postgres or 
>>>>> mySQL which have good docs in the Django documentation. I think the above 
>>>>> fix should (?) Solve your issue. Maybe all the migrations have been 
>>>>> created 
>>>>> you have to python manage.py migrate. 
>>>>>
>>>>> On Oct 14, 2018 10:22 PM, "Pradeep Singh"  wrote:
>>>>>
>>>>>> i am newbie in the django..
>>>>>>
>>>>>> On Sun, 14 Oct 2018 at 22:21, Pradeep Singh  
>>>>>> wrote:
>>>>>>
>>>>>>> please help me why i am getting no change detected
>>>>>>>
>>>>>>> On Sat, 13 Oct 2018 at 01:33, Gurmeet Kaur  
>>>>>>> wrote:
>>>>>>>
>>>>>>>> I did it in my project. Use pyodbc to connect to sql server and i 
>>>>>>>> am using django 2.0.8
>>>>>>>>
>>>>>>>> On Fri, Oct 12, 2018, 11:04 AM Pradeep Singh  
>>>>>>>> wrote:
>>>>>>>>
>>>>>>>>> bro...will you help me ...
>>>>>>>>> i am getting django 404 error ...please tell how to fix it...
>>>>>>>>> i am using python 3.6 + django 1.11
>>>>>>>>>
>>>>>>>>> On Fri, 12 Oct 2018 at 19:35, vineeth sagar  
>>>>>>>>> wrote:
>>>>>>>>>
>>>>>>>>>> I don't know if it works for 1.8, you would've tested it by now. 
>>>>>>>>>> The link I haven given is a current method to connect with sql 
>>>>>>>>>> server with 
>>>>>>>>>> newer versions of django, also I think it's about time your company 
>>>>>>>>>> updated 
>>>>>>>>>> your django version.  For 2.1 the link I have given works seemlessly.
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> On Oct 12, 2018 5:38 PM, "Jason"  wrote:
>>>>>>>>>>
>>>>>>>>>>> well, considering that 1.8 is no longer supported, you're not 
>>>>>>>>>>> getting any backports and updates.  which if you're doing a 
>>>>>>>>>>> production 
>>>>>>>>>>> level app, is pretty bad.
>>>>>>>>>>>
>>>>>>>>>>> Unfortunately, seems if you want to use the recent LTS or newer 
>>>>>>>>>>> versions, SQL server is not an option unless you're willing to 
>>>>>>>>>>> update those 
>>>>>>>>>>> packages yourself for compatibility.
>>>>>>>>>>>
>>>>>>>>>>> -- 
>>>>>>>>>>> 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

Re: Connecting Sql server to Django

[Pradeep Singh]

no effect after capitilazation

On Sun, 14 Oct 2018 at 22:48, Mateusz  wrote:

> Line 2: models.Model (capitalize class name)
>
> W dniu niedziela, 14 października 2018 19:09:47 UTC+2 użytkownik Pradeep
> Singh napisał:
>>
>>
>>
>> On Sun, 14 Oct 2018 at 22:37, Pradeep Singh  wrote:
>>
>>> yes ..i have put the app name in setting.py .wait i will share all
>>> screen shot
>>>
>>> On Sun, 14 Oct 2018 at 22:34, vineeth sagar 
>>> wrote:
>>>
>>>> Okay Did you put the app in installed_apps in settings.py of your
>>>> project? Also you are saying you're new to django why would you want to use
>>>> a ms-sql server as the DB of you're choice? Not something as Postgres or
>>>> mySQL which have good docs in the Django documentation. I think the above
>>>> fix should (?) Solve your issue. Maybe all the migrations have been created
>>>> you have to python manage.py migrate.
>>>>
>>>> On Oct 14, 2018 10:22 PM, "Pradeep Singh"  wrote:
>>>>
>>>>> i am newbie in the django..
>>>>>
>>>>> On Sun, 14 Oct 2018 at 22:21, Pradeep Singh 
>>>>> wrote:
>>>>>
>>>>>> please help me why i am getting no change detected
>>>>>>
>>>>>> On Sat, 13 Oct 2018 at 01:33, Gurmeet Kaur 
>>>>>> wrote:
>>>>>>
>>>>>>> I did it in my project. Use pyodbc to connect to sql server and i am
>>>>>>> using django 2.0.8
>>>>>>>
>>>>>>> On Fri, Oct 12, 2018, 11:04 AM Pradeep Singh 
>>>>>>> wrote:
>>>>>>>
>>>>>>>> bro...will you help me ...
>>>>>>>> i am getting django 404 error ...please tell how to fix it...
>>>>>>>> i am using python 3.6 + django 1.11
>>>>>>>>
>>>>>>>> On Fri, 12 Oct 2018 at 19:35, vineeth sagar 
>>>>>>>> wrote:
>>>>>>>>
>>>>>>>>> I don't know if it works for 1.8, you would've tested it by now.
>>>>>>>>> The link I haven given is a current method to connect with sql server 
>>>>>>>>> with
>>>>>>>>> newer versions of django, also I think it's about time your company 
>>>>>>>>> updated
>>>>>>>>> your django version.  For 2.1 the link I have given works seemlessly.
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> On Oct 12, 2018 5:38 PM, "Jason"  wrote:
>>>>>>>>>
>>>>>>>>>> well, considering that 1.8 is no longer supported, you're not
>>>>>>>>>> getting any backports and updates.  which if you're doing a 
>>>>>>>>>> production
>>>>>>>>>> level app, is pretty bad.
>>>>>>>>>>
>>>>>>>>>> Unfortunately, seems if you want to use the recent LTS or newer
>>>>>>>>>> versions, SQL server is not an option unless you're willing to 
>>>>>>>>>> update those
>>>>>>>>>> packages yourself for compatibility.
>>>>>>>>>>
>>>>>>>>>> --
>>>>>>>>>> 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...@googlegroups.com.
>>>>>>>>>> To post to this group, send email to django...@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/078b932f-fde5-4eb5-9d59-4d66f43ff6f0%40googlegroups.com
>>>>>>>>>> <https://groups.google.com/d/msgid/django-users/078b932f-fde5-4eb5-9d59-4d66f43ff6f0%40googlegroups.com?utm_medium=email_source=footer>
>>>>>>>>>> .
>>>>>>>>>> For more options, visit https://groups.google.com/d/optout.
>>>>>>>>>>
>>

Re: Connecting Sql server to Django

[Mateusz]

Line 2: models.Model (capitalize class name)

W dniu niedziela, 14 października 2018 19:09:47 UTC+2 użytkownik Pradeep 
Singh napisał:
>
>
>
> On Sun, 14 Oct 2018 at 22:37, Pradeep Singh  > wrote:
>
>> yes ..i have put the app name in setting.py .wait i will share all screen 
>> shot
>>
>> On Sun, 14 Oct 2018 at 22:34, vineeth sagar > > wrote:
>>
>>> Okay Did you put the app in installed_apps in settings.py of your 
>>> project? Also you are saying you're new to django why would you want to use 
>>> a ms-sql server as the DB of you're choice? Not something as Postgres or 
>>> mySQL which have good docs in the Django documentation. I think the above 
>>> fix should (?) Solve your issue. Maybe all the migrations have been created 
>>> you have to python manage.py migrate. 
>>>
>>> On Oct 14, 2018 10:22 PM, "Pradeep Singh" >> > wrote:
>>>
>>>> i am newbie in the django..
>>>>
>>>> On Sun, 14 Oct 2018 at 22:21, Pradeep Singh >>> > wrote:
>>>>
>>>>> please help me why i am getting no change detected
>>>>>
>>>>> On Sat, 13 Oct 2018 at 01:33, Gurmeet Kaur >>>> > wrote:
>>>>>
>>>>>> I did it in my project. Use pyodbc to connect to sql server and i am 
>>>>>> using django 2.0.8
>>>>>>
>>>>>> On Fri, Oct 12, 2018, 11:04 AM Pradeep Singh >>>>> > wrote:
>>>>>>
>>>>>>> bro...will you help me ...
>>>>>>> i am getting django 404 error ...please tell how to fix it...
>>>>>>> i am using python 3.6 + django 1.11
>>>>>>>
>>>>>>> On Fri, 12 Oct 2018 at 19:35, vineeth sagar >>>>>> > wrote:
>>>>>>>
>>>>>>>> I don't know if it works for 1.8, you would've tested it by now. 
>>>>>>>> The link I haven given is a current method to connect with sql server 
>>>>>>>> with 
>>>>>>>> newer versions of django, also I think it's about time your company 
>>>>>>>> updated 
>>>>>>>> your django version.  For 2.1 the link I have given works seemlessly.
>>>>>>>>
>>>>>>>>
>>>>>>>> On Oct 12, 2018 5:38 PM, "Jason" > 
>>>>>>>> wrote:
>>>>>>>>
>>>>>>>>> well, considering that 1.8 is no longer supported, you're not 
>>>>>>>>> getting any backports and updates.  which if you're doing a 
>>>>>>>>> production 
>>>>>>>>> level app, is pretty bad.
>>>>>>>>>
>>>>>>>>> Unfortunately, seems if you want to use the recent LTS or newer 
>>>>>>>>> versions, SQL server is not an option unless you're willing to update 
>>>>>>>>> those 
>>>>>>>>> packages yourself for compatibility.
>>>>>>>>>
>>>>>>>>> -- 
>>>>>>>>> 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...@googlegroups.com .
>>>>>>>>> To post to this group, send email to django...@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/078b932f-fde5-4eb5-9d59-4d66f43ff6f0%40googlegroups.com
>>>>>>>>>  
>>>>>>>>> <https://groups.google.com/d/msgid/django-users/078b932f-fde5-4eb5-9d59-4d66f43ff6f0%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 unsubscr

Re: Connecting Sql server to Django

[Pradeep Singh]

yes ..i have put the app name in setting.py .wait i will share all screen
shot

On Sun, 14 Oct 2018 at 22:34, vineeth sagar 
wrote:

> Okay Did you put the app in installed_apps in settings.py of your project?
> Also you are saying you're new to django why would you want to use a ms-sql
> server as the DB of you're choice? Not something as Postgres or mySQL which
> have good docs in the Django documentation. I think the above fix should
> (?) Solve your issue. Maybe all the migrations have been created you have
> to python manage.py migrate.
>
> On Oct 14, 2018 10:22 PM, "Pradeep Singh"  wrote:
>
>> i am newbie in the django..
>>
>> On Sun, 14 Oct 2018 at 22:21, Pradeep Singh 
>> wrote:
>>
>>> please help me why i am getting no change detected
>>>
>>> On Sat, 13 Oct 2018 at 01:33, Gurmeet Kaur <
>>> gurmeetkaurjunej...@gmail.com> wrote:
>>>
>>>> I did it in my project. Use pyodbc to connect to sql server and i am
>>>> using django 2.0.8
>>>>
>>>> On Fri, Oct 12, 2018, 11:04 AM Pradeep Singh 
>>>> wrote:
>>>>
>>>>> bro...will you help me ...
>>>>> i am getting django 404 error ...please tell how to fix it...
>>>>> i am using python 3.6 + django 1.11
>>>>>
>>>>> On Fri, 12 Oct 2018 at 19:35, vineeth sagar 
>>>>> wrote:
>>>>>
>>>>>> I don't know if it works for 1.8, you would've tested it by now. The
>>>>>> link I haven given is a current method to connect with sql server with
>>>>>> newer versions of django, also I think it's about time your company 
>>>>>> updated
>>>>>> your django version.  For 2.1 the link I have given works seemlessly.
>>>>>>
>>>>>>
>>>>>> On Oct 12, 2018 5:38 PM, "Jason"  wrote:
>>>>>>
>>>>>>> well, considering that 1.8 is no longer supported, you're not
>>>>>>> getting any backports and updates.  which if you're doing a production
>>>>>>> level app, is pretty bad.
>>>>>>>
>>>>>>> Unfortunately, seems if you want to use the recent LTS or newer
>>>>>>> versions, SQL server is not an option unless you're willing to update 
>>>>>>> those
>>>>>>> packages yourself for compatibility.
>>>>>>>
>>>>>>> --
>>>>>>> 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/078b932f-fde5-4eb5-9d59-4d66f43ff6f0%40googlegroups.com
>>>>>>> <https://groups.google.com/d/msgid/django-users/078b932f-fde5-4eb5-9d59-4d66f43ff6f0%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
>>>>>> https://groups.google.com/d/msgid/django-users/CAMMZq8OKW5ODFZpcxHhJKF1RBKrBQWGB1dDKCd7iJ6bRc%3DcDrw%40mail.gmail.com
>>>>>> <https://groups.google.com/d/msgid/django-users/CAMMZq8OKW5ODFZpcxHhJKF1RBKrBQWGB1dDKCd7iJ6bRc%3DcDrw%40mail.gmail.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
>>>>> 

Re: Connecting Sql server to Django

[vineeth sagar]

Okay Did you put the app in installed_apps in settings.py of your project?
Also you are saying you're new to django why would you want to use a ms-sql
server as the DB of you're choice? Not something as Postgres or mySQL which
have good docs in the Django documentation. I think the above fix should
(?) Solve your issue. Maybe all the migrations have been created you have
to python manage.py migrate.

On Oct 14, 2018 10:22 PM, "Pradeep Singh"  wrote:

> i am newbie in the django..
>
> On Sun, 14 Oct 2018 at 22:21, Pradeep Singh  wrote:
>
>> please help me why i am getting no change detected
>>
>> On Sat, 13 Oct 2018 at 01:33, Gurmeet Kaur 
>> wrote:
>>
>>> I did it in my project. Use pyodbc to connect to sql server and i am
>>> using django 2.0.8
>>>
>>> On Fri, Oct 12, 2018, 11:04 AM Pradeep Singh 
>>> wrote:
>>>
>>>> bro...will you help me ...
>>>> i am getting django 404 error ...please tell how to fix it...
>>>> i am using python 3.6 + django 1.11
>>>>
>>>> On Fri, 12 Oct 2018 at 19:35, vineeth sagar 
>>>> wrote:
>>>>
>>>>> I don't know if it works for 1.8, you would've tested it by now. The
>>>>> link I haven given is a current method to connect with sql server with
>>>>> newer versions of django, also I think it's about time your company 
>>>>> updated
>>>>> your django version.  For 2.1 the link I have given works seemlessly.
>>>>>
>>>>>
>>>>> On Oct 12, 2018 5:38 PM, "Jason"  wrote:
>>>>>
>>>>>> well, considering that 1.8 is no longer supported, you're not getting
>>>>>> any backports and updates.  which if you're doing a production level app,
>>>>>> is pretty bad.
>>>>>>
>>>>>> Unfortunately, seems if you want to use the recent LTS or newer
>>>>>> versions, SQL server is not an option unless you're willing to update 
>>>>>> those
>>>>>> packages yourself for compatibility.
>>>>>>
>>>>>> --
>>>>>> 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/078b932f-fde5-4eb5-9d59-4d66f43ff6f0%
>>>>>> 40googlegroups.com
>>>>>> <https://groups.google.com/d/msgid/django-users/078b932f-fde5-4eb5-9d59-4d66f43ff6f0%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 https://groups.google.com/d/
>>>>> msgid/django-users/CAMMZq8OKW5ODFZpcxHhJKF1RBKrBQ
>>>>> WGB1dDKCd7iJ6bRc%3DcDrw%40mail.gmail.com
>>>>> <https://groups.google.com/d/msgid/django-users/CAMMZq8OKW5ODFZpcxHhJKF1RBKrBQWGB1dDKCd7iJ6bRc%3DcDrw%40mail.gmail.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 https://groups.google.

Re: Connecting Sql server to Django

[Pradeep Singh]

i am newbie in the django..

On Sun, 14 Oct 2018 at 22:21, Pradeep Singh  wrote:

> please help me why i am getting no change detected
>
> On Sat, 13 Oct 2018 at 01:33, Gurmeet Kaur 
> wrote:
>
>> I did it in my project. Use pyodbc to connect to sql server and i am
>> using django 2.0.8
>>
>> On Fri, Oct 12, 2018, 11:04 AM Pradeep Singh 
>> wrote:
>>
>>> bro...will you help me ...
>>> i am getting django 404 error ...please tell how to fix it...
>>> i am using python 3.6 + django 1.11
>>>
>>> On Fri, 12 Oct 2018 at 19:35, vineeth sagar 
>>> wrote:
>>>
>>>> I don't know if it works for 1.8, you would've tested it by now. The
>>>> link I haven given is a current method to connect with sql server with
>>>> newer versions of django, also I think it's about time your company updated
>>>> your django version.  For 2.1 the link I have given works seemlessly.
>>>>
>>>>
>>>> On Oct 12, 2018 5:38 PM, "Jason"  wrote:
>>>>
>>>>> well, considering that 1.8 is no longer supported, you're not getting
>>>>> any backports and updates.  which if you're doing a production level app,
>>>>> is pretty bad.
>>>>>
>>>>> Unfortunately, seems if you want to use the recent LTS or newer
>>>>> versions, SQL server is not an option unless you're willing to update 
>>>>> those
>>>>> packages yourself for compatibility.
>>>>>
>>>>> --
>>>>> 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/078b932f-fde5-4eb5-9d59-4d66f43ff6f0%40googlegroups.com
>>>>> <https://groups.google.com/d/msgid/django-users/078b932f-fde5-4eb5-9d59-4d66f43ff6f0%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
>>>> https://groups.google.com/d/msgid/django-users/CAMMZq8OKW5ODFZpcxHhJKF1RBKrBQWGB1dDKCd7iJ6bRc%3DcDrw%40mail.gmail.com
>>>> <https://groups.google.com/d/msgid/django-users/CAMMZq8OKW5ODFZpcxHhJKF1RBKrBQWGB1dDKCd7iJ6bRc%3DcDrw%40mail.gmail.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
>>> https://groups.google.com/d/msgid/django-users/CANwgZcaiLs3RqawFDzYX%3Dtz3B3ye_FW7nudgDEw6BqkBFJm0Dg%40mail.gmail.com
>>> <https://groups.google.com/d/msgid/django-users/CANwgZcaiLs3RqawFDzYX%3Dtz3B3ye_FW7nudgDEw6BqkBFJm0Dg%40mail.gmail.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 

Re: Connecting Sql server to Django

[Gurmeet Kaur]

I did it in my project. Use pyodbc to connect to sql server and i am using
django 2.0.8

On Fri, Oct 12, 2018, 11:04 AM Pradeep Singh  wrote:

> bro...will you help me ...
> i am getting django 404 error ...please tell how to fix it...
> i am using python 3.6 + django 1.11
>
> On Fri, 12 Oct 2018 at 19:35, vineeth sagar 
> wrote:
>
>> I don't know if it works for 1.8, you would've tested it by now. The link
>> I haven given is a current method to connect with sql server with newer
>> versions of django, also I think it's about time your company updated your
>> django version.  For 2.1 the link I have given works seemlessly.
>>
>>
>> On Oct 12, 2018 5:38 PM, "Jason"  wrote:
>>
>>> well, considering that 1.8 is no longer supported, you're not getting
>>> any backports and updates.  which if you're doing a production level app,
>>> is pretty bad.
>>>
>>> Unfortunately, seems if you want to use the recent LTS or newer
>>> versions, SQL server is not an option unless you're willing to update those
>>> packages yourself for compatibility.
>>>
>>> --
>>> 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/078b932f-fde5-4eb5-9d59-4d66f43ff6f0%40googlegroups.com
>>> <https://groups.google.com/d/msgid/django-users/078b932f-fde5-4eb5-9d59-4d66f43ff6f0%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
>> https://groups.google.com/d/msgid/django-users/CAMMZq8OKW5ODFZpcxHhJKF1RBKrBQWGB1dDKCd7iJ6bRc%3DcDrw%40mail.gmail.com
>> <https://groups.google.com/d/msgid/django-users/CAMMZq8OKW5ODFZpcxHhJKF1RBKrBQWGB1dDKCd7iJ6bRc%3DcDrw%40mail.gmail.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
> https://groups.google.com/d/msgid/django-users/CANwgZcaiLs3RqawFDzYX%3Dtz3B3ye_FW7nudgDEw6BqkBFJm0Dg%40mail.gmail.com
> <https://groups.google.com/d/msgid/django-users/CANwgZcaiLs3RqawFDzYX%3Dtz3B3ye_FW7nudgDEw6BqkBFJm0Dg%40mail.gmail.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 
https://groups.google.com/d/msgid/django-users/CAEbKJVhVHNAe6z-FAc%2BuBUqq%3DKb2A0mFJHh%3D6k0DuZAfuiJG7g%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: Connecting Sql server to Django

[Pradeep Singh]

bro...will you help me ...
i am getting django 404 error ...please tell how to fix it...
i am using python 3.6 + django 1.11

On Fri, 12 Oct 2018 at 19:35, vineeth sagar 
wrote:

> I don't know if it works for 1.8, you would've tested it by now. The link
> I haven given is a current method to connect with sql server with newer
> versions of django, also I think it's about time your company updated your
> django version.  For 2.1 the link I have given works seemlessly.
>
>
> On Oct 12, 2018 5:38 PM, "Jason"  wrote:
>
>> well, considering that 1.8 is no longer supported, you're not getting any
>> backports and updates.  which if you're doing a production level app, is
>> pretty bad.
>>
>> Unfortunately, seems if you want to use the recent LTS or newer versions,
>> SQL server is not an option unless you're willing to update those packages
>> yourself for compatibility.
>>
>> --
>> 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/078b932f-fde5-4eb5-9d59-4d66f43ff6f0%40googlegroups.com
>> <https://groups.google.com/d/msgid/django-users/078b932f-fde5-4eb5-9d59-4d66f43ff6f0%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
> https://groups.google.com/d/msgid/django-users/CAMMZq8OKW5ODFZpcxHhJKF1RBKrBQWGB1dDKCd7iJ6bRc%3DcDrw%40mail.gmail.com
> <https://groups.google.com/d/msgid/django-users/CAMMZq8OKW5ODFZpcxHhJKF1RBKrBQWGB1dDKCd7iJ6bRc%3DcDrw%40mail.gmail.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 
https://groups.google.com/d/msgid/django-users/CANwgZcaiLs3RqawFDzYX%3Dtz3B3ye_FW7nudgDEw6BqkBFJm0Dg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: Connecting Sql server to Django

[vineeth sagar]

I don't know if it works for 1.8, you would've tested it by now. The link I
haven given is a current method to connect with sql server with newer
versions of django, also I think it's about time your company updated your
django version.  For 2.1 the link I have given works seemlessly.


On Oct 12, 2018 5:38 PM, "Jason"  wrote:

> well, considering that 1.8 is no longer supported, you're not getting any
> backports and updates.  which if you're doing a production level app, is
> pretty bad.
>
> Unfortunately, seems if you want to use the recent LTS or newer versions,
> SQL server is not an option unless you're willing to update those packages
> yourself for compatibility.
>
> --
> 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/078b932f-fde5-4eb5-9d59-4d66f43ff6f0%40googlegroups.com
> <https://groups.google.com/d/msgid/django-users/078b932f-fde5-4eb5-9d59-4d66f43ff6f0%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 
https://groups.google.com/d/msgid/django-users/CAMMZq8OKW5ODFZpcxHhJKF1RBKrBQWGB1dDKCd7iJ6bRc%3DcDrw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: Connecting Sql server to Django

[Jason]

well, considering that 1.8 is no longer supported, you're not getting any 
backports and updates.  which if you're doing a production level app, is 
pretty bad.

Unfortunately, seems if you want to use the recent LTS or newer versions, 
SQL server is not an option unless you're willing to update those packages 
yourself for compatibility.

-- 
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/078b932f-fde5-4eb5-9d59-4d66f43ff6f0%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Connecting Sql server to Django

[Rakhee Menon]

Hi Vineeth,
Just had to make some changes in an old project which uses Sql Server 2014 
and yeah I am using django 1.8.
Is it that for the link you have given should I use Django 2.1 version or 
1.8would work???


Thanks
Rakhee

-- 
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/8f231215-5031-4130-a3ac-ad3acfabaa4f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Connecting Sql server to Django

[vineeth sagar]

Which version of django are you using, django-mssql only supports Django
until 1.8 and it's not under active development.
https://pypi.org/project/django-pyodbc-azure/ use this instead, this works
with ms-sql as I use this at work and if you go to the bitbucket repo
 you'll find the same thing I have explained you.

Apart from that I was forced to use ms-sql at work, what's your reason to
use SQL server?

regards
Vineeth

On Oct 12, 2018 9:56 AM, "Rakhee Menon"  wrote:

>
>
> Hi Everyone,
>
> In my project I want to connect SQL Server 2014 with django, I tried with
> the given link,
>
>https://django-mssql.readthedocs.io/en/latest/quickstart.html
>
> but it shows some error like,
>
> import pythoncom
> ImportError: No module named 'pythoncom''
>
> When I goggled the error it says download pywin32 but I didn't get any
> file or link to download .Please could anyone help me out with this issue.
>
> Thanks in Advance
> Rakhee
>
> --
> 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/b1fe3c06-4e5e-45f7-b675-d4751b94337f%40googlegroups.com
> <https://groups.google.com/d/msgid/django-users/b1fe3c06-4e5e-45f7-b675-d4751b94337f%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 
https://groups.google.com/d/msgid/django-users/CAMMZq8NZkpGZ%3D1TAN9Jr45w2N5VUv6ANJPu858dRuVsS%3D1jpYg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Connecting Sql server to Django

[Rakhee Menon]

Hi Everyone,

In my project I want to connect SQL Server 2014 with django, I tried with 
the given link,

   https://django-mssql.readthedocs.io/en/latest/quickstart.html

but it shows some error like,

import pythoncom
ImportError: No module named 'pythoncom''

When I goggled the error it says download pywin32 but I didn't get any file 
or link to download .Please could anyone help me out with this issue.

Thanks in Advance
Rakhee

-- 
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/b1fe3c06-4e5e-45f7-b675-d4751b94337f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Configuration settings for Sql Server database in django

[Rakhee Menon]

Hi Vinod, Thanks for the quick response ...I also had doubt regarding  
which version of python and django are supported for SQL Server 2014.

Thanks

-- 
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/0b44959e-a3dd-4175-ba02-5ed409c57c86%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Configuration settings for Sql Server database in django

['Vinod Kumar' via Django users]

DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 'db_name',
'USER': 'db_user',
'PASSWORD': 'password',
'HOST': 'localhost',
'PORT': '',
}
}

On Wed, Oct 10, 2018 at 11:50 AM Rakhee Menon 
wrote:

> Hello Everyone,
>
> Please could anyone specify what are the configuration settings to be done
> in Django for using SQL Server 2014 as database instead of the default
> sqlite.
>
> Thanks in Advance
> Rakhee
>
> --
> 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/1fbdbb75-8a31-4ab2-90b8-adef9c8fb300%40googlegroups.com
> <https://groups.google.com/d/msgid/django-users/1fbdbb75-8a31-4ab2-90b8-adef9c8fb300%40googlegroups.com?utm_medium=email_source=footer>
> .
> For more options, visit https://groups.google.com/d/optout.
>

-- 









This e-mail and all attachments are intended solely for use by
the intended 
recipient and may contain confidential / proprietary information
of 
KiwiTech, LLC, subject to important disclaimers and conditions including

restrictions on the use, disclosure, transfer or export of such 
information. If you have received this
message in error or are not the 
named recipient(s), please immediately notify
the sender at the telephone 
number stated above or by reply e-mail and delete
this e-mail from your 
computer





-- 
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/CAJOHC1x3n%3D8v4nVnRsY9MN1%2B7d_fK3Q3_J4jqWZ6pp7mjs9buQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Configuration settings for Sql Server database in django

[Rakhee Menon]

Hello Everyone,

Please could anyone specify what are the configuration settings to be done 
in Django for using SQL Server 2014 as database instead of the default 
sqlite.

Thanks in Advance
Rakhee

-- 
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/1fbdbb75-8a31-4ab2-90b8-adef9c8fb300%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Change sqlite database to sql server

[Jason]

the error is saying your remote server doesn't allow external connections, 
so look at the docs for how to enable that

-- 
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/a04752a1-3c26-4c47-ab08-d0f2e1239b19%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Change sqlite database to sql server

[Rakhee Menon]

Hey Thanks!!! but now I get this error ,
Actually I am trying it on my localhost machine not able to figure out what 
exactly is the issue.

TCP Provider: No connection could be made because the target machine 
actively refused it.\r\n (10061) (SQLDriverConnect); [08001] 
[Microsoft][ODBC Driver 11 for SQL Server]Login timeout expired (0); 
[08001] [Microsoft][ODBC Driver 11 for SQL Server]Invalid connection string 
attribute (0); [08001] [Microsoft][ODBC Driver 11 for SQL Server]A 
network-related or instance-specific error has occurred while establishing 
a connection to SQL Server. Server is not found or not accessible. Check if 
instance name is correct and if SQL Server is configured to allow remote 
connections

-- 
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/99208a5c-724e-4e8f-aee3-915e8f0aebb4%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Change sqlite database to sql server

[Vishvajit Pathak]

Hi Rakhee,

Two possible reasons for this error : 
  A) ODBC driver is not installed 
  B) The driver requires a Data Source Name to be configured

You can refer these links for more explanation : 
https://communities.actian.com/s/article/Data-source-name-not-found-and-no-default-driver-specified
https://stackoverflow.com/questions/17115632/microsoftodbc-driver-manager-data-source-name-not-found-and-no-default-drive



On Sunday, 7 October 2018 13:16:48 UTC+5:30, Rakhee Menon wrote:
>
> Hi everyone,
> I have a developed project in which I am trying to use sqlserver instead 
> of the default sqlite database.
> While I do the changes I get the following error
>
> django.db.utils.InterfaceError: ('IM002', '[IM002] [Microsoft][ODBC Driver 
> Manager] Data source name not found and no default driver specified (0) 
> (SQLDriverConnect)')
>
> Please help if anyone knows how to solve this issue or change default 
> database to sqlserver
>
> Thanks in Advance
>

-- 
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/9ffaefca-d7d3-4786-8f6b-bc3e45bbc85a%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Change sqlite database to sql server

[Jason]

You might have some trouble with SQL Server

http://nightlyclosures.com/2018/01/08/working-with-mssql-in-django/

but sounds to me you haven't installed the driver or anything else for 
django to talk to SQL server.  have you insalled 
https://bitbucket.org/Manfre/django-mssql or any of the equivalents?

-- 
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/c2345da8-44eb-413f-8bed-9b647e236ef3%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Change sqlite database to sql server

[Rakhee Menon]

Hi everyone,
I have a developed project in which I am trying to use sqlserver instead of 
the default sqlite database.
While I do the changes I get the following error

django.db.utils.InterfaceError: ('IM002', '[IM002] [Microsoft][ODBC Driver 
Manager] Data source name not found and no default driver specified (0) 
(SQLDriverConnect)')

Please help if anyone knows how to solve this issue or change default 
database to sqlserver

Thanks in Advance

-- 
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/aecd22c1-aee7-4da1-ad67-356657a9a22f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Sql server

[Vishvajit Pathak]

Did you check the documentation at 
https://docs.djangoproject.com/en/2.1/topics/auth/customizing/#substituting-a-custom-user-model
 
?

On Thursday, 27 September 2018 05:05:39 UTC+5:30, Elton Oliveira wrote:
>
> Hello guys, I'm having two difficulties and I wonder if anyone can help 
> me, first I need to change the names of the auth tables of Django to follow 
> the standard of company names, second I need to create the security tables 
> in a custom schema in SQL Server, does anyone have any tips?
>

-- 
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/326a2a01-ab38-44ea-8fa1-67db97fc3b0c%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Sql Server

[Elton Oliveira]

I managed to solve as follows:

from django.db import models

class Teste001(models.Model):
name = models.CharField(max_length=100)
tagline = models.TextField()

def __str__(self):
return self.name

class Meta:
db_table = 'scheme].[table' 

Em quinta-feira, 27 de setembro de 2018 12:37:44 UTC-4, Pardhu Saradhi 
escreveu:
>
> Can you please msg me what you have done
>
> On Thu 27 Sep, 2018, 5:05 AM Elton Oliveira,  > wrote:
>
>> Hello guys, how do I create my tables in other SQL server schemas? OBS: I 
>> tried everything and I could not
>>
>> -- 
>> 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...@googlegroups.com .
>> To post to this group, send email to django...@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/6c1e9a72-ef4d-4405-9cec-5ce3a3e2d046%40googlegroups.com
>>  
>> <https://groups.google.com/d/msgid/django-users/6c1e9a72-ef4d-4405-9cec-5ce3a3e2d046%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 
https://groups.google.com/d/msgid/django-users/4985051d-f0e4-4d7b-9aa3-7c725af66d96%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Sql Server

[Pardhu Saradhi]

Can you please msg me what you have done

On Thu 27 Sep, 2018, 5:05 AM Elton Oliveira, 
wrote:

> Hello guys, how do I create my tables in other SQL server schemas? OBS: I
> tried everything and I could not
>
> --
> 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/6c1e9a72-ef4d-4405-9cec-5ce3a3e2d046%40googlegroups.com
> <https://groups.google.com/d/msgid/django-users/6c1e9a72-ef4d-4405-9cec-5ce3a3e2d046%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 
https://groups.google.com/d/msgid/django-users/CAL5%3DX0XZC61mmMnAenTVH7YUAwg2aOPvhy-j8FTGwSzzBBqhQg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: Sql server

[Jason]

django convention for db tables is lower case.  what reason do you have to 
desire upper case?

On Thursday, September 27, 2018 at 8:08:27 AM UTC-4, Elton Oliveira wrote:
>
> leave the capital letters
>
> Em quinta-feira, 27 de setembro de 2018 07:00:47 UTC-4, Andréas Kühne 
> escreveu:
>>
>> What exactly do you need to change in the auth tables? The user table is 
>> easily changed, but the others I'm not so sure about - why would you need 
>> this?
>>
>> Regards,
>>
>> Andréas
>>
>>
>> Den tors 27 sep. 2018 kl 01:35 skrev Elton Oliveira > >:
>>
>>> Hello guys, I'm having two difficulties and I wonder if anyone can help 
>>> me, first I need to change the names of the auth tables of Django to follow 
>>> the standard of company names, second I need to create the security tables 
>>> in a custom schema in SQL Server, does anyone have any tips?
>>>
>>> -- 
>>> 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...@googlegroups.com.
>>> To post to this group, send email to django...@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/CADpGDPXz0F0X1G%2BcPPY18khBb34nfUronL9T6ZjOBjw7-7bccQ%40mail.gmail.com
>>>  
>>> <https://groups.google.com/d/msgid/django-users/CADpGDPXz0F0X1G%2BcPPY18khBb34nfUronL9T6ZjOBjw7-7bccQ%40mail.gmail.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 
https://groups.google.com/d/msgid/django-users/bc3fbf6e-5b08-46e8-81fd-c30dce9788f0%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Sql server

[Elton Oliveira]

leave the capital letters

Em quinta-feira, 27 de setembro de 2018 07:00:47 UTC-4, Andréas Kühne 
escreveu:
>
> What exactly do you need to change in the auth tables? The user table is 
> easily changed, but the others I'm not so sure about - why would you need 
> this?
>
> Regards,
>
> Andréas
>
>
> Den tors 27 sep. 2018 kl 01:35 skrev Elton Oliveira  >:
>
>> Hello guys, I'm having two difficulties and I wonder if anyone can help 
>> me, first I need to change the names of the auth tables of Django to follow 
>> the standard of company names, second I need to create the security tables 
>> in a custom schema in SQL Server, does anyone have any tips?
>>
>> -- 
>> 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...@googlegroups.com .
>> To post to this group, send email to django...@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/CADpGDPXz0F0X1G%2BcPPY18khBb34nfUronL9T6ZjOBjw7-7bccQ%40mail.gmail.com
>>  
>> <https://groups.google.com/d/msgid/django-users/CADpGDPXz0F0X1G%2BcPPY18khBb34nfUronL9T6ZjOBjw7-7bccQ%40mail.gmail.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 
https://groups.google.com/d/msgid/django-users/f7047c05-15ed-497e-a9fb-a564f8c376c4%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Sql server

[Andréas Kühne]

What exactly do you need to change in the auth tables? The user table is
easily changed, but the others I'm not so sure about - why would you need
this?

Regards,

Andréas


Den tors 27 sep. 2018 kl 01:35 skrev Elton Oliveira <
eltonoliveir...@gmail.com>:

> Hello guys, I'm having two difficulties and I wonder if anyone can help
> me, first I need to change the names of the auth tables of Django to follow
> the standard of company names, second I need to create the security tables
> in a custom schema in SQL Server, does anyone have any tips?
>
> --
> 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/CADpGDPXz0F0X1G%2BcPPY18khBb34nfUronL9T6ZjOBjw7-7bccQ%40mail.gmail.com
> <https://groups.google.com/d/msgid/django-users/CADpGDPXz0F0X1G%2BcPPY18khBb34nfUronL9T6ZjOBjw7-7bccQ%40mail.gmail.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 
https://groups.google.com/d/msgid/django-users/CAK4qSCdY86aRb0MYLbU2%2BKTrVwooW8mp8%2BZmLr0ejzhG_7N6tA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Sql server

[Elton Oliveira]

Hello guys, I'm having two difficulties and I wonder if anyone can help me,
first I need to change the names of the auth tables of Django to follow the
standard of company names, second I need to create the security tables in a
custom schema in SQL Server, does anyone have any tips?

-- 
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/CADpGDPXz0F0X1G%2BcPPY18khBb34nfUronL9T6ZjOBjw7-7bccQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Sql Server

[Elton Oliveira]

Hello guys, how do I create my tables in other SQL server schemas? OBS: I 
tried everything and I could not

-- 
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/6c1e9a72-ef4d-4405-9cec-5ce3a3e2d046%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Not able to connect to SQL Server 2012 from current version of DJango and Python

[Jason]

the dev for that library has specified that this is not compatible with 
django 2.1.  so your options are to either find another connector library 
compatible with 2.1 or downgrade to using 2.0.x

https://github.com/michiya/django-pyodbc-azure/blob/azure-2.0/setup.py#L29

>

-- 
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/c33146dc-209c-4978-8d38-2c87e55c6ea1%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Not able to connect to SQL Server 2012 from current version of DJango and Python

[Gurmeet Kaur]

Hi All,

I am trying to connect to SQL server 2012 using Pyodbc and DJango framework
but the version of Django is 2.1. Now, when I try to connect using below
code when I only have Pyodbc installed then the below code doesnot run.

DATABASES = {
'default': {
# 'ENGINE': '{ODBC Driver 11 for SQL Server}', Tried this as well
but it did not work.
'ENGINE': 'sql_server.pyodbc',
'NAME': 'MY_DATABASE',
# 'HOST': 'XXX.XX.XXX.XXX', Tried this as well but it did not work.
'SERVER': 'XXX.XX.XXX.XXX',
# 'HOST': 'SQLSERVER_InstanceName',
'PORT': '',
'USER': 'SQLSERVERUSER',
'PASSWORD': 'USER's PASSWORD',
 'DATABASE': 'MY_DATABASE',
 # 'Trusted_Connection': 'Yes',
# 'OPTIONS': {
# 'driver': 'ODBC Driver 11 for SQL Server',
#}

},
}


But when I install django-pyodbc-azure and try to run the above code by
running python manage.py inspectdb command, it works.

But the problem with using django-pyodbc-azure is that it downgrades the
current version of django to 2.0.8 version - which I do not want.

I do not want to use FreeTDS or Pymssql. I want to go with pyodbc only.

Can someone please suggest some way for this?


Thanks,
Gurmeet Kaur

-- 
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/CAEbKJVinxbK8KMVdUH74kxkGC%3DNv1FCU3H4B9w7HYznM8-DQLg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: Need help for DJango on Windows server with MS SQL Server 2012

[Jason]

To answer your first question, that's wehre you look into the project's 
compatibility documentation and do your own research.

Second question: that is a complete unknown, as you're asking us to be 
fortune tellers and be able to tell the future.

In essence, both of your questions can be answered by doing proper research 
and investigation, both beforehand as well as during update problems.

On Wednesday, July 11, 2018 at 6:08:58 PM UTC-4, gurmeetka...@gmail.com 
wrote:
>
> Hi All,
>
> Me and my team will be developing our first application in Python and we 
> will be using SQL Server as backend. I wanted to ask one query regarding 
> the versions of Python that have been developed and the ones that are in 
> development.
>
> If we use the current available version of the Python and DJango like - 
> Django version - 2.0.7 and Python version - 3.7.0 and Django-msssql - 1.8 
> version.
>
> My first question is : Will they work with Sql Server 2012 and will they 
> be compatible working on Windows server?
>
> My second question(and the most important one) is: If all goes well and we 
> deploy application and because of some new feature or for some technical 
> reason, we need to update Python but that updation breaks some existing 
> issue then what could be the possible solution? In other words, if the 
> older version (on which our website is working) is not compatible then what 
> can be done in that case?
>
> Please suggest. It would be of great help if you could help me with the 
> response ASAP.
>
> Thanks in advance.
>
>
>
>
>
> Thanks,
> Gurmeet Kaur
>

-- 
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/484308ac-6534-436f-89fc-7a9053380271%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Need help for DJango on Windows server with MS SQL Server 2012

[gurmeetkaurjuneja23]

Hi All,

Me and my team will be developing our first application in Python and we 
will be using SQL Server as backend. I wanted to ask one query regarding 
the versions of Python that have been developed and the ones that are in 
development.

If we use the current available version of the Python and DJango like - 
Django version - 2.0.7 and Python version - 3.7.0 and Django-msssql - 1.8 
version.

My first question is : Will they work with Sql Server 2012 and will they be 
compatible working on Windows server?

My second question(and the most important one) is: If all goes well and we 
deploy application and because of some new feature or for some technical 
reason, we need to update Python but that updation breaks some existing 
issue then what could be the possible solution? In other words, if the 
older version (on which our website is working) is not compatible then what 
can be done in that case?

Please suggest. It would be of great help if you could help me with the 
response ASAP.

Thanks in advance.





Thanks,
Gurmeet Kaur

-- 
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/3621b658-4efb-4d71-9082-9d450882bd64%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: How to fetch data from sql server and display on django web pages

[PASCUAL Eric]

Hi,


> You may want to check out sqlalchemy they provide a pretty good documentation 
> on what you are aftering


For my understanding, why are you suggesting to use SQLAlchemy while Django 
provides an ORM out of the box ?


SQLAlchemy is required for frameworks such as Flask, which do nothing with 
respect to the data layer, but it's not clear which benefit it could bring here.


Best regards


Eric

From: django-users@googlegroups.com <django-users@googlegroups.com> on behalf 
of sum abiut <suab...@gmail.com>
Sent: Monday, February 12, 2018 10:24:07 PM
To: django-users@googlegroups.com
Subject: Re: How to fetch data from sql server and display on django web pages


You may want to check out sqlalchemy they provide a pretty good documentation 
on what you are aftering 
http://docs.sqlalchemy.org/en/latest/dialects/mssql.html

>From you view you can defile a function like so.

view.py

from sqlalchemy import*
from django.shortcuts import render

def connectto_db(request):
engine=create_engine('mssql+pymssql://username:password@servername 
/Ddabname')
connection=engine.connect()
metadata=MetaData()


table=Table('tablename',metadata,autoload=True,autoload_with=engine)
stmt='SELECT * FROM table'
results=connection.execute(stmt).fetchall()
return render(request,'template.html',locals())


then  you can pass the results to your template.html

Hope this helps.

Cheers

On Sun, Feb 11, 2018 at 4:37 PM, Amit Kadivar 
<amit.kadiv...@gmail.com<mailto:amit.kadiv...@gmail.com>> wrote:
Please Help me.
How to fetch data from sql server and display them on django web pages through 
nginx web server..




--
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<mailto:django-users+unsubscr...@googlegroups.com>.
To post to this group, send email to 
django-users@googlegroups.com<mailto: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/b5577524-e67d-465f-bb49-e54bca92c88b%40googlegroups.com<https://groups.google.com/d/msgid/django-users/b5577524-e67d-465f-bb49-e54bca92c88b%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<mailto:django-users+unsubscr...@googlegroups.com>.
To post to this group, send email to 
django-users@googlegroups.com<mailto: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/CAPCf-y5CZ-HAUSbGkTWKe23CfuCMWozoLqL85V52924NpDwd-A%40mail.gmail.com<https://groups.google.com/d/msgid/django-users/CAPCf-y5CZ-HAUSbGkTWKe23CfuCMWozoLqL85V52924NpDwd-A%40mail.gmail.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 
https://groups.google.com/d/msgid/django-users/AM5P193MB008317CB26D147DD042FD98A8CF70%40AM5P193MB0083.EURP193.PROD.OUTLOOK.COM.
For more options, visit https://groups.google.com/d/optout.

Re: How to fetch data from sql server and display on django web pages

[sum abiut]

You may want to check out sqlalchemy they provide a pretty good
documentation on what you are aftering
http://docs.sqlalchemy.org/en/latest/dialects/mssql.html

>From you view you can defile a function like so.

view.py

from sqlalchemy import*
from django.shortcuts import render

def connectto_db(request):
engine=create_engine('mssql+pymssql://username:password@servername
/Ddabname')
connection=engine.connect()
metadata=MetaData()


table=Table('tablename',metadata,autoload=True,autoload_with=engine)
stmt='SELECT * FROM table'
results=connection.execute(stmt).fetchall()
return render(request,'template.html',locals())


then  you can pass the results to your template.html

Hope this helps.

Cheers

On Sun, Feb 11, 2018 at 4:37 PM, Amit Kadivar <amit.kadiv...@gmail.com>
wrote:

> Please Help me.
> How to fetch data from sql server and display them on django web pages
> through nginx web server..
>
>
>
> --
> 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/b5577524-e67d-465f-bb49-e54bca92c88b%40googlegroups.com
> <https://groups.google.com/d/msgid/django-users/b5577524-e67d-465f-bb49-e54bca92c88b%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 
https://groups.google.com/d/msgid/django-users/CAPCf-y5CZ-HAUSbGkTWKe23CfuCMWozoLqL85V52924NpDwd-A%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: How to fetch data from sql server and display on django web pages

[carlos]

maybe try with this app
http://django-mssql.readthedocs.io/en/latest/settings.html

On Sun, Feb 11, 2018 at 3:58 AM, PASCUAL Eric <eric.pasc...@cstb.fr> wrote:

> Hi Amit,
>
>
> There is no "Django Web page" as you write in your message, but Web pages
> of the application built on top of the Django framework. Hence how to
> display data depends on how the Web pages of **your** application are
> designed.
>
>
> Second point, one of the roles of Django is to isolate the application
> developer from the raw SQL requests needed to store and retrieve data from
> the underlying data base. This is called an ORM (object relational mapping)
> and it is one of the keystones of the Django framework. The benefit from
> this is that you don't have to deal with SQL requests *(at least for the
> vast majority of the situations)*, but to specify the data model of the
> application as a collection of classes and relations between them. Django
> tools will take care of creating the relational database first, and then
> translate under the hood the object oriented interactions you make with
> your model into the corresponding SQL requests.
>
>
> I've the feeling that you have not fully understood what Django is, what
> Django does and how to write a Django application. So, take no offense,
> but have you read (and understood) at least the introduction (including
> tutorials) documentation of Django ?
>
>
> What is exactly the context of your project, what is it supposed to do,...
> ? The way you are presenting it, it sounds a bit like a student homework.
> Maybe it's not, but...
>
>
> Best regards.
>
>
> Eric
> --
> *From:* django-users@googlegroups.com <django-users@googlegroups.com> on
> behalf of Amit Kadivar <amit.kadiv...@gmail.com>
> *Sent:* Sunday, February 11, 2018 6:37:28 AM
> *To:* Django users
> *Subject:* How to fetch data from sql server and display on django web
> pages
>
> Please Help me.
> How to fetch data from sql server and display them on django web pages
> through nginx web server..
>
>
>
> --
> 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/b5577524-e67d-465f-bb49-e54bca92c88b%40googlegroups.com
> <https://groups.google.com/d/msgid/django-users/b5577524-e67d-465f-bb49-e54bca92c88b%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 https://groups.google.com/d/
> msgid/django-users/AM5P193MB00835F3E9901536A3FF319C28CF00%40AM5P193MB0083.
> EURP193.PROD.OUTLOOK.COM
> <https://groups.google.com/d/msgid/django-users/AM5P193MB00835F3E9901536A3FF319C28CF00%40AM5P193MB0083.EURP193.PROD.OUTLOOK.COM?utm_medium=email_source=footer>
> .
>
> For more options, visit https://groups.google.com/d/optout.
>



-- 
att.
Carlos Rocha

-- 
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/CAM-7rO2Gd0Q18_1%2BVyse3ej%2BFmeok6eb2srjEaUajPqr4FbqUw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: How to fetch data from sql server and display on django web pages

[PASCUAL Eric]

Hi Amit,


There is no "Django Web page" as you write in your message, but Web pages of 
the application built on top of the Django framework. Hence how to display data 
depends on how the Web pages of *your* application are designed.


Second point, one of the roles of Django is to isolate the application 
developer from the raw SQL requests needed to store and retrieve data from the 
underlying data base. This is called an ORM (object relational mapping) and it 
is one of the keystones of the Django framework. The benefit from this is that 
you don't have to deal with SQL requests (at least for the vast majority of the 
situations), but to specify the data model of the application as a collection 
of classes and relations between them. Django tools will take care of creating 
the relational database first, and then translate under the hood the object 
oriented interactions you make with your model into the corresponding SQL 
requests.


I've the feeling that you have not fully understood what Django is, what Django 
does and how to write a Django application. So, take no offense, but have you 
read (and understood) at least the introduction (including tutorials) 
documentation of Django ?


What is exactly the context of your project, what is it supposed to do,... ? 
The way you are presenting it, it sounds a bit like a student homework. Maybe 
it's not, but...


Best regards.


Eric

From: django-users@googlegroups.com <django-users@googlegroups.com> on behalf 
of Amit Kadivar <amit.kadiv...@gmail.com>
Sent: Sunday, February 11, 2018 6:37:28 AM
To: Django users
Subject: How to fetch data from sql server and display on django web pages

Please Help me.
How to fetch data from sql server and display them on django web pages through 
nginx web server..




--
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<mailto:django-users+unsubscr...@googlegroups.com>.
To post to this group, send email to 
django-users@googlegroups.com<mailto: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/b5577524-e67d-465f-bb49-e54bca92c88b%40googlegroups.com<https://groups.google.com/d/msgid/django-users/b5577524-e67d-465f-bb49-e54bca92c88b%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 
https://groups.google.com/d/msgid/django-users/AM5P193MB00835F3E9901536A3FF319C28CF00%40AM5P193MB0083.EURP193.PROD.OUTLOOK.COM.
For more options, visit https://groups.google.com/d/optout.

How to fetch data from sql server and display on django web pages

[Amit Kadivar]

Please Help me.
How to fetch data from sql server and display them on django web pages 
through nginx web server..



-- 
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/b5577524-e67d-465f-bb49-e54bca92c88b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Connection with SQL server and user registration form

[Vineet Kothari]

Models with provide you with fields in django it is madatory to use model
thats why it is models. you ll have to change the configration in
settings.py to allow mysql as backend database


On Mon, Aug 28, 2017 at 9:57 PM, yingi keme <yingik...@gmail.com> wrote:

> Okk so django has its own server set up already configured
>
> All you need to so is type in the command
>
>  python manage.py runserver
>
> Yes. Django uses the MVC approach. So you have to use Models if you want
> to connect with your database.
>
>
>
> Yingi Kem
>
> On 28 Aug 2017, at 3:25 PM, Gopi Devarapalli <devarapalli.go...@gmail.com>
> wrote:
>
> Hi everyone,
>
> I am new to django. I just want to connect with sql server. And when user
> submit the form i need to save the details on the sql server database
> table.  And I am confusing that there are models that are using SQLite, is
> it mandatory to use Model?
>
> --
> 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/cac3e9a5-9cbf-4cde-8875-c32e20c2d637%40googlegroups.com
> <https://groups.google.com/d/msgid/django-users/cac3e9a5-9cbf-4cde-8875-c32e20c2d637%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 https://groups.google.com/d/
> msgid/django-users/D0A687A0-4027-4F46-90EF-F01626A0B240%40gmail.com
> <https://groups.google.com/d/msgid/django-users/D0A687A0-4027-4F46-90EF-F01626A0B240%40gmail.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 
https://groups.google.com/d/msgid/django-users/CAAcansv7678OG%3DHtSYxwQkf%2BNf6%2BLJd7c%3DLyZ_AkeGZ%3DDiwUjQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: Connection with SQL server and user registration form

[yingi keme]

Okk so django has its own server set up already configured

All you need to so is type in the command

 python manage.py runserver

Yes. Django uses the MVC approach. So you have to use Models if you want to 
connect with your database.



Yingi Kem

> On 28 Aug 2017, at 3:25 PM, Gopi Devarapalli <devarapalli.go...@gmail.com> 
> wrote:
> 
> Hi everyone,
> 
> I am new to django. I just want to connect with sql server. And when user 
> submit the form i need to save the details on the sql server database table.  
> And I am confusing that there are models that are using SQLite, is it 
> mandatory to use Model?
> -- 
> 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/cac3e9a5-9cbf-4cde-8875-c32e20c2d637%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/D0A687A0-4027-4F46-90EF-F01626A0B240%40gmail.com.
For more options, visit https://groups.google.com/d/optout.

Connection with SQL server and user registration form

[Gopi Devarapalli]

Hi everyone,

I am new to django. I just want to connect with sql server. And when user 
submit the form i need to save the details on the sql server database 
table.  And I am confusing that there are models that are using SQLite, is 
it mandatory to use Model?

-- 
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/cac3e9a5-9cbf-4cde-8875-c32e20c2d637%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Connect to SQL server but error when migrations

[max]

I have the following question post on stackoverflow 
<http://stackoverflow.com/questions/42903810/connect-to-sql-server-using-djangopyodbc>,
 
but no one can answer me.
Hope anyone who has experience on it, I appreciate it! 

-- 
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/504ff3f2-8356-4ba4-a281-762ace0768c2%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

[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

[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

[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

[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

[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 <mi...@dewhirst.com.au>
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
>> <mailto:django-users+unsubscr...@googlegroups.com>.
>> To post to this group, send email to django-users@googlegroups.com
>> <mailto: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-b

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

[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
<mailto:django-users+unsubscr...@googlegroups.com>.
To post to this group, send email to django-users@googlegroups.com
<mailto: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
<https://groups.google.com/d/msgid/django-users/90dab5d0-2f51-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 
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

[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.

Django and SQL Server

[Massimo Barbierato]

Hi everybody.

I have a little problem with SQL Server. I'm using django-pyodbc as db 
backend but when i run inspectdb it occurs an error because some of the 
tables in the SQL Server database have unicode chars (an example: the table 
name is 'Attività').
How can I resolve that?

I can't change tables names because another app is based on that db :(

Thanks

Max

ps: yes, the tables names are in italian :)

-- 
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/6e4532b6-56bb-4021-a923-d9cf2c1edcba%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Djnago 1.9.5 with SQL SERVER 2012 connect??

[Mandeep Tondak]

Thanks Nikolas.



Sent with MailTrack
<https://mailtrack.io/install?source=signature=en=mandeep...@gmail.com=22>

On Fri, May 13, 2016 at 10:44 PM, Nikolas Stevenson-Molnar <
nik.mol...@consbio.org> wrote:

> It looks like djano_pyodbc doesn’t support Django 1.9 yet:
> https://github.com/lionheart/django-pyodbc/issues/109
>
> If you don’t need 1.9, you could use Django 1.8 instead.
>
> _Nik
>
> On May 13, 2016, at 1:05 AM, mandeep444 <mandeep...@gmail.com> wrote:
>
> Hello All,
>
> I am try to connet Django 1.9.5 with MSSQL SERVER 2012.
>
> I have some Question:-
>
> is django work fine with SQLSERVER 2012 ?
>
> I try listed Package. but not success..
>
> 1.  'ENGINE': 'django_pyodbc',
>  Showing me Error:   Django 1.9 is not supported.
>
> 2.'ENGINE': 'sqlserver_ado',
>  showing me error:- #Try using 'django.db.backends.XXX', where XXX is one
> of: 'mysql', 'oracle', 'postgresql', 'sqlite3'
>
> 3. 'ENGINE': 'sql_server.pyodbc'
> django.db.utils.ProgrammingError: ('42000', "[42000]
> [unixODBC][FreeTDS][SQL Server]Login failed for user 'mandeep'. (18456)
> (SQLDriverConnect)")
>
>
> All are using with FreeTDS.
>
> i did not want to down grade my Django Version.
>
> Can anyone help me to out this problem.??
>
>
> Thanks
> Mandeep Kumar
>
> --
> 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/1d6e611a-ae5d-459e-b4ec-8008915303e3%40googlegroups.com
> <https://groups.google.com/d/msgid/django-users/1d6e611a-ae5d-459e-b4ec-8008915303e3%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
> https://groups.google.com/d/msgid/django-users/84E85995-87FA-4C55-A078-E8F37950CCA0%40consbio.org
> <https://groups.google.com/d/msgid/django-users/84E85995-87FA-4C55-A078-E8F37950CCA0%40consbio.org?utm_medium=email_source=footer>
> .
>
> For more options, visit https://groups.google.com/d/optout.
>



-- 
*Warm Regard:-*
*Mandeep Kumar*
<http://www.linkedin.com/in/mandeep444>
<http://www.techgig.com/mandeep444>

-- 
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/CAJri7ST39k2%2BOLyL4BQC93eSyWpzNAZW_D00_VPvzNG5a7PJXQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: Djnago 1.9.5 with SQL SERVER 2012 connect??

[Nikolas Stevenson-Molnar]

It looks like djano_pyodbc doesn’t support Django 1.9 yet: 
https://github.com/lionheart/django-pyodbc/issues/109 
<https://github.com/lionheart/django-pyodbc/issues/109>

If you don’t need 1.9, you could use Django 1.8 instead.

_Nik

> On May 13, 2016, at 1:05 AM, mandeep444 <mandeep...@gmail.com> wrote:
> 
> Hello All,
> 
> I am try to connet Django 1.9.5 with MSSQL SERVER 2012. 
> 
> I have some Question:-
> 
> is django work fine with SQLSERVER 2012 ?
> 
> I try listed Package. but not success..
> 
> 1.  'ENGINE': 'django_pyodbc',  
>  Showing me Error:   Django 1.9 is not supported.
> 
> 2.'ENGINE': 'sqlserver_ado',
>  showing me error:- #Try using 'django.db.backends.XXX', where XXX is one of: 
> 'mysql', 'oracle', 'postgresql', 'sqlite3'
> 
> 3. 'ENGINE': 'sql_server.pyodbc'
> django.db.utils.ProgrammingError: ('42000', "[42000] [unixODBC][FreeTDS][SQL 
> Server]Login failed for user 'mandeep'. (18456) (SQLDriverConnect)")
> 
> 
> All are using with FreeTDS.
> 
> i did not want to down grade my Django Version.
> 
> Can anyone help me to out this problem.??
> 
> 
> Thanks
> Mandeep Kumar
> 
> -- 
> 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 
> <mailto:django-users+unsubscr...@googlegroups.com>.
> To post to this group, send email to django-users@googlegroups.com 
> <mailto:django-users@googlegroups.com>.
> Visit this group at https://groups.google.com/group/django-users 
> <https://groups.google.com/group/django-users>.
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/django-users/1d6e611a-ae5d-459e-b4ec-8008915303e3%40googlegroups.com
>  
> <https://groups.google.com/d/msgid/django-users/1d6e611a-ae5d-459e-b4ec-8008915303e3%40googlegroups.com?utm_medium=email_source=footer>.
> For more options, visit https://groups.google.com/d/optout 
> <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/84E85995-87FA-4C55-A078-E8F37950CCA0%40consbio.org.
For more options, visit https://groups.google.com/d/optout.

Djnago 1.9.5 with SQL SERVER 2012 connect??

[mandeep444]

Hello All,

I am try to connet Django 1.9.5 with MSSQL SERVER 2012. 

I have some Question:-

is django work fine with SQLSERVER 2012 ?

I try listed Package. but not success..

1.  'ENGINE': 'django_pyodbc',  
 Showing me Error:   Django 1.9 is not supported.

2.'ENGINE': 'sqlserver_ado',
 showing me error:- #Try using 'django.db.backends.XXX', where XXX is one 
of: 'mysql', 'oracle', 'postgresql', 'sqlite3'

3. 'ENGINE': 'sql_server.pyodbc'
django.db.utils.ProgrammingError: ('42000', "[42000] 
[unixODBC][FreeTDS][SQL Server]Login failed for user 'mandeep'. (18456) 
(SQLDriverConnect)")


All are using with FreeTDS.

i did not want to down grade my Django Version.

Can anyone help me to out this problem.??


Thanks
Mandeep Kumar

-- 
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/1d6e611a-ae5d-459e-b4ec-8008915303e3%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Using Django with Microsoft SQL Server

[whycrying]

Sorry. `inspect` -> `inspectdb` .

On Fri, Jan 8, 2016 at 12:54 AM, whycrying <kwanw...@gmail.com> wrote:

> Using django-pyodbc for connecting to SQL Server as Sid said.
>
> Then use the `inspect` management command to build the models ::
>
> $ python manage.py inspectdb > models.py
>
> via:
> https://docs.djangoproject.com/en/1.8/howto/legacy-databases/#auto-generate-the-models
>
> Modified models generated to fit your styles.
>
>
> On Fri, Jan 8, 2016 at 12:19 AM, Sid <siddharthpees...@gmail.com> wrote:
>
>> I think if you install sql_server.pyodbc it should be fine
>>
>> UNDER databases in *settings.py *
>> 'default': {
>> 'ENGINE': 'sql_server.pyodbc',
>> 'NAME': '--',
>> 'HOST': '',
>> 'USER': '-',
>> 'PASSWORD': '-'
>> documentation: *https://pypi.python.org/pypi/django-pyodbc
>> <https://pypi.python.org/pypi/django-pyodbc>*
>> coding to pull data from sql:
>> * https://code.google.com/p/pyodbc/wiki/Cursor
>> <https://code.google.com/p/pyodbc/wiki/Cursor>*
>>
>> read the documentation for twice you should be fine
>>
>>
>>
>> On Thursday, January 7, 2016 at 10:34:34 AM UTC-5, Gerry Seidl wrote:
>>>
>>> Can someone please provide me the details, or point me to documentation
>>> on how to connect an existing SQL Server database to a new Django app?
>>>
>>> How would the models be built from it?
>>>
>>> Thanks,
>>>
>>> Gerry
>>>
>>>
>>>
>>>
>>>
>>>
>>> 
>>> The information transmitted in this email and any of its attachments is
>>> intended only for the person or entity to which it is addressed and may
>>> contain information concerning Cablevision and/or its affiliates and
>>> subsidiaries that is proprietary, privileged, confidential and/or subject
>>> to copyright. Any review, retransmission, dissemination or other use of, or
>>> taking of any action in reliance upon, this information by persons or
>>> entities other than the intended recipient(s) is prohibited and may be
>>> unlawful. If you received this in error, please contact the sender
>>> immediately and delete and destroy the communication and all of the
>>> attachments you have received and all copies thereof.
>>> 
>>>
>>> ...
>
>
-- 
https://www.zhangkaizhao.com/

-- 
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/CACKDpmfzDBD96oNZWBdOFn4fG1PFkNq8Rbbndh95b1JG1J%2ByLA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: Using Django with Microsoft SQL Server

[Sid]

I think if you install sql_server.pyodbc it should be fine

UNDER databases in *settings.py *
'default': {
'ENGINE': 'sql_server.pyodbc',
'NAME': '--',
'HOST': '',
'USER': '-',
'PASSWORD': '-'
documentation: *https://pypi.python.org/pypi/django-pyodbc*
coding to pull data from sql:
* https://code.google.com/p/pyodbc/wiki/Cursor*

read the documentation for twice you should be fine



On Thursday, January 7, 2016 at 10:34:34 AM UTC-5, Gerry Seidl wrote:
>
> Can someone please provide me the details, or point me to documentation on 
> how to connect an existing SQL Server database to a new Django app?
>
> How would the models be built from it?
>
> Thanks,
>
> Gerry
>
>  
>
>  
>
>
> 
> The information transmitted in this email and any of its attachments is 
> intended only for the person or entity to which it is addressed and may 
> contain information concerning Cablevision and/or its affiliates and 
> subsidiaries that is proprietary, privileged, confidential and/or subject 
> to copyright. Any review, retransmission, dissemination or other use of, or 
> taking of any action in reliance upon, this information by persons or 
> entities other than the intended recipient(s) is prohibited and may be 
> unlawful. If you received this in error, please contact the sender 
> immediately and delete and destroy the communication and all of the 
> attachments you have received and all copies thereof.
> 
>
>

-- 
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/5b85f879-19ea-4901-ba67-cfb1926f2566%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Using Django with Microsoft SQL Server

[Gerry Seidl]

Can someone please provide me the details, or point me to documentation on how 
to connect an existing SQL Server database to a new Django app?
How would the models be built from it?
Thanks,
Gerry





The information transmitted in this email and any of its attachments is 
intended only for the person or entity to which it is addressed and may contain 
information concerning Cablevision and/or its affiliates and subsidiaries that 
is proprietary, privileged, confidential and/or subject to copyright. Any 
review, retransmission, dissemination or other use of, or taking of any action 
in reliance upon, this information by persons or entities other than the 
intended recipient(s) is prohibited and may be unlawful. If you received this 
in error, please contact the sender immediately and delete and destroy the 
communication and all of the attachments you have received and all copies 
thereof.


-- 
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/DM2PR0501MB13573B5919CC86B412830B1FC8F50%40DM2PR0501MB1357.namprd05.prod.outlook.com.
For more options, visit https://groups.google.com/d/optout.

Re: Microsoft SQL Server and Azure SQL Database support

[Michael Manfre]

django-pyodbc-azure might be a better choice and it seems to be more 
actively maintained.

On Thursday, May 21, 2015 at 8:30:33 AM UTC-4, felix wrote:
>
>  El 20/05/15 14:39, Meet Bhagdev escribió:
>  
> When I last checked the Django ORM did not have official support for SQL 
> Server and Azure SQL DB. Is there a way to use SQL Server and more 
> importantly Azure SQL DB by modifying the DATABASES configuration 
> in settings.py 
>  
>  
>  Try django-pyodbc. On Linux I've used  it for SQL Server.
>  

-- 
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/ab9b9c1d-356d-45a9-8b43-e09897d4bcab%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Microsoft SQL Server and Azure SQL Database support

[felix]

El 20/05/15 14:39, Meet Bhagdev escribió:
When I last checked the Django ORM did not have official support for 
SQL Server and Azure SQL DB. Is there a way to use SQL Server and more 
importantly Azure SQL DB by modifying the DATABASES configuration 
in settings.py




Try django-pyodbc. On Linux I've used  it for SQL Server.

--
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/555DD0C2.5060709%40epepm.cupet.cu.
For more options, visit https://groups.google.com/d/optout.

Microsoft SQL Server and Azure SQL Database support

[Meet Bhagdev]

When I last checked the Django ORM did not have official support for SQL 
Server and Azure SQL DB. Is there a way to use SQL Server and more 
importantly Azure SQL DB by modifying the DATABASES configuration 
in settings.py
 

-- 
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/be731de8-cce9-4946-8d0a-d71767669a0f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: SQL Server Support - Does it Exist

[Alex-droid AD]

We try to use django-pyodbc on CentOS (python 2.7 + Django 1.8, connection 
to MS SQL Server 2012)
While running 'migrare' I get the same error as mentioned above:
'django_pyodbc' isn't an available database backend

Can't understand what has been done wrong...

On Sunday, March 24, 2013 at 5:14:55 PM UTC+3, Michael Manfre wrote:
>
> Although there is no official support for SQL Server, there are two 
> available backends to choose from; django-mssql and django-pyodbc. There 
> has also been some recent discussion on the django-developers mailing list 
> about SQL Server's support and the idea of having officially recognized 
> extensions (see [1]).
>
> [1] 
> https://groups.google.com/d/msg/django-developers/O-g06EM6XMM/Y7PcP5VUzYMJ
>
> I'm the maintainer of django-mssql and have been using it on 
> http://www.src.org since Django 1.1 and has upgrade to the Django stable 
> version shortly after each release. We're currently on Django 1.4.x and 
> plan on upgrading to Django 1.5 in the next few months. Django-mssql 
> requires pywin32 and must be run on a Windows server. During the ~1.5 years 
> between your post and the previous one in this topic, the django-mssql 
> project has made a lot of improvements, including better documentation [2].
>
> [2] http://django-mssql.readthedocs.org/en/latest/
>
> If your web servers are non-windows, then you can use django-pyodbc. The 
> google code hosted project [3] is a bit out of date, but there is a 
> slightly newer fork available on GitHub [4].
>
> [3] https://code.google.com/p/django-pyodbc/
> [4] https://github.com/avidal/django-pyodbc
>
> Regards,
> Michael Manfre
>
> On Saturday, March 23, 2013 12:35:08 AM UTC-4, Liang wrote:
>>
>> Sadly, django doesn't support sql server officially is the only stopper 
>> for me to adopt django. 
>>
>> On Friday, 15 July 2011 09:07:23 UTC+8, Russell Keith-Magee wrote:
>>>
>>> On Fri, Jul 15, 2011 at 6:03 AM, bruno desthuilliers
>>> <bruno.des...@gmail.com> wrote:
>>> >
>>> >
>>> > On 14 juil, 23:15, Python_Junkie <software.buy.des...@gmail.com>
>>> > wrote:
>>> >> I have searched for the drivers to use the syncdb utility with MS SQL
>>> >> Server but have been unsuccessful.
>>> >
>>> > https://docs.djangoproject.com/en/1.3/ref/databases/
>>> >
>>> > Django doesn't support MS SQL.
>>>
>>> Django doesn't provide *official* support MSSQL. However, we do have a
>>> supported backend API, and there are several third-party projects that
>>> implement MS SQL support [1]. I can't comment on their completeness or
>>> stability, but the projects exist.
>>>
>>> [1] 
>>> https://docs.djangoproject.com/en/1.3/ref/databases/#using-a-3rd-party-database-backend
>>>
>>> Yours,
>>> Russ Magee %-)
>>>
>>>

-- 
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/b217f87a-19d3-42a2-aa02-7f0faaee71e4%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: SQL Server performance problem

[chj]

Avoid using ODBC. It's horribly slow. While I have no experience with 
MSSQL, you may have a look at 
django-mssql: https://django-mssql.readthedocs.org/

-- 
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/7dd2f7a6-8f6c-4dc8-8b4e-538a07d10fcd%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

SQL Server performance problem

[Fred]

I'm on a W7 32bit virtual machine with python 2.7 and SQL Server 2008 with 
local views referencing Linked Server where the real data resides.
My setup is 
Django (1.7.4)
django-pyodbc (0.2.6)
django-pyodbc-azure (1.2.3)  not using this, it was a false 
start that did not pan out.
mysqlclient (1.3.4)
pip (1.5.6)
pymssql (2.1.1)
pyodbc (3.0.6)
requests (2.5.1)
setuptools (7.0)
I quit using pymssql because I could not get that to work with Django.

I created an ODBC link to my local DB and it works reasonably well until I 
try to do a join.
Using SQL Server management studio, the join takes about 2 seconds
Using Django and select_related() the join takes 1.5 minutes.

I'm just in the early stages of building my app and am developing simple 
test scripts to verify the data is as expected.  But I cannot work with 
this much delay and I'm no expert at how to tune this query.  An example is
records = 
models.Admissions.objects.select_related().filter(dischargedatetime=None, 
datebedinactive=None)

class Residents(models.Model): #~2000 records
entitysys = models.IntegerField(primary_key=True, 
db_column='EntitySys')  
internalid = models.TextField(db_column='InternalID', blank=True)  
externalid = models.TextField(db_column='ExternalID', blank=True)  
lastname = models.TextField(db_column='LastName', blank=True)  
firstname = models.TextField(db_column='FirstName', blank=True)  
...
class Admissions(models.Model):  #~300 records
episodesys = models.IntegerField(primary_key=True,  
db_column='EpisodeSys')  
resident = models.ForeignKey(Residents, db_column='ResidentSys', 
blank=True, null=True)  
episodetype = models.CharField(db_column='EpisodeType', max_length=2, 
blank=True)  
...

This is a new project and so there is much less data entered than there 
will be once fully implemented.  Is there a way to improve the performance 
within the django model framework?


-- 
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/50e17d3f-9af3-4f40-b579-00c2e58a64e8%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Porting to Django Linux with SQL Server Backend

[robert brook]

Thank you for your response.

I saw that you mentioned that you were getting seg faults

I noticed on a web site that there was an entry that might overcome that 
problem
http://www.kcaran.com/entries/technology/linux/linuxodbc.html

***

sing Red Hat, you may get a ‘Segmentation Fault’ using DBI, even though 
connecting to the database works fine with *tsql*. If this happens, try 
setting the following environmental variable: PERL_DL_NONLAZY = 1 
Read this Usenet thread for more details 
<http://groups.google.com/group/perl.dbi.users/tree/browse_frm/thread/995131d999ca388/b3d60553c8f87d4d?rnum=1=en=redhat+DBI+%22segmentation+fault%22&_done=%2Fgroup%2Fperl.dbi.users%2Fbrowse_frm%2Fthread%2F995131d999ca388%2Fd0fb4863311789f6%3Flnk%3Dst%26q%3Dredhat+DBI+%22segmentation+fault%22%26rnum%3D1%26hl%3Den%26#doc_f937fadc7f1ba28d>

*NOTE:* This appears to be fixed.
https://rhn.redhat.com/errata/RHBA-2006-0319.html

***

On Thursday, October 16, 2014 1:18:21 AM UTC-4, WongoBongo wrote:
>
> I have a working system running Django 1.6/Python 2.7 on RHEL 7 connecting 
> to MSSQL2012 SP 2 on Win Server.
>
> On the Linux box we are installing this with Pip requirements:
>
>  git+https://code.google.com/p/pyodbc@3.0.7#egg=pyodbc
>  django-pyodbc-azure==1.1.5
>
> The local_settings.py contains:
>
> DATABASES = {
> "default": {
> ...
> "HOST": "192.168.0.10",
> "PORT": "",
> "OPTIONS": {
> "driver": "FreeTDS",
> "dsn": "sqlserverdatasource",
> 'host_is_server': True,
> 'autocommit': True,
> 'unicode_results': True,
> 'extra_params': 'tds_version=8.0'
> }
> }
> }
>
> We are running the latest FreeTDS from 2011.
>
> $ tsql -C
> ...
> freetds v0.91
>
> We've had quirky problems with it and a few mysterious segfaults on the 
> application server from time to time. It does work for the most part, but 
> the application isn't under any kind of load at the moment.
>
> If I had a choice, I wouldn't run Django on MSSQL Server.
>
> - K
>
>
> On Wednesday, October 15, 2014 7:13:04 AM UTC-7, robert brook wrote:
>>
>> Sorry I guess I should have focused the question better.
>>
>> I have a working connector on my windows machine using django-pyodbc-azure
>>
>> I can and will use this connector on the new Linux installation.
>>
>> Since I have never tested this on a Linux machine yet, I wanted to see if 
>> anyone had any successful experiences with this connector
>> or any other connector  on a Red Hat Linux box.
>>
>> By the way I looked at the link below and the comments on the git page 
>> seem that they are lagging behind on developing this package with
>> the current releases of both python and django
>>
>> Thanks
>> Bob
>>
>> On Wednesday, October 15, 2014 9:34:46 AM UTC-4, Michael Manfre wrote:
>>>
>>> It's hard to give constructive feedback without knowing any of the 
>>> specific errors you encountered, but django-mssql only works on Windows. 
>>> Depending on the error you encountered with pymssql, you could try 
>>> django-pymssql (https://github.com/aaugustin/django-pymssql).
>>>
>>> Regards,
>>> Michael Manfre
>>>
>>> On Wednesday, October 15, 2014 9:03:54 AM UTC-4, robert brook wrote:
>>>>
>>>> The group has been developing locally with sqllite on Windows.
>>>>
>>>> We are porting the installation to a Linux environment /windows sql 
>>>> server.
>>>>
>>>> Looking for suggestions for database connectors from Linux to sql 
>>>> server 2014
>>>> using:
>>>> python3.3
>>>> django 1.7
>>>>
>>>> I have installed a local copy of sql server to try and find a connector 
>>>> package
>>>> I have tried the following packages on my windows machine with a local 
>>>> copy of sql server
>>>>
>>>> django-pyodbc-azure   -This worked after creating a local odbc 
>>>> connection
>>>>
>>>> The following failed with a variety of errors.
>>>> django-pyodbc
>>>> pymssql
>>>> django-sqlserver
>>>> django-mssql
>>>>
>>>> Any suggestions for the sql server connection for any of these would be 
>>>> appreciated.
>>>>
>>>> Thanks in advance
>>>>
>>>

-- 
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/41e1b51d-dc38-4dd0-bda9-14d68d5886ba%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.