I successfully installed django-mssql onto my windows 7 machine. I was then able to add the connection info to my local SQL Server in my django settings.py file (I had to add, under OPTIONS, to use a provider of 'SQLOLEDB' and 'use_mars' of True). Once I had added the OPTIONS value, I was able, from the command line, to do a "python manage.py syncdb" and have the tables created in my database.
However, when I try and hit any page in apache I get a windows popup saying "The program can't start because MSVCR90.dll is missing from your computer". If I click the 'OK' on the popup, I am then shown the following error in the browser along with the server 500 error:
ImproperlyConfigured at /products
'sqlserver_ado' isn't an available database backend.
Try using django.db.backends.XXX, where XXX is one of:
'dummy', 'mysql', 'oracle', 'postgresql_psycopg2', 'sqlite3'
Error was: No system module 'pywintypes' (pywintypes27.dll)
Request Method: GET
Request URL: [redacted]
Django Version: 1.4.2
Exception Type: ImproperlyConfigured
'sqlserver_ado' isn't an available database backend. Try using django.db.backends.XXX, where XXX is one of: 'dummy', 'mysql', 'oracle', 'postgresql_psycopg2', 'sqlite3' Error was: No system module 'pywintypes' (pywintypes27.dll) Exception Location: C:\Python27\lib\site-packages\django\db\utils.py in load_backend, line 44 Python Executable: C:\xampp\apache\bin\httpd.exe Python Version: 2.7.3 Python Path:
['C:\Windows\system32\python27.zip', 'C:\Python27\Lib', 'C:\Python27\DLLs', 'C:\Python27\Lib\lib-tk', 'C:\xampp', 'C:\xampp\apache\bin', 'C:\Python27', 'C:\Python27\lib\site-packages', 'C:\Python27\lib\site-packages\win32', 'C:\Python27\lib\site-packages\win32\lib', 'C:\Python27\lib\site-packages\Pythonwin', ] Server time: Fri, 22 Mar 2013 12:10:01 -0600
Googling, it may be related to this? https://groups.google.com/forum/?fromgroups=#!topic/pyodbc/xwGM8XtGofk
What do I do now? Stuck.