Re: mssql databASE CONNECTION to Django

2015-11-05 Thread Collin Anderson 
Hello,

I'd recommend using django 1.7 until mssql gets compatible with django 1.8.

Thanks,
Collin

On Friday, October 30, 2015 at 3:31:35 PM UTC+1, Sid wrote:
>
> sorry tim I know I am asking a dumb question...can you please tell me what 
> is the best way to make it work please if possibe...because I am struck 
> form last 2 days
>

-- 
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/111d7267-3597-4bdb-8bb9-20e3eb13879c%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: mssql databASE CONNECTION to Django

2015-10-30 Thread Sid 
np...but thanks for your time

-- 
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/0f860fa9-7fa0-4045-aa09-92bc7eb3cf73%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: mssql databASE CONNECTION to Django

2015-10-30 Thread Tim Graham 
Sorry, I haven't used the library myself and can't provide any additional 
help.

On Friday, October 30, 2015 at 10:31:35 AM UTC-4, Sid wrote:
>
> sorry tim I know I am asking a dumb question...can you please tell me what 
> is the best way to make it work please if possibe...because I am struck 
> form last 2 days
>

-- 
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/28279fb0-be9c-47bc-b4de-1080a6b5c759%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: mssql databASE CONNECTION to Django

2015-10-30 Thread Sid 
sorry tim I know I am asking a dumb question...can you please tell me what 
is the best way to make it work please if possibe...because I am struck 
form last 2 days

-- 
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/440c0480-4b24-4495-bb57-ac47a6a00f55%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: mssql databASE CONNECTION to Django

2015-10-30 Thread Tim Graham 
Please read the documentation: 
https://django-mssql.readthedocs.org/en/latest/quickstart.html

