Re: Connecting to a MS SQL server from django

Fred- I finally got around to trying this. It all worked perfectly until I tried to access the MSSQL server from django. That fails with: mod_wsgi (pid=27541): Exception occurred processing WSGI script '/usr/local/motor/motor/wsgi.py'. Traceback (most recent call last): File "/usr/local/lib/pyt

Re: Connecting to a MS SQL server from django

Thank you very much Fred. When I get back to this I will let you know how it went. On Sun, Jan 19, 2014 at 10:26 PM, Fred Stluka wrote: > Larry, > > I did it a long complicated way, but we recently had 2 new people > join our team, and refined the process for them, and it seemed to > go smoothly,

Re: Connecting to a MS SQL server from django

Larry, I did it a long complicated way, but we recently had 2 new people join our team, and refined the process for them, and it seemed to go smoothly, so here's what they did. Some sections differ for Mac vs Linux, and some even for different Linux distros, but it should all work. I'm includin

Re: Connecting to a MS SQL server from django

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 wrote: > Larry, > > We tried django-mssql and gave up.

Re: Connecting to a MS SQL server from django

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 ---

Re: Connecting to a MS SQL server from django

Larry, +1 for Pycharm (JetBrains). I use their DB tools to explore both MS SQL and MySQL DBs. If you like, I can dig up my notes on exactly how I made the connection from PyCharm to MS SQL Server. --Fred Fred Stluka -- ma

Re: Connecting to a MS SQL server from django

On Wed, Jan 15, 2014 at 9:51 AM, Avraham Serour wrote: > pycharm and jetbrains tools come with a db explorer > > with a simple google search I found this [0] and [1] which have some > references, you could also try [2] with wine > > [0] http://stackoverflow.com/questions/399505/sql-server-gui-for-

Re: Connecting to a MS SQL server from django

pycharm and jetbrains tools come with a db explorer with a simple google search I found this [0] and [1] which have some references, you could also try [2] with wine [0] http://stackoverflow.com/questions/399505/sql-server-gui-for-linux [1] http://stackoverflow.com/questions/721852/developer-too

Re: Connecting to a MS SQL server from django

Maybe Your MSSQL server is listening only on loopback interface. Telnet from linux box to windows server on port 1433 and check if port is open. You can see also this few pages, just depends on Your server version.: http://blogs.msdn.com/b/sqlblog/archive/2009/07/17/how-to-configure-sql-server-to-

Re: Connecting to a MS SQL server from django

On Wed, Jan 15, 2014 at 12:09 AM, Avraham Serour wrote: > I would try using some kind of DB explorer first, to make sure I have the > ip, port and auth right, once you are able using some other tool you can > just use the same settings in your code Do you know of any such beast for Linux? > On W

Re: Connecting to a MS SQL server from django

I would try using some kind of DB explorer first, to make sure I have the ip, port and auth right, once you are able using some other tool you can just use the same settings in your code On Wed, Jan 15, 2014 at 6:46 AM, Larry Martell wrote: > On Tuesday, January 14, 2014, Mark Moss wrote: > >> T

Re: Connecting to a MS SQL server from django

On Tuesday, January 14, 2014, Mark Moss wrote: > The default port for MySQL is 3306. Have you tried that one? > I'm not trying to connect to MySQL - I'm trying to connect to Microsoft SQL server. -- You received this message because you are subscribed to the Google Groups "Django users" group

Re: Connecting to a MS SQL server from django

On 01/14/2014 03: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: Database

Re: Connecting to a MS SQL server from django

The default port for MySQL is 3306. Have you tried that one? -- - Mark *Try this new Instant Django Hosting * -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubsc

Connecting to a MS SQL server from django

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