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:[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/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 <[email protected] <mailto:[email protected]>> 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
    <[email protected] <mailto:[email protected]>> wrote:

        On Wed, Jan 15, 2014 at 12:09 AM, Avraham Serour
        <[email protected] <mailto:[email protected]>> 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
        <[email protected] <mailto:[email protected]>>
        > 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 [email protected]
        <mailto:django-users%[email protected]>.
        >> To post to this group, send email to
        [email protected]
        <mailto:[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/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 [email protected]
        <mailto:django-users%[email protected]>.
        > To post to this group, send email to
        [email protected]
        <mailto:[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/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 [email protected]
        <mailto:django-users%[email protected]>.
        To post to this group, send email to
        [email protected]
        <mailto:[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/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 [email protected]
    <mailto:django-users%[email protected]>.
    To post to this group, send email to [email protected]
    <mailto:[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/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 [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/CAFWa6tLZO6qT0n07PztX7Q3d3Lo-ME11cV3P-bPZQ5Ba4HOz7g%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 [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/52DBD988.8020006%40bristle.com.
For more options, visit https://groups.google.com/groups/opt_out.

Reply via email to