On Friday, October 30, 2015 at 9:53:42 AM UTC-4, Sid wrote:
>
> so which version will be compatible...
>
> On Friday, October 30, 2015 at 7:54:26 AM UTC-4, Tim Graham wrote:
>>
>> django-mssql doesn't support Django 1.8 yet:
>>
>> https://django-mssql.readthedocs.org/en/latest/changelog.html
>>
>> On Thursday, October 29, 2015 at 9:36:38 PM UTC-4, Sid wrote:
>>>
>>> *Hi all,*
>>> I am trying to connect database which is in server to django, but it is 
>>> showing many errors like(platform i am using M visual studio)
>>>
>>> *Traceback (most recent call last):*
>>>   File "C:\Users\speesary\Desktop\programs\learn\learn\manage.py", line 
>>> 17, in 
>>> execute_from_command_line(sys.argv)
>>>   File 
>>> "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\core\management\__init__.py",
>>>  
>>> line 351, in execute_from_command_line
>>> utility.execute()
>>>   File 
>>> "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\core\management\__init__.py",
>>>  
>>> line 325, in execute
>>> django.setup()
>>>   File 
>>> "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\__init__.py",
>>>  
>>> line 18, in setup
>>> apps.populate(settings.INSTALLED_APPS)
>>>   File 
>>> "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\apps\registry.py",
>>>  
>>> line 108, in populate
>>> app_config.import_models(all_models)
>>>   File 
>>> "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\apps\config.py",
>>>  
>>> line 198, in import_models
>>> self.models_module = import_module(models_module_name)
>>>   File 
>>> "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\importlib\__init__.py",
>>>  
>>> line 37, in import_module
>>> __import__(name)
>>>   File 
>>> "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\contrib\auth\models.py",
>>>  
>>> line 41, in 
>>> class Permission(models.Model):
>>>   File 
>>> "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\db\models\base.py",
>>>  
>>> line 139, in __new__
>>> new_class.add_to_class('_meta', Options(meta, **kwargs))
>>>   File 
>>> "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\db\models\base.py",
>>>  
>>> line 324, in add_to_class
>>> value.contribute_to_class(cls, name)
>>>   File 
>>> "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\db\models\options.py",
>>>  
>>> line 250, in contribute_to_class
>>> self.db_table = truncate_name(self.db_table, 
>>> connection.ops.max_name_length())
>>>   File 
>>> "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\db\__init__.py",
>>>  
>>> line 36, in __getattr__
>>> return getattr(connections[DEFAULT_DB_ALIAS], item)
>>>   File 
>>> "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\db\utils.py",
>>>  
>>> line 240, in __getitem__
>>> backend = load_backend(db['ENGINE'])
>>>   File 
>>> "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\db\utils.py",
>>>  
>>> line 111, in load_backend
>>> return import_module('%s.base' % backend_name)
>>>   File 
>>> "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\importlib\__init__.py",
>>>  
>>> line 37, in import_module
>>> __import__(name)
>>>   File 
>>> "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\db\backends\sqlserver_ado\base.py",
>>>  
>>> line 5, in 
>>> from django.db.backends import BaseDatabaseWrapper, 
>>> BaseDatabaseFeatures, BaseDatabaseValidation, BaseDatabaseClient
>>> ImportError: cannot import name BaseDatabaseWrapper
>>> The Python REPL process has exited
>>>
>>> code in my *settings.py*
>>> *PACKAGES ADDED:*
>>> *from django.db.backends.base.base import BaseDatabaseWrapperfrom 
>>> django.db.backends.base.client import BaseDatabaseClientfrom 
>>> django.db.backends.base.creation import BaseDatabaseCreationfrom 
>>> django.db.backends.base.features import BaseDatabaseFeaturesfrom 
>>> django.db.backends.base.introspection import BaseDatabaseIntrospection#from 
>>> django.db.backends.base.introspection import FieldInfo, TableInfofrom 
>>> django.db.backends.base.operations import BaseDatabaseOperationsfrom 
>>> django.db.backends.base.schema import BaseDatabaseSchemaEditorfrom 
>>> django.db.backends.base.validation import BaseDatabaseValidationfrom 
>>> django.db.backends.util import CursorWrapperfrom os import path*
>>>
>>> 'default': {
>>> 'ENGINE':

Re: mssql databASE CONNECTION to Django

2015-10-30 Thread Sid 
so which version will be compatible...

On Friday, October 30, 2015 at 7:54:26 AM UTC-4, Tim Graham wrote:
>
> django-mssql doesn't support Django 1.8 yet:
>
> https://django-mssql.readthedocs.org/en/latest/changelog.html
>
> On Thursday, October 29, 2015 at 9:36:38 PM UTC-4, Sid wrote:
>>
>> *Hi all,*
>> I am trying to connect database which is in server to django, but it is 
>> showing many errors like(platform i am using M visual studio)
>>
>> *Traceback (most recent call last):*
>>   File "C:\Users\speesary\Desktop\programs\learn\learn\manage.py", line 
>> 17, in 
>> execute_from_command_line(sys.argv)
>>   File 
>> "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\core\management\__init__.py",
>>  
>> line 351, in execute_from_command_line
>> utility.execute()
>>   File 
>> "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\core\management\__init__.py",
>>  
>> line 325, in execute
>> django.setup()
>>   File 
>> "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\__init__.py",
>>  
>> line 18, in setup
>> apps.populate(settings.INSTALLED_APPS)
>>   File 
>> "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\apps\registry.py",
>>  
>> line 108, in populate
>> app_config.import_models(all_models)
>>   File 
>> "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\apps\config.py",
>>  
>> line 198, in import_models
>> self.models_module = import_module(models_module_name)
>>   File 
>> "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\importlib\__init__.py",
>>  
>> line 37, in import_module
>> __import__(name)
>>   File 
>> "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\contrib\auth\models.py",
>>  
>> line 41, in 
>> class Permission(models.Model):
>>   File 
>> "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\db\models\base.py",
>>  
>> line 139, in __new__
>> new_class.add_to_class('_meta', Options(meta, **kwargs))
>>   File 
>> "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\db\models\base.py",
>>  
>> line 324, in add_to_class
>> value.contribute_to_class(cls, name)
>>   File 
>> "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\db\models\options.py",
>>  
>> line 250, in contribute_to_class
>> self.db_table = truncate_name(self.db_table, 
>> connection.ops.max_name_length())
>>   File 
>> "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\db\__init__.py",
>>  
>> line 36, in __getattr__
>> return getattr(connections[DEFAULT_DB_ALIAS], item)
>>   File 
>> "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\db\utils.py",
>>  
>> line 240, in __getitem__
>> backend = load_backend(db['ENGINE'])
>>   File 
>> "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\db\utils.py",
>>  
>> line 111, in load_backend
>> return import_module('%s.base' % backend_name)
>>   File 
>> "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\importlib\__init__.py",
>>  
>> line 37, in import_module
>> __import__(name)
>>   File 
>> "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\db\backends\sqlserver_ado\base.py",
>>  
>> line 5, in 
>> from django.db.backends import BaseDatabaseWrapper, 
>> BaseDatabaseFeatures, BaseDatabaseValidation, BaseDatabaseClient
>> ImportError: cannot import name BaseDatabaseWrapper
>> The Python REPL process has exited
>>
>> code in my *settings.py*
>> *PACKAGES ADDED:*
>> *from django.db.backends.base.base import BaseDatabaseWrapperfrom 
>> django.db.backends.base.client import BaseDatabaseClientfrom 
>> django.db.backends.base.creation import BaseDatabaseCreationfrom 
>> django.db.backends.base.features import BaseDatabaseFeaturesfrom 
>> django.db.backends.base.introspection import BaseDatabaseIntrospection#from 
>> django.db.backends.base.introspection import FieldInfo, TableInfofrom 
>> django.db.backends.base.operations import BaseDatabaseOperationsfrom 
>> django.db.backends.base.schema import BaseDatabaseSchemaEditorfrom 
>> django.db.backends.base.validation import BaseDatabaseValidationfrom 
>> django.db.backends.util import CursorWrapperfrom os import path*
>>
>> 'default': {
>> 'ENGINE': 'django.db.backends.sqlserver_ado'  ,   
>> 
>>  #'django.db.backends.sqlserver_ado'
>> 'NAME': 'Siddharth',
>> 'USER': 'SCGLOBAL\speesary@ALMDATA',
>> 'PASSWORD': '',
>> 'HOST': '127.0.0.1',
>>

Re: mssql databASE CONNECTION to Django

2015-10-30 Thread Tim Graham 
django-mssql doesn't support Django 1.8 yet:

https://django-mssql.readthedocs.org/en/latest/changelog.html

On Thursday, October 29, 2015 at 9:36:38 PM UTC-4, Sid wrote:
>
> *Hi all,*
> I am trying to connect database which is in server to django, but it is 
> showing many errors like(platform i am using M visual studio)
>
> *Traceback (most recent call last):*
>   File "C:\Users\speesary\Desktop\programs\learn\learn\manage.py", line 
> 17, in 
> execute_from_command_line(sys.argv)
>   File 
> "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\core\management\__init__.py",
>  
> line 351, in execute_from_command_line
> utility.execute()
>   File 
> "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\core\management\__init__.py",
>  
> line 325, in execute
> django.setup()
>   File 
> "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\__init__.py",
>  
> line 18, in setup
> apps.populate(settings.INSTALLED_APPS)
>   File 
> "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\apps\registry.py",
>  
> line 108, in populate
> app_config.import_models(all_models)
>   File 
> "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\apps\config.py",
>  
> line 198, in import_models
> self.models_module = import_module(models_module_name)
>   File 
> "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\importlib\__init__.py",
>  
> line 37, in import_module
> __import__(name)
>   File 
> "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\contrib\auth\models.py",
>  
> line 41, in 
> class Permission(models.Model):
>   File 
> "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\db\models\base.py",
>  
> line 139, in __new__
> new_class.add_to_class('_meta', Options(meta, **kwargs))
>   File 
> "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\db\models\base.py",
>  
> line 324, in add_to_class
> value.contribute_to_class(cls, name)
>   File 
> "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\db\models\options.py",
>  
> line 250, in contribute_to_class
> self.db_table = truncate_name(self.db_table, 
> connection.ops.max_name_length())
>   File 
> "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\db\__init__.py",
>  
> line 36, in __getattr__
> return getattr(connections[DEFAULT_DB_ALIAS], item)
>   File 
> "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\db\utils.py",
>  
> line 240, in __getitem__
> backend = load_backend(db['ENGINE'])
>   File 
> "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\db\utils.py",
>  
> line 111, in load_backend
> return import_module('%s.base' % backend_name)
>   File 
> "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\importlib\__init__.py",
>  
> line 37, in import_module
> __import__(name)
>   File 
> "C:\Users\speesary\AppData\Local\Continuum\Anaconda\lib\site-packages\django-1.8.5-py2.7.egg\django\db\backends\sqlserver_ado\base.py",
>  
> line 5, in 
> from django.db.backends import BaseDatabaseWrapper, 
> BaseDatabaseFeatures, BaseDatabaseValidation, BaseDatabaseClient
> ImportError: cannot import name BaseDatabaseWrapper
> The Python REPL process has exited
>
> code in my *settings.py*
> *PACKAGES ADDED:*
> *from django.db.backends.base.base import BaseDatabaseWrapperfrom 
> django.db.backends.base.client import BaseDatabaseClientfrom 
> django.db.backends.base.creation import BaseDatabaseCreationfrom 
> django.db.backends.base.features import BaseDatabaseFeaturesfrom 
> django.db.backends.base.introspection import BaseDatabaseIntrospection#from 
> django.db.backends.base.introspection import FieldInfo, TableInfofrom 
> django.db.backends.base.operations import BaseDatabaseOperationsfrom 
> django.db.backends.base.schema import BaseDatabaseSchemaEditorfrom 
> django.db.backends.base.validation import BaseDatabaseValidationfrom 
> django.db.backends.util import CursorWrapperfrom os import path*
>
> 'default': {
> 'ENGINE': 'django.db.backends.sqlserver_ado'  ,   
> 
>  #'django.db.backends.sqlserver_ado'
> 'NAME': 'Siddharth',
> 'USER': 'SCGLOBAL\speesary@ALMDATA',
> 'PASSWORD': '',
> 'HOST': '127.0.0.1',
> 'PORT':'',
> 'OPTIONS': {
>  
> 'driver':'SQL Server Native Client 11.0',
> 'MARS_Connection': True,
> can anyone please tell me the procedure how to do it. it will be very 
> helpful...
>