1. Michael Manfre
  2. django-mssql

Issues

Issue #27 invalid

MSVCR90.dll is missing

Anonymous created an issue

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 Exception Value:
'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.

Comments (3)

  1. mreinbold

    I solved my own issue based on this thread: https://code.google.com/p/pyodbc/issues/detail?id=126#c11

    The problem was that I was using an older version of XAMPP, one that apparently had been compiled using an older version of Microsoft's runtime. Never an issue until now.

    an important note I couldn't just install the latest version of XAMPP (1.8.1) since it has a version of a Apache (2.4.3) that seems incompatible with the mod_wsgi.so module - couldn't even get it to start. I had to install XAMPP 1.7.7, which is the latest with Apache 2.2, which works with mod_wsgi, allowing me to run python, which can NOW talk to SQL Server through django-mssql. (Sheesh!)

  2. Log in to comment