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 -- mailto:fred@bristle.com -- 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/15/14 11: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-linux

[1] http://stackoverflow.com/questions/721852/developer-tools-to-directly-access-databases

[2] http://www.microsoft.com/en-us/download/details.aspx?id=8961

good luck

On Wed, Jan 15, 2014 at 6:42 PM, Adnan Sadzak <sadzak@gmail.com> wrote:

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-listen-on-different-ports-on-different-ip-addresses.aspx

http://blogs.msdn.com/b/walzenbach/archive/2010/04/14/how-to-enable-remote-connections-in-sql-server-2008.aspx

Check also FreeTDS project: http://www.freetds.org/

Cheers,

Adnan

On Wed, Jan 15, 2014 at 5:19 PM, Larry Martell <larry.martell@gmail.com> wrote:

On Wed, Jan 15, 2014 at 12:09 AM, Avraham Serour <tovmeod@gmail.com> 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 Wed, Jan 15, 2014 at 6:46 AM, Larry Martell <larry.martell@gmail.com>
> wrote:
>>
>> 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.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to django-users+unsubscribe@googlegroups.com.
>> To post to this group, send email to django-users@googlegroups.com.
>> 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/CACwCsY5qidVz3PcCxnCfSpJx134hL68cicMaZUCmRKRpLJ6%3DWQ%40mail.gmail.com.
>>
>> For more options, visit https://groups.google.com/groups/opt_out.
>
>
> --
> 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 django-users+unsubscribe@googlegroups.com.
> To post to this group, send email to django-users@googlegroups.com.
> 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/CAFWa6tKSNGb6PLenqH3h9FHxMpp%3De%2Bv_W686Aq71HnjsGL-%2B%2Bw%40mail.gmail.com.
>
> For more options, visit https://groups.google.com/groups/opt_out.

--
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 django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
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/CACwCsY4dstOYsGYZ8coq9CX2883w%2BW35YZrzduz3URieAN%3DELw%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
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 django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
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/CAG6E59UXfaBWyk9TgJaFSgFcQ_qsxTL94Sd9yQTySeD-amjcKw%40mail.gmail.com.

For more options, visit https://groups.google.com/groups/opt_out.

--
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 django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
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/CAFWa6tLZO6qT0n07PztX7Q3d3Lo-ME11cV3P-bPZQ5Ba4HOz7g%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.