Fred- This project has been put on the back burner for a few weeks, but I will be getting back to it. If you could dig up your notes on this, that would be really great.
Thanks very much! -larry On Sun, Jan 19, 2014 at 7:01 AM, Fred Stluka <[email protected]> wrote: > Larry, > > We tried django-mssql and gave up. Much better luck with > django-pyodbc. We use the avidal version of it, along with pyodbc, > FreeTDS, and unixODBC. Works perfectly. If you like, I can dig up > my notes on exactly how we made the connection from Django to > MS SQL Server. > > --Fred > ________________________________ > Fred Stluka -- mailto:[email protected] -- http://bristle.com/~fred/ > Bristle Software, Inc -- http://bristle.com -- Glad to be of service! > Open Source: Without walls and fences, we need no Windows or Gates. > ________________________________ > > On 1/14/14 6:15 PM, Larry Martell wrote: > > I am trying to connect to a MS SQL server from django on Linux using > Vernon Cole's django-mssql package > (https://bitbucket.org/vernondcole/django-mssql-ado-merge/src). > > When I first tried to connect it failed with: > > Exception Type: DatabaseError at /report/CDSEM/EventsTable/ > Exception Value: Cannot create connection > to=PYRO:[email protected]:9099 > > I traced it through > /usr/lib/python2.6/site-packages/adodbapi/remote.py and I see it tries > to access os.environ['PROXY_PORT'], which is not defined and then it > defaults to 9099 - Is that the correct port or should I set > os.environ['PROXY_PORT']? How can I tell what port MS SQL db is > listening on? I googled this and it said the default MS SQL port is > 1433. I set os.environ['PROXY_PORT'] to that and now I don't get that > error but it times out: > > /usr/lib/python2.6/site-packages/Pyro4-4.22-py2.6.egg/Pyro4/core.py(160)__call__() > > -> return self.__send(self.__name, args, kwargs) > (Pdb) n > TimeoutError: TimeoutE...imeout',) > > I tried opening port 1433 with iptables, but still no joy. > > I can connect to the MS SQL db locally from the host it's running so I > know it's up and my credentials are correct, and I can ping the > Windows box from the Linux host I am running on, so I know there is > connectivity to it from there. > > Anyone here ever get this working? Anyone have any ideas as to what my > problem is or how I can debug this further? > > Thanks! > -larry -- 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 [email protected]. To post to this group, send email to [email protected]. 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/CACwCsY46pZJ--KV0wbaGADUpkQBYbhYvusxmQyn8ZyS0PYSqjQ%40mail.gmail.com. For more options, visit https://groups.google.com/groups/opt_out.
