Solved

use mssql with django

Posted on 2014-02-21
12
164 Views
Last Modified: 2014-03-02
i'm brand new - still installing

how do i "install" the ability to use an mssql db?
0
Comment
Question by:dgrafx
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 5
12 Comments
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 39877447
You would apparently have to write your own interface code because it is not one of the 'supported' databases.  https://docs.djangoproject.com/en/1.6/topics/install/#database-installation

Looks like someone else may have already done that:  http://django-mssql.readthedocs.org/en/latest/
0
 
LVL 25

Author Comment

by:dgrafx
ID: 39877468
thanks Dave - will check it out
0
 
LVL 25

Author Comment

by:dgrafx
ID: 39877482
Dave - earlier before you posted I was reading the docs and came across code like this:
DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.sqlite3',
        'NAME': 'mydatabase'
    }
}

WHERE can i find this code?
Is this a python file? extension of .py?
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 39877668
SQLite comes with Django.  See here for more info: https://docs.djangoproject.com/en/1.6/ref/settings/#std:setting-DATABASES
0
 
LVL 25

Author Comment

by:dgrafx
ID: 39877834
Dave
What i mean is where are the files that code like this is in?
They appear to be config files - where are they?

I didn't mean what is SQlite.

as i said in the beginning i am brand new to django and also python.
i don't know anything.
0
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 39877906
Then you need to first go thru the installation procedure and then do the tutorial.  There is too much to answer here and the docs are your best friend for this.

https://docs.djangoproject.com/en/1.6/intro/install/

https://docs.djangoproject.com/en/1.6/intro/tutorial01/
0
 
LVL 25

Author Comment

by:dgrafx
ID: 39877949
Dave
I have Django 1.7 & Python 3.3 installed already.

What I'm doing now is asking questions where I'm having difficulty.
I already have link to online docs ...
0
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 39878166
The install instructions and the tutorial answer the questions you've asked so far including where to put the files and where that database directive goes.  I even found the 'alternate' database info there when I looked again.  You should install and run the tutorial to get a better understanding.
0
 
LVL 25

Accepted Solution

by:
dgrafx earned 0 total points
ID: 39887475
The problem was that the 3.x versions of Python don't seem to work with the Django-mssql package.
And since I am a complete newb I didn't know what I was doing wrong or what instructions I was misreading.
So I uninstalled and started from scratch using Python 2.7 and zero issues getting everything installed - distribute - pip - django - mssql
0
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 39887542
Good for you, glad you figured it out.
0
 
LVL 25

Author Comment

by:dgrafx
ID: 39887545
thanks Dave
0
 
LVL 25

Author Closing Comment

by:dgrafx
ID: 39898369
This is the solution to why I couldn't get mssql installed
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Pyhon with Oracle encoding issue 8 128
linux / python expert needed 3 103
Visualizing tuple values in Python (or generally) 3 86
Python 3.5.2 - I need help with a script 8 49
A set of related code is known to be a Module, it helps us to organize our code logically which is much easier for us to understand and use it. Module is an object with arbitrarily named attributes which can be used in binding and referencing. …
Article by: Swadhin
Introduction of Lists in Python: There are six built-in types of sequences. Lists and tuples are the most common one. In this article we will see how to use Lists in python and how we can utilize it while doing our own program. In general we can al…
Learn the basics of lists in Python. Lists, as their name suggests, are a means for ordering and storing values. : Lists are declared using brackets; for example: t = [1, 2, 3]: Lists may contain a mix of data types; for example: t = ['string', 1, T…
Learn the basics of while and for loops in Python.  while loops are used for testing while, or until, a condition is met: The structure of a while loop is as follows:     while <condition>:         do something         repeate: The break statement m…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question